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

Answer 16

Malcolm,

Office 2010 is released. Is it include 64 bit odbc driver for Access?

 

Thanks,

Answer 17

Jet sucks. Only handicapped (mental or physcial) need to still use Jet.

Keep your data in SQL Server.

---

aaron_kempf

Answer 18

http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d

 

Microsoft Database Engines for 64 bit are available as standalone package

 

regards

Answer 19

Thanks heaps malcom, this solved the issue i was having trying to get driver for access/excell etc etc on our only win7 64 bit machine!

Answer 20

Dear All,

 

I Got Solution for this problem.

We Can Create ODBC DSN Manualy. please follow step and create it.

-> open C:/Windows/System32/odbcad32.exe (Double click)

then create odbc for 32 bit and its working fine.

vijay movaliy.

[e-mail]

http://www.imagicsolution.com

Imagic Solution

Answer 21

It doesn't work sir...
It actually opens the same program which you get through the "ODBC" in "Administrative Tools"...
It doesn't work....

Answer 22

Dear PlectoBne,
I downloaded the both versions available on the link given by you...
When I tried to install the 64 bit version, It gave error saying that the Office version you have is 32 bit, so install 32 bit version...
When I tried to install the 32 bit version, the problem persisted as it was before installing the drivers...

You can find the details of my problem here --- http://social.msdn.microsoft.com/Forums/en/adodotnetdataset/thread/838f118b-0074-4399-8b0b-85463b61d6d9

 

Please get me some solution as soon as possible....

Answer 23

Prove enable 32-bit odbc but I came out this error when running from cmd

C: \ Documents and Settings \ Administrator> cscript% SystemDrive% \ inetpub \ AdminScripts \ adsutil.vbs set w3svc/AppP
ools/Enable32bitAppOnWin64 1

'cscript%' is not an internal Recognized As or external command,
operable program or batch file.

If someone could help me to enable desabilite 32bit and that the 64-bit on a server 2003 x64

Thanks

Answer 24

I am getting java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application I think the problem is similar to as stated above. I am running Windows 7 64 bit. I installed the Microsoft Database Engine you recommended but still I am not able to find a solution. Is there another solution?

Answer 25

I found a link on the web before which you just typed into your run command and then it opened up the appropriate window to add MA Access ODBC for 64 bit.

It actually worked fine, and there was no need to download anything.

 I will have a look on the Internet sea at I can find this again.- In the meantime good luck!

Answer 26

try this

C:\Windows\SysWOW64\odbcad32.exe