我用以下js连接正常
<%
var conn = Server.CreateObject("ADODB.Connection");
var myconn = "Provider=SQLNCLI;Server=192.168.123.39;Database=dbcar;Uid=sa;Pwd=123;";
conn.Open(myconn);
var rs = Server.CreateObject("ADODB.Recordset");
var sql = "SELECT * FROM cu";
rs.Open(sql, conn, 1, 1);
while (!rs.EOF)
{
Response.Write(rs(0));
rs.MoveNext();
}
%>
我换用vbs返回为空了,不知道为什么不行???:
<%
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLNCLI;Server=192.168.123.39;Database=dbcar;UID=sa;PWD=123"
Set rs = conn.Execute("SELECT * FROM cu")
While Not rs.EOF
Response.Write(rs(0))
rs.MoveNext
WEND
rs.Close
conn.Close
%>
如果我把Provider=SQLNCLI 换成Driver={SQL Server},网页提示:无效连接
我不想用数据源,可以不???
<%
var conn = Server.CreateObject("ADODB.Connection");
var myconn = "Provider=SQLNCLI;Server=192.168.123.39;Database=dbcar;Uid=sa;Pwd=123;";
conn.Open(myconn);
var rs = Server.CreateObject("ADODB.Recordset");
var sql = "SELECT * FROM cu";
rs.Open(sql, conn, 1, 1);
while (!rs.EOF)
{
Response.Write(rs(0));
rs.MoveNext();
}
%>
我换用vbs返回为空了,不知道为什么不行???:
<%
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLNCLI;Server=192.168.123.39;Database=dbcar;UID=sa;PWD=123"
Set rs = conn.Execute("SELECT * FROM cu")
While Not rs.EOF
Response.Write(rs(0))
rs.MoveNext
WEND
rs.Close
conn.Close
%>
如果我把Provider=SQLNCLI 换成Driver={SQL Server},网页提示:无效连接
我不想用数据源,可以不???