works at home but not on host servers

[diablo]

Hi

I have played with this a bit and got it boiling down to the following
problem.

I do a call to my access database and get a recordset back. then whilst this
RS is still open I create a new RS and do another query. the second fails.

The thing is it works fine on my local ACCESS DB but when i upload it to my
providers server it fails on the second query.

Thanks for any help

D.

Here is the code

dim c1
c1 = "Driver=Microsoft Access Driver (*.mdb);DBQ=..."

' call one
dim rs, cn1
set cn1 = server.CreateObject("ADODB.Connection")
cn1.ConnectionString = c1
cn1.Open

set rs = server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = cn1
rs.Open "select * from blog"
Response.Write rs.Fields(2) & "<p />"

'call two
dim rrs, ccn1
set ccn1 = server.CreateObject("ADODB.Connection")
ccn1.ConnectionString = c1
ccn1.Open ' this is line 25 - where it is saying the failure occurs

set rrs = server.CreateObject("ADODB.Recordset")
rrs.ActiveConnection = ccn1
rrs.Open "select * from category"
Response.Write rrs.Fields(1) & "<p />"

ccn1.Close
set ccn1 = nothing
set rrs = nothing
' end of call two
cn1.Close
set cn1 = nothing
set rs = nothing
'end of call one
The output is like this --

Tigers in red weather (this is from the blog db)

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x1e94 Thread 0x1e60
DBC 0xfb20064 Jet'.

/hb/testdb.asp, line 25

[FreeviewClipper]

On Wed, 13 Jul 2005 13:38:14 GMT, "diablo" <di****@noplace.com> wrote:

Hi

I have played with this a bit and got it boiling down to the following
problem.

I do a call to my access database and get a recordset back. then whilst this
RS is still open I create a new RS and do another query. the second fails.

The thing is it works fine on my local ACCESS DB but when i upload it to my
providers server it fails on the second query.

Thanks for any help

D.

Here is the code

dim c1
c1 = "Driver=Microsoft Access Driver (*.mdb);DBQ=..."

' call one
dim rs, cn1
set cn1 = server.CreateObject("ADODB.Connection")
cn1.ConnectionString = c1
cn1.Open

set rs = server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = cn1
rs.Open "select * from blog"
Response.Write rs.Fields(2) & "<p />"

'call two
dim rrs, ccn1
set ccn1 = server.CreateObject("ADODB.Connection")
ccn1.ConnectionString = c1
ccn1.Open ' this is line 25 - where it is saying the failure occurs

set rrs = server.CreateObject("ADODB.Recordset")
rrs.ActiveConnection = ccn1
rrs.Open "select * from category"
Response.Write rrs.Fields(1) & "<p />"

ccn1.Close
set ccn1 = nothing
set rrs = nothing
' end of call two
cn1.Close
set cn1 = nothing
set rs = nothing
'end of call one
The output is like this --

Tigers in red weather (this is from the blog db)

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x1e94 Thread 0x1e60
DBC 0xfb20064 Jet'.

/hb/testdb.asp, line 25

Hi
This indicates that you do not have the necessary permissions to read
the registry key on the server (whereas you do on your own machine).
But why and what it is doing with this key I have no idea.
http://support.microsoft.com/default...;en-us;Q306518
(Troubleshooting guide for 80004005 errors in Active Server Pages and
Microsoft Data Access Components)
doesn't help much.

Why do you have two connections to the same database? (excuse me if I
am talking rubbish)
Are you using Access97? Many ISPs claim that you must use at least
2000 (or rather, JET4).
David