主题:VB访问别人的数据库,连接不到
^_^,本人刚刚接触VB。接到一个项目要设计一个小软件。在连接数据库方面存在不懂的问题,就在此发贴,望同仁们帮我看看,,十分感谢!!
Private Sub Form_Load()
Set conn = New ADODB.Connection
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;uer id=sa;password=sa;Initial Catalog=netdate;Data Source="
conn.CursorLocation = adUseClient
conn.Open
Set Rs = New ADODB.Recordset
Rs.Open "netuser", conn, adOpenDynamic, adLockOptimistic, 2
End Sub
上面是我连接本地数据库的代码,运行时候正常!!
我把连接的时候的代码改成下面的:就报错了,连不上
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;uer id=sa;password=sa;Initial Catalog=netdate;Data Source=192.168.8.67"
这该则么改呀!!急呀!!
Private Sub Form_Load()
Set conn = New ADODB.Connection
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;uer id=sa;password=sa;Initial Catalog=netdate;Data Source="
conn.CursorLocation = adUseClient
conn.Open
Set Rs = New ADODB.Recordset
Rs.Open "netuser", conn, adOpenDynamic, adLockOptimistic, 2
End Sub
上面是我连接本地数据库的代码,运行时候正常!!
我把连接的时候的代码改成下面的:就报错了,连不上
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;uer id=sa;password=sa;Initial Catalog=netdate;Data Source=192.168.8.67"
这该则么改呀!!急呀!!