ASP下的连接问题

[snowwave]

数据库在远程
在本机上测试ASP、客户端都能正常访问
上传至虚拟主机后，会报
[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.
不知是何故？？？

[pengdali]

你用odbc?
改用ado吧。

[pengdali]

<%
dim a,b,c
set a=server.createobject("adodb.connection")
a.open"driver={ sql server};server=机器名;uid=sa;pwd=密码;database=库名"
b="select * from xsjk"
set c=server.createobject("adodb.recordset")
c.open b,a
response.write c("user")&"<br>"

%>

[zjcxc]

你的连接有问题.

[zjcxc]

--或者用:

<%
set db=server.createobject("adodb.connection")
db.open "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=用户名;Password=密码;Initial Catalog=数据库名;Data Source=SQL服务器名"
%>

[leeboyan]

<%
Dim cnn, StrCnn
Set cnn = Server.CreateObject("ADODB.Connection")
StrCnn= "Driver{SQLServer};Server=192.168.200.50;UID=sa;PWD=sa;Database=seattable"
cnn.Open StrCnn
%>

[red-fly]

Not person, but the book is too bad for study!
You shouldn't buy the book like this!

__________________
\ /
\ /
\ /
\ /
\ /
\ /
\ /
\ /
\/
Book