This topic is locked

Msaccess Db Connection Problems

1/15/2013 6:45:56 AM
ASPRunnerPro General questions
ffrinai author

Hi,

i have an .mdb database (DBServer.mdb) in a network dir mapped z:\

phprunner 5.3 works fine in project but after BUILD i can'i access to db, this is the error:
Warning: odbc_connect(): SQL error: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x2d88 Thread 0x1590 DBC 0x589e024 Jet'., SQL state S1000 in SQLConnect in C:\SitiWeb\WebPriv\dbserver\include\dbconnection.php on line 9 Fatal error: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x2d88 Thread 0x1590 DBC 0x589e024 Jet'. in C:\SitiWeb\WebPriv\dbserver\include\dbconnection.php on line 12
If i check the option "Copy database to the output folder" with default path "db" when specify the database file, the program works fine
why must i copy the db in out folder when in file path i put Z:\DBServer.mdb ?
thanks
(sorry for my english)

Sergey Kornilov admin 1/15/2013

IIS runs ASP pages under a very limited IUSR account that may not have access right to Z: mapped drive.
Check this article for a solution:

http://xlinesoft.com/articles/remote_asc_db.htm