ODBC Error 0x80004005 with multiple connections

[Yelena Varshal]

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