By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,203 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,203 IT Pros & Developers. It's quick & easy.

ODBC Error 0x80004005 with multiple connections

P: n/a

I am using ODBC to access Microsoft Access database. I use just generic ADO
code. I don't have problems opening multiple connections from the same page
on the development server but the same code does not work on the production
server and on my Windows XP workstation running IIS. One connection opens
fine on the production server and on my workstation. But as soon as I add a
second connection I am getting an error:

Error Type:
Provider (0x80004005)
Unspecified error
/testaccess.asp, line 10

This is code for your reference. If I comment out lines for opening.closing
connection conn1 it works fine with one with only connection. It also works
fine with both connections on Development server. Does anyone know what
should I reconfigure to make it work on all computers?

<%@ EnableSessionState=False Language=VBScript %>
Dim conn 'As New ADODB.Connection
Dim conn1 'As New ADODB.Connection
Set conn = Server.CreateObject("ADODB.Connection")
Set conn1 = Server.CreateObject("ADODB.Connection") "DSN=MyDSN;" "DSN=MyDSN;"
set conn=nothing
Set conn1 = nothing

Yelena Varshal

Message posted via
Jun 1 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.