ADODB Connection help PLEASE!!!!!!

[hopper]

I've been using Access 97 and am trying to convert my ASP front end to use Access 2000. I've encountered some problems with converting my code to use ADO objects. Well I managed to work through most of them but there seems to be one problem I keep encountering....
When I first make the connection, everything works fine. Then I close the connection in my code. The next time I need to open the connection again, I get an "Unspecified" error. If I wait for about 1-2 minutes, then the connection works again, but I must wait again before making another connection.... If anyone knows what I'm doing wrong I'd sure appreciate the help.

webserver - Win2K advanced w/ IIS 5
database - Access 2000

Thanks,
Scott

 

[StewartGW]

How are you declaring the connection string?

 

[hopper]

set conn=Server.CreateObject("ADODB.Connection&quot
conn.Open("SiteVisit&quot
set RS = Server.CreateObject("ADODB.recordset&quot
strSQL = "SQL string..."
RS.Open (strSQL), conn

'Read RS into an array

RS.Close
set RS=nothing
conn.Close
set conn=nothing

then work with the array leaving the conn closed until needed again.

 

[hopper]

Sorry, I'm using an ODBC system DSN