Problem accessing an .mdb file. Getting an error. 3

[garymgordon]

Current situation.

Error message I am getting is:

=============

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x700 Thread 0x8bc DBC 0x241377c Jet'.

/its-database/njcu_directory/directory.asp, line 20

=============

Situation / Facts:

1) I have the exact same asp pages and same .mdb file running on (let's say) Server (#1) which is an NT server .. with the same (folder and file permissions - set the same as the one indicated below in part two of my situation) and everything is running fine.

2) On the other server, let's say this is Server (#2), which is also an NT server .. with the same folder and file permissions as on Server (#1) .. I get the error noted above.

Both servers have the Database Drivers installed.

But .. on Server #2, I am not sure what might be missing or not installed that could be creating this problem. Maybe somthing to do with the JET??

I need some advise as to what I should look for, what to check, etc. .. that might cause the above error and prevent my accessing the .mdb file.

Again .. it works fine on Server (#1), but on Server (#2) .. I get this error.

So, the script is fine.

Everything is in one folder. I am using MapPath to locate the .mdb file (which is in the same folder as the asp script). This is how it is set up on Server (#1) as well.

Very confusing.

I also have permissions set as FULL on IUSR (Guest Account) as well as EVERYONE - for the folder as well as the .mdb file.

What might not be installed?
Can I do something to test this?
It doesn't seem to be finding the .mdb file?

Help????

Gary


Gary M. Gordon, LLC
webmaster@garymgordon.com
Certified Web Developer ::
Application Programmer

http://www.garymgordon.com/

 

[krappleby025]

ok.. from past experience, this can be caused by

1.. the incorrect path for the database

or

2.. Permissions are not set correctly meaning the database cannot be opened..

I would suggest checking these two items again...

whenever i got that error, one of the above was always the problem

thanks

 

[BDC2]

Could try this

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=115

 

[garymgordon]

krappleby025,

I have checked and double checked the permissions and path. But neither seem to work.

BDC2,

Thanks. I will try this when I get back to the office and have access to the server. I am praying that this works. hahaha

But I appreciated the info. It looks like the best "new" thing to try.

Gary

Gary M. Gordon, LLC
webmaster@garymgordon.com
Certified Web Developer ::
Application Programmer

http://www.garymgordon.com/

 

[JamesLean]

Gary, I've also seen it suggested you use the OLEDB conn string rather than ODBC. Less error-prone I think. Here's a list of conn strings for Jet:

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMicrosoftJet

--James

 

[garymgordon]

Gary ... where did you go.

I am getting an error and "need" your help.

Gary

Gary M. Gordon, LLC
webmaster@garymgordon.com
Certified Web Developer ::
Application Programmer

http://www.garymgordon.com/

 

[garymgordon]

Thanks .. JamesLean

Gary

Gary M. Gordon, LLC
webmaster@garymgordon.com
Certified Web Developer ::
Application Programmer

http://www.garymgordon.com/