473,804 Members | 3,010 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Error when connecting to Microsoft Access db

I get an error when I connect to my mdb. I know for sure that I dont have
it open and that the path is correct.

Here's the error:

System.Data.Ole Db.OleDbExcepti on: The Microsoft Jet database engine cannot
open the file 'C:\Inetpub\www root\MyTest\MyD atabase.mdb'. It is already
opened exclusively by another user, or you need permission to view its data.
at System.Data.Ole Db.OleDbConnect ion.ProcessResu lts(Int32 hr) at
System.Data.Ole Db.OleDbConnect ion.InitializeP rovider() at
System.Data.Ole Db.OleDbConnect ion.Open() at
LatLongTest.Ema ilNotification. GetEmailRecipie nts() in
c:\inetpub\wwwr oot\LatLongTest \EmailNotificat ion.aspx.vb:lin e
118System.Inval idOperationExce ption: ExecuteReader requires an open and
available Connection. The connection's current state is Closed. at
System.Data.Ole Db.OleDbConnect ion.SetStateExe cuting(OleDbCom mand attempt,
String method, Boolean flag) at
System.Data.Ole Db.OleDbCommand .ValidateConnec tionAndTransact ion(String
method, Int32& localState) at
System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior
behavior, String method) at
System.Data.Ole Db.OleDbCommand .ExecuteReader( CommandBehavior behavior) at
LatLongTest.Ema ilNotification. GetEmailRecipie nts() in
c:\inetpub\wwwr oot\LatLongTest \EmailNotificat ion.aspx.vb:lin e 132

Nov 18 '05 #1
2 1362
Try this?

PRB: Cannot Connect to Access Database from ASP.NET

http://support.microsoft.com/default...b;en-us;316675


"VB Programmer" <gr********@g o-intechN0SPAM.co m> wrote in message
news:O8******** *****@TK2MSFTNG P09.phx.gbl...
I get an error when I connect to my mdb. I know for sure that I dont have
it open and that the path is correct.

Here's the error:

System.Data.Ole Db.OleDbExcepti on: The Microsoft Jet database engine cannot
open the file 'C:\Inetpub\www root\MyTest\MyD atabase.mdb'. It is already
opened exclusively by another user, or you need permission to view its
data.
at System.Data.Ole Db.OleDbConnect ion.ProcessResu lts(Int32 hr) at
System.Data.Ole Db.OleDbConnect ion.InitializeP rovider() at
System.Data.Ole Db.OleDbConnect ion.Open() at
LatLongTest.Ema ilNotification. GetEmailRecipie nts() in
c:\inetpub\wwwr oot\LatLongTest \EmailNotificat ion.aspx.vb:lin e
118System.Inval idOperationExce ption: ExecuteReader requires an open and
available Connection. The connection's current state is Closed. at
System.Data.Ole Db.OleDbConnect ion.SetStateExe cuting(OleDbCom mand attempt,
String method, Boolean flag) at
System.Data.Ole Db.OleDbCommand .ValidateConnec tionAndTransact ion(String
method, Int32& localState) at
System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior
behavior, String method) at
System.Data.Ole Db.OleDbCommand .ExecuteReader( CommandBehavior behavior) at
LatLongTest.Ema ilNotification. GetEmailRecipie nts() in
c:\inetpub\wwwr oot\LatLongTest \EmailNotificat ion.aspx.vb:lin e 132


Nov 18 '05 #2
Thanks!

"Ken Cox [Microsoft MVP]" <BA************ @sympatico.ca> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..
Try this?

PRB: Cannot Connect to Access Database from ASP.NET

http://support.microsoft.com/default...b;en-us;316675


"VB Programmer" <gr********@g o-intechN0SPAM.co m> wrote in message
news:O8******** *****@TK2MSFTNG P09.phx.gbl...
I get an error when I connect to my mdb. I know for sure that I dont have it open and that the path is correct.

Here's the error:

