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

ODBC Error 0x80004005 with multiple connections

P: n/a
Hello,

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")
conn.open "DSN=MyDSN;"
conn1.open "DSN=MyDSN;"
conn.close
set conn=nothing
conn1.close
Set conn1 = nothing
%>

--
Regards,
Yelena Varshal

Message posted via http://www.accessmonster.com
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.