UC知道ASP远程连接数据库出错
来源：百度知道 编辑：UC知道 时间：2024/05/22 15:47:47
<%
set conn = server.createobject("adodb.connection" )
conn.connectionstring = "PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=10.210.153.242;DATABASE=exchange;UID=web;PWD=report;"
conn.open
%>
<html>
<head>
test
</head>
<body>
<table width="90%" border="1" cellpadding=1 cellspacing=0>
<tr><td>号码</td></tr>
<%
dim number
set rs=server.createobject("adodb.recordset")
sql="select device_number from semi_in_day_user where (user_number = '1901073099')"
rs.open sql,conn,1,1
number=rs("device_number")
response.write "<tr><td>"&number&"</td></tr>"
set rs=nothing
releaseconnection conn
%>
</body>
</html>
就是上面这段代码~运行出现以下错误：
Microsoft VBScript 编译器错误 错误 '800a03f6'
<
set conn = server.createobject("adodb.connection" )
conn.connectionstring = "PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=10.210.153.242;DATABASE=exchange;UID=web;PWD=report;"
conn.open
%>
<html>
<head>
test
</head>
<body>
<table width="90%" border="1" cellpadding=1 cellspacing=0>
<tr><td>号码</td></tr>
<%
dim number
set rs=server.createobject("adodb.recordset")
sql="select device_number from semi_in_day_user where (user_number = '1901073099')"
rs.open sql,conn,1,1
number=rs("device_number")
response.write "<tr><td>"&number&"</td></tr>"
set rs=nothing
releaseconnection conn
%>
</body>
</html>
就是上面这段代码~运行出现以下错误：
Microsoft VBScript 编译器错误 错误 '800a03f6'
<
缺少end不用管它。
1、你要看看
SERVER=10.210.153.242
这个服务器上有没有sql服务，
2、检查你的用户名密码是否错误。
3、检查sql server的验证方式是否为混合验证。
看看本机有没有 DRIVER={SQL Server}; 的驱动
我正在编程呢