System.Data.Ole Db.OleDbExcepti on: The Microsoft Jet database engine cannot open the file 'C:\Inetpub\www root\MyTest\MyD atabase.mdb'. It is already
opened exclusively by another user, or you need permission to view its
data.
at System.Data.Ole Db.OleDbConnect ion.ProcessResu lts(Int32 hr) at
System.Data.Ole Db.OleDbConnect ion.InitializeP rovider() at
System.Data.Ole Db.OleDbConnect ion.Open() at
LatLongTest.Ema ilNotification. GetEmailRecipie nts() in
c:\inetpub\wwwr oot\LatLongTest \EmailNotificat ion.aspx.vb:lin e
118System.Inval idOperationExce ption: ExecuteReader requires an open and
available Connection. The connection's current state is Closed. at
System.Data.Ole Db.OleDbConnect ion.SetStateExe cuting(OleDbCom mand attempt, String method, Boolean flag) at
System.Data.Ole Db.OleDbCommand .ValidateConnec tionAndTransact ion(String
method, Int32& localState) at
System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior
behavior, String method) at
System.Data.Ole Db.OleDbCommand .ExecuteReader( CommandBehavior behavior) at LatLongTest.Ema ilNotification. GetEmailRecipie nts() in
c:\inetpub\wwwr oot\LatLongTest \EmailNotificat ion.aspx.vb:lin e 132

Nov 18 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
9028
by: David Moore | last post by:
Hello I posted a thread about this a while back, but I can't actually find it again so I can reply to it with the solution I found, so I'm making a new thread and hoping it goes to the top of the Google search results for the error like the previous thread. This is actually a solution to a problem, not a call for help, so you can stop reading now unless you're actually interested in the solution :)
9
10910
by: Ben Dewey | last post by:
Project: ---------------------------- I am creating a HTTPS File Transfer App using ASP.NET and C#. I am utilizing ActiveDirectory and windows security to manage the permissions. Why reinvent the wheel, right? Everything so far is working well with the Active Directory. The problem I am having is with adding File Permissions to a directory. I am currently using some code courtesy of "Willy Denoyette "
9
3218
by: Tim D | last post by:
Hi, I originally posted this as a reply to a rather old thread in dotnet.framework.general and didn't get any response. I thought it might be more relevant here; anyone got any ideas? My questions are below... "David Good" wrote: > We have a network running both Win2k and Win2k3 webservers and our web sites > reside on a UNC network share that happens to be a Network Appliance NAS.
12
2797
by: Ann Marinas | last post by:
Hi all, I would like to ask for some help regarding separating the asp.net webserver and the sql server. I have created an asp.net application for a certain company. Initially, we installed both the iis and sql server in a single machine. Not too long ago, the machine had some hardware problems, and management has decided to purchase new servers, for both asp.net and sql server.
6
4958
by: Chris Love | last post by:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) I get this the frist time I open an ASP.NEt 2.0 site on my development machine now. It started happening when I tried to use the...
7
2199
by: deltalimagolf | last post by:
I now get the following error message after copying an asp.net application to the deployment web server. I don't have SQLExpress or any version of SQL 2005 installed. I found the "LocalSQLServer" connection string in the machine.config, changed that to look at a SQL 2000 database, but the error still comes up. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be...
5
1943
by: James | last post by:
Hello, I have written a simple logon page that redirects to another page when successful. All works fine on my computer but when I upload it I get the error message below. I have written it in ASP.net v2, and have put it on IIS v6 on windows server 2003. I think it may be something to do with connection string to the database,
4
11660
by: alegria4ever | last post by:
I have an Access 2000 database that links several tables from Oracle 9. For some reason or another, one of our user repeatedly gets the following error when accessing queries within this database: ************************************************************************************ ODBC -call failed. ORA-01017: invalid username/password; logon denied (#1017) Driver's SQLSetConnectAttr failed IM006 0 Driver's SQLSetConnectAttr failed...
0
2011
by: aboutjav.com | last post by:
Hi, I need some help. I am getting this error after I complete the asp.net register control and click on the continue button. It crashed when it tries to get it calls this Profile property ((string)(this.GetPropertyValue("Address1")));
5
3563
by: Cirene | last post by:
I just deployed my new ASP.NET (3.5 FW) site to the hosting company I'm using, webhost4life. NOTE: I HAVE deployed other SQL Server sites to the same account with no issues. Now I'm getting this error. Any idea why? Server Error in '/myuser4/MyWebApp' Application. --------------------------------------------------------------------------------
0
10578
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10332
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10321
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10077
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7620
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5522
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5651
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4300
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2991
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.