ODBC error related to database access 1

[missippi]

Hi,

I have a windows 2000 server installed IIS 5 all the documentation points to permission problems. Everyone has read/write/execute/script on the file and folders that our database is in. Could be a server setting? I am trying to access a database using asp code. This same code works on windowsXP and 98 machines.




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 0x6f0 DBC 0x20d0e6c Jet'.
/project/login.asp, line 11

 

[link9]

That error message typically will mean 1 of 3 things:

(1) the database is open somewhere (it must be closed)

(2) the connection to the database has not been released by the last load of the page (e.g. set connection = nothing)

(3) multiple users are trying to access the data at the same time, raising this error.

Access really isn't meant to work on the web, no matter what anyone tells you, and is problematic (at best) in doing so.

MySQL is free, ya know. ;-)

paul

 

[schase]

I ran into a similiar item - with mine it was just my connection script was below the recordsets.

But some documents that Microsoft has says to remove the database connection and create a system database connection (on the server - not connection string like odbc connection (i've never fooled with OleDB))
Tried to find the link for you - but couldnt with my time left.




"Insert witty remark here"

Stuart