紧急求救:VB与SQL Server 连接的问题
SQL服务器是WYH
数据库名是englishtest
代码如下:
connlogin.Provider = "sqloledb"
connlogin.CursorLocation = adUseClient
connlogin.Mode = adModeUnknown
connlogin.ConnectionString = "User ID=admin;Data Source=D:\Microsoft SQL Server\MSSQL\Data\englishtest.data"
connlogin.Open
'rslogin.LockType = adLockOptimistic
'rslogin.CursorType = adOpenKeyset
'Set rslogin.ActiveConnection = connlogin
'rslogin.Open "select * from login"
可是提示是无效的连接.
错在那里,正确的代码该如何写???谢谢!!