sos!无法查找到指定的sql server!在线等! 我在vb里做了一个小程序,通过adbdb登陆到远程sql server,程序在我的本本上(装有sql server)可以正常运行,拷贝到其它机器上运行时总是提示“无法查找到指定的sql server!”究竟是什么回事?该如何处理?先谢了! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 修改数据库连接字符串"Provider=sqloledb;Data Source=localhost;Initial Catalog=pubs;User Id=sa;Password=asdasd;" 改为"Provider=sqloledb;Data Source=本本的IP或者机器名称;Initial Catalog=pubs;User Id=sa;Password=asdasd;" 我需要连接的是远程的数据库,在本本上可用(装有sql server),拷贝到其它机器上不能用 Dim Conn As New ADODB.ConnectionDim strconn As Stringstrconn = "driver=SQL Server;server=*.*.*.*;uid=galen;pwd=galen;database=galen"If Conn.State = adStateOpen Then Conn.CloseConn.ConnectionString = strconnConn.CommandTimeout = 10Conn.Open 你用ADODC里的连接字符串试试. '远程库sys_log Syslog(0) = "Provider=SQLOLEDB.1;" & _ "Persist Security Info=False;" & _ "Password=" & password & ";" & _ "User ID=" & UserName & "; " & _ "Initial Catalog=sys_log;" & _ "Data Source=" & ServerString & "" '本地库sys_log Syslog(1) = "Provider=SQLOLEDB.1;" & _ "Integrated Security=SSPI;" & _ "Persist Security Info=False;" & _ "Initial Catalog=sys_log;" & _ "Data Source =" & ServerString & "" 最主要的问题的,程序在我的本本上可以连接到远程的数据库,拷贝到别处后运行就提示无法找到指定的sql server. why??? 具体提示信息为:运行时错误‘-2147467259(80004005)':[microsoft][odbc sql server driver][named pippes]没有发现指定的sql server.God save me! True1024() 是对的,无分相送,唯能感谢! True1024() 是对的,无分相送,唯能感谢! 计算上问题[50分] 用户控件如何将自己作为参数传递到公共模块中的函数中去? Picturebox载入 ICO文件的的问题 求:包函子报表的的水晶报表如何调用? ▲▲▲▲▲▲ 再次请CSDN的Blog团队来回答我的这个问题 ▼▼▼▼▼▼ 窗体上有很多控件.如果判断某一个控件具有焦点? 问题得到了解决,高兴,散分 能不能在运行时改变textbox控件的dataField ?应该怎么编程呢? water_j(随心所欲),领分!!!! 如何在vb6.0下调用api函数来实现win2000下的关机程序 如何理解用VC++为VB开发的DLL??? 在发邮件时需要设置smtp协议,请问如何在vb实现?
"Provider=sqloledb;Data Source=localhost;Initial Catalog=pubs;User Id=sa;Password=asdasd;" 改为"Provider=sqloledb;Data Source=本本的IP或者机器名称;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
Dim strconn As Stringstrconn = "driver=SQL Server;server=*.*.*.*;uid=galen;pwd=galen;database=galen"
If Conn.State = adStateOpen Then Conn.Close
Conn.ConnectionString = strconn
Conn.CommandTimeout = 10
Conn.Open
'远程库sys_log
Syslog(0) = "Provider=SQLOLEDB.1;" & _
"Persist Security Info=False;" & _
"Password=" & password & ";" & _
"User ID=" & UserName & "; " & _
"Initial Catalog=sys_log;" & _
"Data Source=" & ServerString & ""
'本地库sys_log
Syslog(1) = "Provider=SQLOLEDB.1;" & _
"Integrated Security=SSPI;" & _
"Persist Security Info=False;" & _
"Initial Catalog=sys_log;" & _
"Data Source =" & ServerString & ""
运行时错误‘-2147467259(80004005)':[microsoft][odbc sql server driver][named pippes]没有发现指定的sql server.God save me!