64 bit ODBC driver for Microsoft Access

Question

Hello,
I am trying to connect to one of my Access databases (.mdb file on my local) from ODBC connection. The problem is, I am using 64-bit Xp Pro and it does not see any Access driver on 64-bit architecture.
Does anybody have 64-bit compatible ODBC driver for Microsoft Access ? Any other help also will be appreciated....

Answer 1

There is not one available.  You need to compile your application for the x86 processor to force it to use the 32 bit driver.

Answer 2

Ken is correct - I ran into the same problem. And, compiling against x86 fixed the problem. This is the *only* way to run Jet 4.0 on x64.

Answer 3

Can any of you tell an "average Joe" how to compile the application against the x86 processor?  I'm not a developer just a sys admin trying to connect to an Access db - thanks!

 

Paul

Answer 4

I saw this while trying to resolve a similar problem. Let us know if this helped, or if you have resolved this somehow..

http://archives.postgresql.org/pgsql-odbc/2005-09/msg00125.php

Thanks..

 

Answer 5

Run it through SQL Server Express (which is 32-bit)

http://gorm-braarvig.blogspot.com/2005/11/access-database-from-sql-200564.html

Not straight-forward but a lasting solution, hope this helps, Gorm

Answer 6

Hi

To continue the theme.  Heeeelpppp.

Am i right in thinking that there is absolutelly no way to read and write data into an Access Database from VS2005 on a 64 bit machine, with my app running in 64 bit mode ? 

I cannot compile to x86

I cannot use SQLXpress

Any ideas at all would be greatly appreciated

Glen

 

 

Answer 7

 

Hi there!

 

You can find the option in Visual Studio 2005 under:

 

Project -> Solution Properties -> Build -> Platform Target -> x86

 

Hope this help!  

 

Brgds,

Sergej

Answer 8

esskay,

Thanks.  After reading the link, it all made sense to me.  I know it has been 3 years since your post but thank you.

(Local Hard Drive):\WINDOWS\SysWOW64\odbcad32.exe  (Local Drive is in parenthesis due to my running a RAID 5 config and my local drive is not "C:\")

I created a shortcut on the desktop and then pasted it inot my Administrative Tools with the 64-bit version of ODBC and this fixed the issue.

RodimusHH1227

Answer 9

Could I please get a little more help with this I don't have Visual Studio 2005.  You say that you fixed the problem could you elaborate on the process.  I have gone here (\WINDOWS\SysWOW64\odbcad32.exe) and went though the steps but I still don't link to the database.

Thanks

Rocky

Answer 10

Hello together!
Sorry but my english ist not very well.

I have a simmilar problem and I hope you can help me.

On my machine runs Windows Vista 64 Bit Business and I try to install Microsoft SQL server 2005 Express SP3 for x64 - but I get an error code during the installation. I hope you can help me.

The installation programm run without problems to the point where the programm will start the SQL-Server.
The SQL-Server runs for a few seconds and then I got the following error code:

(free translation from me)

TITEL: Microsoft SQL Server 2005 Setup

------------------------------

 

From the SQL Server-Setup can't create a connection to the the database service for the server configuration.
Error: [Microsoft][ODBC Driver Manager] The Database name wasn't found, and it was no standart driver named.
Furhter information you can find unt er the protocolls...
__________________________


If I hope de ODBC-Management I can't configure any driver - but If I open the  \WINDOWS\SysWOW64\odbcad32.exe\ I have a lot more dirvers and I can also configure it.

Please can you help me to install the SQL-Server  2005 Express on my pc - I haven't any idea more!!!


Thanks and sorry for my bad language knowledges.
Alex

Answer 11

It is so typical of Microsoft to put the 64 bit drivers in the System32 folder and the 64bit drivers in a folder called SysWOW64.  The other issuer I had with ODBC drivers failing to connect was because of the naming convention of the Program Files (x86) folder.  Apparently some ODBC drivers like the Microsoft ODBC for oracle driver apparently do not like special characters like parenthesis. I had to uninstall my Office 2007 and reinstall it to a folder in the c:\ directory to get ODBC working in Access.

Answer 12

On x64 systems 32 bit DLLs/drivers should go to SysWOW64. Although it seems a bit confusing with the 64 bit native files being in C:\windows\system32, there were backwards compatibility reasons that required the native files to go into C:\windows\system32. For 32 bit applications the redirection to C:\Windows\SysWow64 is automatic.

For ODBC config it is documented in microsoft support

http://support.microsoft.com/kb/942976

Office 2010 will come in a native x64 version so we should expect native x64 drivers then.

Answer 13

Hi I have an application consisting of both classic ASP and ASP.NET and I use Microsoft access database.

I would like to run my application on 64 bit windows server but can't do it because of the driver issue.

Is there a solution for classic ASP ole connection to microsoft access on 64 bit environment ?

Thank you..

Answer 14

I think you have to run ASP.NET in 32-bit mode. Note on IIS 6.0 you can't have ASP.NET in 32-bit mode and 64-bit mode.

To run the 32-bit version of ASP.NET 2.0, follow these steps:

1. Click Start, click Run, type cmd, and then click OK.
2. Type the following command to enable the 32-bit mode:
   cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1
3. Type the following command to install the version of ASP.NET 2.0 (32-bit) and to install the script maps at the IIS root and under:
   %SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
4. Make sure that the status of ASP.NET version 2.0.50727 (32-bit) is set to Allowed in the Web service extension list in Internet Information Services Manager.

To revert back to the 64-bit version of ASP.NET 2.0, follow these steps:

1. Click Start, click Run, type cmd, and then click OK.
2. Type the following command to disable the 32-bit mode:
   cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 0
3. Type the following command to install the version of ASP.NET 2.0 and to install the script maps at the IIS root and under:
   %SYSTEMROOT%\Microsoft.NET\Framework64\v2.0.50727\aspnet_regiis.exe -i
4. Make sure that the status of ASP.NET version 2.0.50727 is set to Allowed in the Web service extension list in Internet Information Services Manager.

Note The build version of ASP.NET 2.0 may differ depending on what the currently released build version is. These steps are for build version 2.0.50727.

Answer 15

I followed your instructions to run 32 bit version of ASP.NET 2.0, 

Step 2 was successfull

Step 3 failed as follows:

C:\Windows\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis.exe -i
The error indicates that IIS is not installed on the machine. Please install IIS
 before using this tool.
Finished installing ASP.NET (2.0.50727).