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?
<%@ EnableSessionSt ate=False Language=VBScri pt %>
<%
Dim conn 'As New ADODB.Connectio n
Dim conn1 'As New ADODB.Connectio n
Set conn = Server.CreateOb ject("ADODB.Con nection")
Set conn1 = Server.CreateOb ject("ADODB.Con nection")
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