RE: BIG PROBLEM - setting rights (I think). Problem with .mdb file.

[garymgordon]

My admins don't know the answer so I am hoping someone here can help. PLEASE.

Problem with the following.

I have an asp script that is calling to an .mdb file. It is generating the following error:

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 0x6dc Thread 0x8d8 DBC 0x3ae460c Jet'.

/dept/its/statcountex/config.asp, line 99


The folder currently has READ/WRITE priv., but it seems that there is still a problem with the permissions, but I (and the admins here) don't know how to set them so the .mdb file can write what ever it needs within the folder.

Line 99 in config.asp reads as follows:

conn.open sConnStats

The connection string reads as follows:

sConnStats = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\data\stats.mdb"

As I said, the folder at d:\data\ is set with READ/WRITE priv. for EVERYONE.

So, .. what are we missing???

I really need help.

Thanks,
Gary

PS: There are no ODBC drivers installed on this server at the current time. Does that have anything to do with it??

What do I need to check for .. and make sure something is present .. in order for this to work?? I really need help - asap.



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

http://www.garymgordon.com/

 

[Beekle]

are you modifying data as write will only allow new files to be written, NT permissions require change access

 

[garymgordon]

Thanks.

Well, I am trying to find out if I need things installed on the server ... such as drivers???

And, if so, which ones specifically.

Thanks for the reply.

Gary


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

http://www.garymgordon.com/

 

[djhawthorn]

If you need ODBC drivers, MDAC (Microsoft Data Access Components) update a lot of the old ODBC drivers that come with NT at the time of install. MCSE NT4/W2K