how 2 connect directly 2 an access DB (different domain)?

[guineamation]

Hi all,
I'm trying a direct connection to an access DB located on a different Web Site, connection string:
MM_conn_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("255.255.255.255/data/myDB.mdb")

the error i'm getting is for the line where i try to use the connection string:
rs.ActiveConnection = MM_conn_STRING

the error:
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 0xf84 Thread 0x958 DBC 0x1f41b8c Jet'.

any suggestions?

 

[rjn2001]

The latest MDAC drivers (anything in the past six months), and especially the Access ODBC driver, have a "feature" that REQUIRES a SYSTEM temp variable be establised. This is done from right clicking My Computer, choosing Properties, Environment, and adding the system variables of TMP C:\TEMP and TEMP C:\TEMP.

(

http://www.15seconds.com/faq/Data Access/750.htm)

Richard Noon

http://www.davidmasonconsultancy.co.uk

 

[guineamation]

can u please advice on how to configure the "SYSTEM temp variable" on a host server and why does it matter to the connectivity?

 

[rjn2001]

I simply searched your error code on google, and that was the result.

Cant help more than that.




Richard Noon

http://www.davidmasonconsultancy.co.uk

 

[Tarwn]

Server.MapPath will not work on URI addresses. The way it works is to try to use the mappings in IIS for virtual web folders and resolve what the physical folder would be for the virtual address (on the local server) you have given it.

-T