MS Access 32 bit database connecting form VS 2010 (x86) on windows 7 64 bit, Error Could not find file 'C:\Program Files (x86)\Common Files\Microsoft Shared\DevServer\10.0\dbo.mdb'

Question

4.00/5 (1 vote)

See more:

, +

Hi,

I'm trying to connect MS Access (*.mdb file) from ASP.NET, Everything Works fine in windows application in my PC. the same code giving error in ASP.NET

In ASP.NET Oledb connection is success but while reading from datatreader its giving a strange error :(, Any idea on this issue? Pls help, Thanks In advance

the code is as follows

Connection string is

XML

<add name="oledbCon" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\mydatabase.mdb" providerName="System.Data.OleDb"/>

Everything works fine in windows application the same code in ASP.NET throws error from the below line

reader = cmd.ExecuteReader();

Error is

Could not find file 'C:\Program Files (x86)\Common Files\Microsoft Shared\DevServer\10.0\dbo.mdb'

where as in my connection string I can see the my datasource as D:\mydatabase.mdb from debug window

Steps I tried is given below

changed the from AnyCPU to x86 in VS 2010 configuration

Pls not : MS Access is 32 bit and Windows 7 64 bit, and VS 2010 configuration changed to x86, When I'm getting this error I checked the connection state in quickwatch and its in Open state.

Posted 7-Jul-12 3:09am

Shemeer NS

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

seravan · Answer 1 · 2012-07-07T04:54:00

Solution 1

Not sure if i got your problem correctly but what i've understand is that you are encounterring the error when in asp.net. If yes, why not try to include that file in your asp.net project just like the images or misc files and from there youll just map it.

Its working on windows app because youre just in your computer not a host.

Posted 7-Jul-12 4:54am

seravan

Comments

Shemeer NS 7-Jul-12 11:39am

that file is included in the App_Data folder of asp.net and correspondingly I have changed the path in web.config also.... then also it was giving same error...

seravan 9-Jul-12 0:47am

Based from the connection string it's pointing to D drive while on you error it's pointing on the C drive and also a different MS Access file.