Cannot connect DB though conn. tested sucessfully?

Dragonist · August 4th, 2004, 10:42 PM

I have posted the similiar question in the ADO.NET about the same problem too, I once thought it is my connection string problem at first, but seemed like it doesn't.

I had tried to connect an Access DB through design mode for testing. The initial connection was tested successfully. I created a datagrid binded to that data and the preview of the data is successfully shown.

Then the same problem arised again when I tried to debug it, it gives the following errors:

Server Error in '/WebApplication3' Application.
----------------------------------------------------------------------
The Microsoft Jet database engine cannot open the file '\\spngweb3\MSDSPenang\msdsback.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

How come? I have already successfully preview the dataset?

Santhi · August 5th, 2004, 12:01 AM

This error occurs normally when another process or user has the database access open.

Dragonist · August 5th, 2004, 01:17 AM

Yes the database is currently used by another program called MSDSFinder, while I am writing a program to select query from it. It is nothing about update the data, just simply querying.

What should I do?

Imar · August 5th, 2004, 01:18 AM

Hi there,

Take a look at this FAQ: http://imar.spaanjaars.com/QuickDocID.aspx?QUICKDOC=263

It talks about ASP, but the idea is the same for ASP.NET.

Cheers,

Imar

Santhi · August 5th, 2004, 01:26 AM

Check out this if this could help you...
http://support.microsoft.com/default...b;en-us;306269

Dragonist · August 5th, 2004, 02:23 AM

hmm.... apparently I am not given the authorise to test the permission setting yet, but it really match the problem currently. I will refer to my boss for further instruction, I will see if the problem can be solved or not. Thanx!