Question

asp连接SQL Server 2005有问题？？

set conn=server.createobject("adodb.connection")
conn.connectionstring="PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=127.0.0.1;DATABASE=test;UID=sa;PWD=123;"
conn.open

总是说一般性网络错误,不知是sql server装的不对，还是代码有问题?

Answer 1

set conn=server.createobject("adodb.connection")
connectionstring="PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=127.0.0.1;DATABASE=test;UID=sa;PWD=123;"
conn.open connectionstring

试试这个