Multiple Server Objects

[JackD4ME]

Hi All,
The problem I am running into seems to point to this but I am not positive. I am trying to create a second adodb server object to connect to a second db on the same page.

First connection (no problems):
set conn = server.createobject("adodb.connection&quot
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=dsntemp & "DBQ=" & server.mappath("test.mdb&quot
conn.Open DSNtemp

Second Connection:
folder=Left(sRst("Class ID&quot, Len(sRst("Class ID&quot)-1)
set conn2 = server.createobject("adodb.connection&quot
DSNtemp2="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp2=dsntemp2 & "DBQ=" & server.mappath(folder & "\" & folder & ".mdb&quot
conn2.Open DSNtemp2

The "folder" var holds a folder name with a corresponding db. This code is in a while loop and closes at the end of it. The folder var is correct, it has been tested.

Here is the error I keep getting:
General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x9a0 Thread 0xa64 DBC 0x2e6dfec Jet'.

Is there a problem with creating more than one connection?

Thanks,
Jack D

 

[woja]

Haven't seen this: I have a site that opens (more than 2) connections and it works OK (IIS5.5; MDAC 2.7).

[tt]________________________________________________________________
Roger
Life is a game of cards in which the deck contains only jokers.[/tt]

 

[JackD4ME]

Is it possible that it does not like the fact connection 2 goes to a sub-folder?

 

[JackD4ME]

Nevermind...I was programming this at 1 in the morning. I shoulda had some Jack! It does not have a problem with locating folders or the db w/in them as long as the name of the db is CORRECT!!! Thanks though

Jack D