我用VB 编写了一个访问数据库的程序,报错为“运行时错误’-2147467259(0x80004005)’”
【DBNMPNTW]connectionOpen(CreateFile()) 内容如下:
Dim con As ADODB.Connection
Set con = New ADODB.Connection
Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset con.CommandTimeout = 0
con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID= sa;password=sa;Initial Catalog=Bam;Data Source=192.45.0.45"
【DBNMPNTW]connectionOpen(CreateFile()) 内容如下:
Dim con As ADODB.Connection
Set con = New ADODB.Connection
Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset con.CommandTimeout = 0
con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID= sa;password=sa;Initial Catalog=Bam;Data Source=192.45.0.45"
con.Open "provider=SQLOLEDB.1;server=local;persist security info=false;UID=sa;pwd=415024522;database=Drug"
另con.CommandTimeout = 0
最好不要设为0
如果出来的版本号是8.00.760以下,就必须加补丁。另外如果这台机器上安装有isql的话,也可以去试着连接,测试是否网络是连通的。
con.CommandTimeout = 30
还差不多
2,在客户端的按制面板中手工配制ODBC到SQL服务端(tcp/ip与named pipes都测试一下)