asp中数据库连接不上
错误类型:
ADODB.Connection (0x800A0E7A)
未找到提供程序。该程序可能未正确安装。
/Web/test/Login/verifyID.asp, 第 24 行
代码:
set conn=server.createobject("ADODB.Connection")
conn.open"Provider=MDASQL;Driver={SQL Server};"_
&"Server=VASIONHOME;"_
&"Database=LearnAsp;"_
&"Uid=sql;Pwd=sql"
set rs=server.createobject("ADODB.Recordset")
sql="select USER_NAME from UserInfo where(USER_NAME="'&strUserName&'" and PASSWORD="'&strPassword&'")"
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]用户 'sql' 登录失败。
/Web/test/Login/verifyID.asp, 第 24 行
set conn=server.createobject("ADODB.Connection")
conn.open"Driver={SQL Server};"_
&"Server=VASIONHOME;"_
&"Database=LearnAsp;"_
&"Uid=sql;Pwd=sql"
set rs=server.createobject("ADODB.Recordset")
sql="select USER_NAME from UserInfo where(USER_NAME="'&strUserName&'" and PASSWORD="'&strPassword&'")"