Database problem with MS JET

Posted by Zimmy-DUB-Zongy-Zong-DUBBY on Server Fault See other posts from Server Fault or by Zimmy-DUB-Zongy-Zong-DUBBY
Published on 2009-09-03T20:01:30Z Indexed on 2010/04/10 14:03 UTC
Read the original article Hit count: 414

Filed under:
|

I am migrating a bunch of sites which each use an Access database (or whatever an MDB file is). If I try to load the site, I get the following error:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

If I rename the MDB file, I get a complaint that the file does not exist, which makes sense. If the file is named correctly, the site tries to load for about 30 seconds or so, and then just fails with the above message. During this waiting period, I can see a lock file being created (and then at some point removed). The MDB file and it's parent dir have full permissions granted to all users. Given that the lock file is successfully created and removed, I don't think that this is a "real" permission issue.

The OS is Windows Server 2003 SP2. I am not sure about much more detail on it's config wrt Access databases. I also don't know what version it is expected to be.

VB code in question:

set oConn=server.createobject("adodb.connection")
DSNtemp="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\fullPathGoesHere\db\sitedb.mdb"
oConn.Open DSNtemp

© Server Fault or respective owner

Related posts about ado

Related posts about access-2003