I am trying to access an access database through an ASP page. I have IIS setup on my personal machine and can run the script without error from any machine in the office. But when I try to setup the codeup on our company Intranet(running of a win 2000 server, sharepoint based) it fails to work and I get an error with this line of code:
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("emplist.mdb"
the error being ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process
I have narrowed it down to a privlages issue based on the fact that when I access it as a system administrator with access to EVERYTHING it works... I'm wondering if theres some IIS setting or perhaps permissions to DLL's... I just cant figure it out.
Cheers
Wake
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("emplist.mdb"
the error being ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process
I have narrowed it down to a privlages issue based on the fact that when I access it as a system administrator with access to EVERYTHING it works... I'm wondering if theres some IIS setting or perhaps permissions to DLL's... I just cant figure it out.
Cheers
Wake