大俠 问个关于asp连SQL server的问题# Database - 数据库
m*h
1 楼
asp运行正常
sql server 运行正常
在ODBC Driver里设置了File DSN, 产生了一个名字叫sqlserver.dsn 的文件
运行下面这段code:
'Create a connection object
Set cn = Server.CreateObject("ADODB.Connection")
'Open a connection; the string refers to the DSN
cn.Open "FILEDSN=sqlserver.dsn"
%>
出错信息如下:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]用户 'xxx\IUSR_xxx' 登录失败。//(xxx is the server name)
/myweb/testasp.asp, line 13
Any idea? thanks
sql server 运行正常
在ODBC Driver里设置了File DSN, 产生了一个名字叫sqlserver.dsn 的文件
运行下面这段code:
'Create a connection object
Set cn = Server.CreateObject("ADODB.Connection")
'Open a connection; the string refers to the DSN
cn.Open "FILEDSN=sqlserver.dsn"
%>
出错信息如下:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]用户 'xxx\IUSR_xxx' 登录失败。//(xxx is the server name)
/myweb/testasp.asp, line 13
Any idea? thanks
