请问我用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
OdbcConnection.CursorDriver = rdUseOdbc
OdbcConnection.Connect = connectStr
OdbcConnection.LoginTimeout = 5
OdbcConnection.LogMessages = False
OdbcConnection.EstablishConnection rdDriverPrompt, False
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
OdbcConnection.CursorDriver = rdUseOdbc
OdbcConnection.Connect = connectStr
OdbcConnection.LoginTimeout = 5
OdbcConnection.LogMessages = False
OdbcConnection.EstablishConnection rdDriverPrompt, False
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货