我的VB连接数据库代码错在哪里？

[php_wsd]

connstr = "Provider=SQLOLEDB.1;Persist Security Info=true;User ID=" & db_username & ";pwd=" & db_password & ";Initial Catalog=" & db_name & ";Data Source=(" & db_filename & ")"
这是我的连接sqlserver的代码，连接本机正常，但是我连接远程数据库就不行了，错在哪里？

[goosen]

帮顶

[xbin_2009]

远程数据库要注意路径里的双斜线“\\SharePC\ShareFolder”的处理,以及读取权限。

[llifang87]

connstr = "Provider=SQLOLEDB.1;Persist Security Info=true;User ID=" & db_username & ";pwd=" & db_password & ";Initial Catalog=" & db_name & ";
你这用的是字符串连接，看看你的ADODC属性里的字符串可是这个。

[白发程序猿]

datasource用文件名？我没用过
我一般都用IP或ODBC数据源名

[max_shell]

试试：
connstr = "Provider=SQLOLEDB.1;Persist Security Info=true;User ID=" & db_username & ";pwd=" & db_password & ";Initial Catalog=" & db_name & ";Data Source=" & db_filename & ""

[饮水需思源]

dim conn as new adodb.connection
with conn
    If .State = adStateOpen Then .Close
    .ConnectionString = "driver=SQL Server;server=计算机名或IP地址;uid=sa;pwd=;database=数据库名"
    .CommandTimeout = 0
    .Open
End With