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: 356
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