请问我用VB编写的数据库ODBC连接SQL数据库,不知道为什么总出现SQL登录窗口,怎样屏蔽这个登录窗口With frmmain
connectStr = "AutoCommit = true;UID=" & Trim(.UID.Text) & ";PWD=" & Trim(.PWD.Text) & ";DATABASE=" & _
Trim(.DataBase.Text) & ";DRIVER={SQL SERVER};Srvr=" & Trim(.Server.Text)
End With dbcConnection.CursorDriver = rdUseOdbc
OdbcConnection.Connect = connectStr
OdbcConnection.LoginTimeout = 5
OdbcConnection.LogMessages = False
OdbcConnection.EstablishConnection rdDriverPrompt, False
connectStr = "AutoCommit = true;UID=" & Trim(.UID.Text) & ";PWD=" & Trim(.PWD.Text) & ";DATABASE=" & _
Trim(.DataBase.Text) & ";DRIVER={SQL SERVER};Srvr=" & Trim(.Server.Text)
End With dbcConnection.CursorDriver = rdUseOdbc
OdbcConnection.Connect = connectStr
OdbcConnection.LoginTimeout = 5
OdbcConnection.LogMessages = False
OdbcConnection.EstablishConnection rdDriverPrompt, False
总出现SQL登录窗口应该是ConnectString不正确造成的
Delphi中是这样子的,如果不设置为False就会弹出登录窗口。