Connecting to SQL Server 2005 using classic ASP

Posted by IXMonkey on Stack Overflow See other posts from Stack Overflow or by IXMonkey
Published on 2010-03-27T01:16:44Z Indexed on 2010/03/27 1:23 UTC
Read the original article Hit count: 324

Filed under:
|
|

I have installed both IIS and SQL Server 2005 on my laptop.

Both work individualy, however when I try to connect to an DB from an ASP page I keep getting the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "DB1" requested by the login. The login failed.

/testFiles/Connection/Connection.inc, line 5

Line 5 says:

con.open "DSN=DB1"

Can anybody tell me what the problem is?

Thanks

© Stack Overflow or respective owner

Related posts about sql-server-2005

Related posts about asp-classic