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
<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();
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.