Saturday, August 05, 2006 9:05 AMHello,
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....
Saturday, August 05, 2006 9:47 AMModeratorThere is not one available. You need to compile your application for the x86 processor to force it to use the 32 bit driver.
Monday, August 07, 2006 3:54 PMKen 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.
Monday, August 28, 2006 10:16 PM
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!
Tuesday, August 29, 2006 10:34 AM
I saw this while trying to resolve a similar problem. Let us know if this helped, or if you have resolved this somehow..
Friday, November 10, 2006 10:46 PM
Run it through SQL Server Express (which is 32-bit)
Not straight-forward but a lasting solution, hope this helps, Gorm
Monday, November 20, 2006 3:52 PM
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
Friday, March 28, 2008 10:44 PM
You can find the option in Visual Studio 2005 under:
Project -> Solution Properties -> Build -> Platform Target -> x86
Hope this help!
Saturday, April 04, 2009 2:05 AMesskay,
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.
- Proposed As Answer by RodimusHH1227 Saturday, April 04, 2009 2:05 AM
Thursday, May 14, 2009 1:05 PMCould 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.
Wednesday, September 23, 2009 12:00 PMHello 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.
Saturday, October 31, 2009 2:21 AM
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.
Sunday, November 01, 2009 6:02 AMOn 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
Office 2010 will come in a native x64 version so we should expect native x64 drivers then.
Tuesday, November 03, 2009 7:33 PMHi 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 ?
Tuesday, November 03, 2009 10:54 PMI 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:
- Click Start, click Run, type cmd, and then click OK.
- Type the following command to enable the 32-bit mode:
cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1
- 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:
- 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: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.
- Click Start, click Run, type cmd, and then click OK.
- Type the following command to disable the 32-bit mode:
cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 0
- 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:
- 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.
Wednesday, November 04, 2009 4:20 AM
I followed your instructions to run 32 bit version of ASP.NET 2.0,
Step 2 was successfull
Step 3 failed as follows:
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).
Wednesday, June 23, 2010 9:59 AM
Office 2010 is released. Is it include 64 bit odbc driver for Access?
Saturday, September 11, 2010 4:28 PM
Jet sucks. Only handicapped (mental or physcial) need to still use Jet.
Keep your data in SQL Server.
Tuesday, October 05, 2010 9:36 AM
Microsoft Database Engines for 64 bit are available as standalone package
- Proposed As Answer by plectoBne Tuesday, October 05, 2010 9:37 AM
Wednesday, February 02, 2011 3:15 AMThanks 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!
Tuesday, November 15, 2011 10:55 AM
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.
Monday, January 30, 2012 4:47 PMIt doesn't work sir...
It actually opens the same program which you get through the "ODBC" in "Administrative Tools"...
It doesn't work....
Monday, January 30, 2012 4:52 PM
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....
Tuesday, June 19, 2012 8:29 PM
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
'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
Wednesday, August 29, 2012 6:48 AMI 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?
Friday, August 31, 2012 10:36 AM
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!
Friday, August 31, 2012 10:43 AM