Nick,

Disable Friendly HTTP error messages in IE so you can get a better
explanation of the error.
Click Tools then Internet Options. Click the Advanced tab then uncheck "Show
friendly HTTP error messages."
Now hit the page again and note the error you see.

Also.. How are you connecting to your database if you don't have a DSN?

Rod


----- Original Message -----
From: "Nick" <Nick@s...>
To: "ASP Databases" <asp_databases@p...>
Sent: Sunday, April 14, 2002 8:02 PM
Subject: [asp_databases] Try to open multiple tables


> Hello
> I've a DB made with Access with many tables... I have to open 3 tables in
> a page and if on my pc everything goes well, on server it gives me this
> error:
>
> An error occurred on the server when processing the URL. Please contact
> the system administrator.
>
>
> this is my code to opening many tables. I've no DSN.
>
>
> Dim rs, rs1, rs2, foundit,
> Set rs = Server.CreateObject("ADODB.Recordset")
> rs.Open "Tbl_1k", connStr, 2, 4
>
> Set rs1 = Server.CreateObject("ADODB.Recordset")
> rs1.Open "Tbl_2k", connStr, 2, 4
>
> Set rs2 = Server.CreateObject("ADODB.Recordset")
> rs2.Open "Tbl_3k", connStr, 2, 4
>
> what's the error?
>
> Nick
>

Hello
I've a DB made with Access with many tables... I have to open 3 tables in 
a page and if on my pc everything goes well, on server it gives me this 
error: 

An error occurred on the server when processing the URL. Please contact 
the system administrator. 


this is my code to opening many tables. I've no DSN. 


Dim rs, rs1, rs2, foundit, 
Set rs = Server.CreateObject("ADODB.Recordset") 
rs.Open "Tbl_1k", connStr, 2, 4 

Set rs1 = Server.CreateObject("ADODB.Recordset") 
rs1.Open "Tbl_2k", connStr, 2, 4 

Set rs2 = Server.CreateObject("ADODB.Recordset") 
rs2.Open "Tbl_3k", connStr, 2, 4 

what's the error?

Nick