Database Connection Issue

[btalon]

I'm having trouble with my webpage after I moved it over to a 2003 Server. It ran fine on my machine (the asp files were on my 2000 machine during development, accessing an Access 97 database on an NT Server). I moved the database to the 2003 server as well. I am getting 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 0x13e4 Thread 0xd10 DBC 0x1549024 Jet'.

Here is the connection string it is erroring out on:
Conn.open "DBQ=C:\Data\ProductionArt.mdb;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;MaxBufferSize=8192;Threads=20;", "username", "password"

I can't get it figured out. I've tried a couple different connection strings (some just like the one I use on the version on my pc where it works.

Any ideas?

 

[MoLaker]

Just a guess, but make sure the user described in your connection string has read, write and delete permissions for the directory where the database resides. Then consider using Microsoft.Jet.OLEDB.4.0 as your driver.

 

[btalon]

I tried a different connection string:

Conn.open "Provider=Mircrosoft.Jet.OLEDB.4.0; DataSource=" & Server.mappath("\Data\ProductionArt.mdb") & ";" & "Jet OLEDBatabase Password=mypassword"

And here is the error message I'm getting now:

ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.

Any more suggestions?

 

[ChrisHirst]

in red

Conn.open "Provider=Mi[red]r[/red]crosoft.Jet.OLEDB.4.0; DataSource=" & Server.mappath("\Data\ProductionArt.mdb") & ";" & "Jet OLEDBatabase Password=mypassword"

Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[btalon]

Ahh, the details. Anyway, here is the new error message:


Microsoft JET Database Engine error '80004005'

Could not find installable ISAM.

Could there be a setting in Server 2003 that I am missing?

 

[btalon]

I finally got everything to work correctly. It was a permissions problem, but I have yet another question. The target database (which is the database my code is pointing to) is linked to another database on a different server. Everything runs fine if I'm accessing the data that is not linked in the target database, but when I try to access the tables that are linked, I get an error. Can you successfully link two databases on two different servers and be able to retreive the data using ASP. It seems that there are some more persmissions issues when the target database tries to get the data out of its linked tables.

 

[DreXor]

you'll need to generate a paired set of accounts ( one on each machine ) with change permissions on the DB housing folder, this way the two machines can access back and forth as per necessary for data.


if i happen to come across the MS article on it i'll post the link here.

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!