lijin1
asked on
ASP can not open the connection of SQL Server
I use "...Set Conn = Server.CreateObject("ADODB .Connectio n")
Conn.Open "DSN=cargo;UID=cargo;PWD=c argo;;" ..." in my ASP file,it work well in my PWS of WIN95.But when I run this ASP in IIS3.0 in NT,error occur,"Microsoft OLE DB Provider for ODBC Drivers error'80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: _ Reason: Not defined as a valid user of a trusted SQL Server connection"
What's the reason?Thank you very much!
Conn.Open "DSN=cargo;UID=cargo;PWD=c
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: _ Reason: Not defined as a valid user of a trusted SQL Server connection"
What's the reason?Thank you very much!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER