Unable to open registry key 'Temporary (volatile) Jet DSN...

When I run my asp code within the machine all is fine. But when I open my page via the internet I get the following error -

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 0x594 Thread 0x5a0 DBC 0x2118024 Jet'.
/processUserLogIn.asp, line 28


I have looked at previously asked questions but the things I tried did not work. I have not upgraded my MDAC - how can I tell what ver. I have on my server - if this in fact is the problem.

Here is my code -

Dim sSQL, oConn
Dim sDBPath
Dim varName, varPassword, connString, pwRS, varClient, retMsg

sDBPath = "DBQ=Server.MapPath(C:\Inetpub\wwwroot\Tracking\MasterFleet2000.mdb)"

set oConn=Server.CreateObject("ADODB.connection")
connString = "DRIVER={Microsoft Access Driver (*.mdb)}; "
connString = connString + sDBPath
oConn.open connString
set pwRS=Server.CreateObject("ADODB.recordset")
pwRS.CursorLocation = 3 'adUseClient
pwRS.LockType = 3


It fails at line -

oConn.open connString

Malek103197Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ManuelMSPCommented:
0
Malek103197Author Commented:
I did follow the instructions but still the same error.
0
CJ_SCommented:
sDBPath = "DBQ=C:\Inetpub\wwwroot\Tracking\MasterFleet2000.mdb"
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

thirdCommented:
you either use,

set oConn=Server.CreateObject("ADODB.connection")
oConn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0"
oConn.open server.mappath("MasterFleet2000.mdb")

or

set oConn=Server.CreateObject("ADODB.connection")
oConn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0"
oConn.open "C:\Inetpub\wwwroot\Tracking\MasterFleet2000.mdb"

server.mappath returns the physical location of a virtual file.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pforemanCommented:
I suggest using this connection string instead.  I have far less problems using the JET driver than the ACCESS MDB driver.

Dim oConn
set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "DATA SOURCE=c:\database.mdb"

//PF
0
ManuelMSPCommented:
Did you check the Registry
permissions for the key described in the error message. AND
Check the permissions of your IIS IUSER. The "IUSER_<machine
name>" anonymous Internet user account must have "Read" permission.

0
ManuelMSPCommented:
I found this also:

Microsoft has added a "feature" to access that RESETS
permissions on database files on your webserver whenever you run the
"repair and compact database" utility on that file.  Dont ask me why,
or if it does it on all machines- I dont know.  But on my server,
every single time (100%) when I "repair and compact" my *.mdb file, it
REMOVES the "IUSR_*" account on the file permissions.  I then must go
back and manuall grant "write" access to "IUSR_*" account on the *mdb
database, and presto!
0
Wouter BoevinkMasterCommented:
Is your disk full?
0
Malek103197Author Commented:
ManuelMSP - how do I do this?
0
Malek103197Author Commented:
That did it! I used -

set oConn=Server.CreateObject("ADODB.connection")
oConn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0"
oConn.open server.mappath("MasterFleet2000.mdb")

and it is now working - thanks for the excellent advice, and thanks to all who contributed.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.