Hello,

I have the following message:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open 
registry key 'Temporary (volatile) Jet DSN for process 0x64c Thread 0x58c 
DBC 0x1330ad4 Jet'.
/search/_connexion.asp, line 8

I'm trying to connect a database on a remote computer, here's the code.


<%
Set conn = Server.CreateObject ("ADODB.Connection")

conn.open "DBQ=\\freedom\share\filing2000.mdb;Driver={Microsoft Access 
Driver (*.mdb)};DriverId=25;FIL=MS Access;"

Set rs = Server.CreateObject("ADODB.Recordset")

rs.close
conn.close
set conn=nothing
set rs=nothing

%> 
 
If someone have an idea.

Regards.

Manu.

try using this format
<% 
    Conn_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" 
    Conn_STRING = MM_ConnClimateSurvey_STRING & server.mappath
("\departments\data\db1.mdb") 
    set conn = Server.CreateObject("ADODB.Connection") 
    conn.open Conn_STRING
%>
damo



> Hello,

> I have the following message:
E> rror Type:
M> icrosoft OLE DB Provider for ODBC Drivers (0x80004005)
[> Microsoft][ODBC Microsoft Access Driver]General error Unable to open 
r> egistry key 'Temporary (volatile) Jet DSN for process 0x64c Thread 
0x58c 
D> BC 0x1330ad4 Jet'.
/> search/_connexion.asp, line 8

> I'm trying to connect a database on a remote computer, here's the code.

> 
<> %
S> et conn = Server.CreateObject ("ADODB.Connection")

> conn.open "DBQ=\\freedom\share\filing2000.mdb;Driver={Microsoft Access 
D> river (*.mdb)};DriverId=25;FIL=MS Access;"

> Set rs = Server.CreateObject("ADODB.Recordset")

> rs.close
c> onn.close
s> et conn=nothing
s> et rs=nothing

> %> 
 > 
I> f someone have an idea.

> Regards.

> Manu.

Hello, 
Thanks for your reply it doesn't work, in fact I try to access the database
on a remote computer \\freedom\share\whatever.mdb

And the mappath it's for virtual path 'I think'.

Regards.

Emmanuel.


-----Original Message-----
From: damian lynch [mailto:damian.lynch@o...]
Sent: mardi 10 septembre 2002 19:53
To: Access ASP
Subject: [access_asp] Re: Help problem with conn.open on a remote
computer


try using this format
<% 
    Conn_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" 
    Conn_STRING = MM_ConnClimateSurvey_STRING & server.mappath
("\departments\data\db1.mdb") 
    set conn = Server.CreateObject("ADODB.Connection") 
    conn.open Conn_STRING
%>
damo



> Hello,

> I have the following message:
E> rror Type:
M> icrosoft OLE DB Provider for ODBC Drivers (0x80004005)
[> Microsoft][ODBC Microsoft Access Driver]General error Unable to open 
r> egistry key 'Temporary (volatile) Jet DSN for process 0x64c Thread 
0x58c 
D> BC 0x1330ad4 Jet'.
/> search/_connexion.asp, line 8

> I'm trying to connect a database on a remote computer, here's the code.

> 
<> %
S> et conn = Server.CreateObject ("ADODB.Connection")

> conn.open "DBQ=\\freedom\share\filing2000.mdb;Driver={Microsoft Access 
D> river (*.mdb)};DriverId=25;FIL=MS Access;"

> Set rs = Server.CreateObject("ADODB.Recordset")

> rs.close
c> onn.close
s> et conn=nothing
s> et rs=nothing

> %> 
 > 
I> f someone have an idea.

> Regards.

> Manu.


________________________________________________
This message is confidential. It may also be privileged or 
otherwise protected by work product immunity or other legal
rules. If you have received it by mistake please let us know
by reply and then delete it from your system; you should not
copy the message or disclose its contents to anyone.

Please refer to <http://www.linklaters.com/regulation> for
important information on the regulatory position of the firm.