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: 400

Filed under:

ado

|

access-2003

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

Asp.net ADO.NET Entity Framework or ADO.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm starting a new project based on ASP.NET and Windows server. The application is planned to be pretty big and serve large amount of clients pulling and updating high freq. changing data. I have previously created projects with Linq-To-Sql or with Ado.Net. My plan for this project is to use VS2010… >>> More
ADO.NET Entity Framework or ADO.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm starting a new project based on ASP.NET and Windows server. The application is planned to be pretty big and serve large amount of clients pulling and updating high freq. changing data. I have previously created projects with Linq-To-Sql or with Ado.Net. My plan for this project is to use VS2010… >>> More
RIA Services vs ADO.NET Data Services

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm currently in the process of creating a Silverlight 3 data driven application. To access the database, 2 common approaches are used: RIA Services and ADO.NET Data Services. Does anyone have any guidance on when/why to choose each approach? Here is what I've gathered from my research / experience… >>> More
Bogus InvalidOperationException (in a DataServiceRequestException)

as seen on Stack Overflow - Search for 'Stack Overflow'
I am having a hard time with ADO.NET Data Services (formerly code-named Astoria) as it gives me a bogus exception when I try to insert a new entity from the silverlight client and trying in a clean project (the same code) doesn't. In both cases, however, data is correctly inserted into the database… >>> More
What is ADO ?

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
What is ADO? ADO is a Microsoft technologyADO stands for ActiveX Data ObjectsADO is a Microsoft Active-X componentADO is automatically installed with Microsoft IISADO is a programming interface to access data in a databaseAccessing a Database from an ASP Page The common way to access a database… >>> More

Related posts about access-2003

MS Access 2003 - Embedded Excel Spreadsheet on Access form

as seen on Stack Overflow - Search for 'Stack Overflow'
lets say I have an embedded Excel Spreadsheet on a Microsoft Access form. I call the object frame ExcelFrame and I add a text box on the form called txtA1 and I add a button on the form called cmdInsert I want to type "Hello World" into the text box, click the button and have it appear in… >>> More
MS Access 2003 - Message Box: How can I answer "ok" automatically through code

as seen on Stack Overflow - Search for 'Stack Overflow'
So a couple silly questions: If I include this in some event: MsgBox " ", vbOkOnly, "This little message box" could I then with some more code turn around and 'click the ok button. So that basically the message boox automatically pops up, and then automatically goes away? I know its silly because… >>> More
Problem with Access 2003 linking tables with SQL Server 2008 using ODBC

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to link an Access 2003 DB to tables in a SQL Server 2008 database using ODBC. When I try to link to tables that have Primary Key established I get the following error message. " 'Pk_dbo.Batch_Claims' is not a valid name. Make sure that it does not include invalid characters or punctuation… >>> More
How do I create an Access 2003 MDE programmatically or by command line in Access 2007?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a legacy Access 2003 database file that must remain in that format to preserve its menus and toolbars. I have recently moved to Access 2007 in my build environment and will be deploying the compiled Access 2003 program with the Access 2007 runtime. In Access 2003, I could script the process… >>> More
MS Access 2003 - VBA for altering a table after a "SELECT * INTO tblTemp FROM tblMain" statement

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi. I use functions like the following to make temporary tables out of crosstabs queries. Function SQL_Tester() Dim sql As String If DCount("*", "MSysObjects", "[Name]='tblTemp'") Then DoCmd.DeleteObject acTable, "tblTemp" End If sql = "SELECT * INTO tblTemp from TblMain;" Debug.Print (sql) … >>> More