index > 64-Bit .NET Framework Development > Unable to access the MS Access database from 64 bit component

Unable to access the MS Access database from 64 bit component

As part of our project, we use MS Access database (stats.mdb) to store and retrieve virus scan statistics. This database has been created using earlier versions of Microsoft Access.

If the components which access the database are built with win32 configuration, then these components are able to store and retrieve the data from the database.

If the components are built with 64-bit configuration, then these components are unable to access the database. An error occurs while opening a connection to the database. The error description is "Provider can not be found. It may not be properly installed" and error is "Unknown error 0x800A0E7A". The provider we are using is "Microsoft.JET.OLEDB.4.0".

Thanks inadvance!

SmartPtr

Microsoft has not developed providers of Jet.OleDB for 64 bit. You can not create the component with 64 bit who is accessing access database.

Mohit Bhutani

Microsoft has not developed providers of Jet.OleDB for 64 bit. You can not create the component with 64 bit who is accessing access database.

Mohit Bhutani

Thanks for the reply Mohit!

Does this mean that on 64bit OS, appliactions should not use MS Access Database and should go for other alternatives avalable?

I searched on MSDN and Microsft site for the details but I think they havn't even bothered to provide any such details.

SmartPtr

For using your application on 64 bit machine you have to compile the application in 32 bit environment. Another alternate is to switch over to microsoft sql express or wait for some time, may be microsoft provides some ole db providers.

Mohit Bhutani

Set Con = Server.CreateObject("ADODB.Connection")
Con.Open "Data Source=" & Server.Mappath("storeDB.mdb") & ";Provider=Microsoft.Jet.OLEDB.4.0;"

instead of:

Set Con = Server.CreateObject( "ADODB.Connection" )
Con.Open "accessDSN"

download database and more information
http://www.haneng.com/lessons_20.asp
http://www.powerasp.com/content/database/dsn_vs_dnsless.asp

Doanl

You can use google to search for other answers

Custom Search

More Threads

• remoted tier dependancies in 64 bit

• Forcing .Net application to launch at 64-bit

• Office PIA Question

• How about a 64-bit Windows XP and Windows Server 64-bit OS issues forum?

• Problem with Impersonation on Windows 2008 Server x64

• a question about dialog message in 64 bit machine

• Trouble debugging an app in 2005, builds fine, won't start debugger

• 32 bits application fail to run on Windows 2003 SP2 64 bits server

• assembly generation warning messages

• Can I run a 16-bit app on Windows Vista?