您所在位置：主题：VB访问别人的数据库，连接不到
asdccc
[专家分：0] 发布于 2008-04-18 10:57:00
^_^，本人刚刚接触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"
这该则么改呀！！急呀！！
