Classic ASP Discussion - Database problem

Print Page | Close Window

Database problem

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=10213
Printed Date: 31 March 2026 at 4:33pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Database problem

Posted By: Leeb65
Subject: Database problem
Date Posted: 29 April 2004 at 8:28am

I have setup a new server WS2003, I have a "System DSN" that points to an Access database.

When I try to access the DB I get the following Error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

/erfinderclubs/asp/db_erfcl.asp, line 15

The code that is causing the problem is:


Set conn = Server.CreateObject("ADODB.Connection") 
conn.open "erfinder","",""    'Error here!!
sql = "SELECT Erfindungen.Titel, Erfindungen.ErfindungsNr FROM [Erfindungen] order by Titel" 
Set rs = Server.CreateObject("ADODB.Recordset") 
rs.Open sql, conn, 3, 3

Can anyone help me please? it all worked on the other server but I didn't set that one up and I have never had problems like this before.

Have I forgotten to include something?

-------------
Lee

http://www.rheinsitemedia.de">

Replies:

Posted By: dpyers
Date Posted: 29 April 2004 at 11:42am

What's in errfinder?

-------------

Lead me not into temptation... I know the short cut, follow me.

Posted By: Semikolon
Date Posted: 29 April 2004 at 12:29pm

try with a DSN Less connection, faster and more stable

but shouldn't the DSN connection string be "DSN=DSN Name"?

Posted By: michael
Date Posted: 29 April 2004 at 1:14pm

dpyers wrote:

What's in errfinder?

Erfinder is german for Inventor

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker