Windows 7 RC ODBC Access driver

Question

troy99 on Fri, 01 May 2009 15:19:35


Many apologies for posting here, but it's the nearset I can find. I am running the Windows 7 RC (x64) and need the MS Access 32-bit ODBC driver in order to connect to an in-house application. The driver doesn't appear to be shipped with Windows 7 and I cannot find anywhere to download it.

On further inspection, the 32-bit SQL Server ODBC driver appears not to ship either and I need that as well.





Replies

Jivko Dobrev - MSFT on Fri, 01 May 2009 17:58:05


Hi.

How are you enumerating the drivers? ODBC Administrator? Did you run its 32-bit or 64-bit version? Directly starting it would yield the 64-bit version and there you would only see only the SQL Server 64-bit driver. However if you start the 32-bit version (for instance by changing directory in a CMD to %windir%\syswow64) you should be able to see all the 32-bit drivers enumerated.

HTH,
Jivko Dobrev - MSFT
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.

Ying Lin - MSFT on Mon, 04 May 2009 08:38:36


Use odbcad32.exe under %WINDIR%\SYSWOW64, you will find all the 32bit drivers enumerated. I'm sure MS Access 32-bit ODBC driver is shipped.

troy99 on Tue, 05 May 2009 14:57:33


Many thanks guys. Yes, I was using the 'default' ODBC Administrator.

Silly me not to realise that I needed a different version of the same program in C:\Windows\SysWOW64 ;-)

I went through the same process some time ago with Server 2K8 x64 (not sure if it was R1 or R2).

I remember now that there are two versions of the ODBC admin, but I don't remember having the same problem.

Is there a link to ODBC 32-bit in the menu structure on the server product?

Rooshk34 on Tue, 22 Sep 2009 22:15:58


I was having the same issue, but got it working using the 32 bit ODBC administrator. Thanks for the post.

WillBarbee on Fri, 12 Mar 2010 21:07:45


Thank you all.  I had the same problem and this got me going.

kev_gordon on Tue, 30 Mar 2010 13:34:58


Thanks from me also! I didn't know there was a separate 64 bit version which was the default in the start menu for Windows 7 64bit.

I wouldn't have found out about the 32bit ODBC administrator without this thread.

I can now bask in the praise from my colleagues... :)

Professor Almeida on Fri, 02 Apr 2010 21:12:29


Thank you, for the sugestion; I used and solve my problem too.

Jose Santos de Almeida. almeida.santos@globo.com 

mtrsykl on Wed, 12 May 2010 19:01:01


thanks for the post :)

kevinsoni on Thu, 22 Jul 2010 13:41:06


please tell that hole process i also have the same issue how will you got working please tell me

troy99 on Thu, 22 Jul 2010 13:49:50


Just go to the C:\Windows\SysWow64 folder and you will find another version of odbcad32.exe - this is the 32-bit version that you want, instead of the 64-bit that runs from Control Panel.

KaBales on Fri, 30 Jul 2010 19:41:27


I had the same problem.  The ODBC Data Sources (32-bit) application found in the control panel is not the same as running the obdcad32.exe found in the SysWow64 folder.  Running that program fixed my connection problem.

However, it did not fix a speed issue I am having.  I have the same connection set up on a XP 32-bit machine and everything works fine.  I have a large amount of data stored in the program.  I seem to recall seeing something related to the number of data objects and a speed issue, but cannot find a fix.

The software vendor isn't being much help.  I seem to be troubleshooting on a trial and error basis.  Any help or advice would be appreciated.

troy99 on Mon, 02 Aug 2010 10:38:12


If your problem is ONLY releated to SQL data being delivered slowly, then I don't have an answer.

However, I had a problem with a Server 2008 R2 vm being VERY slow overall. I was getting DNS errors and thought I had a problem there. It turned out to be a problem with the TCP/IP stack.

http://social.technet.microsoft.com/Forums/en-US/winserverGP/thread/4fe0036a-9af5-4277-b3cd-a2de6ee167a4

The answer was to  disable both TCP Checksum Offload AND Large Send Offload.

HTH

Gordon

ComsiConsa on Wed, 18 Aug 2010 00:21:18


Thank you to.

kenrock777 on Fri, 10 Sep 2010 03:18:51


I purchased Access 2010. The driver Microsoft Access Driver *.mdb does not exist in my odbc window. Therefore I can not expose my database to my local drive from some of my other programs. What can I do? i have a 64 big hp laptop. I have some access databases from 2000 that I still want to connect to from my computer with adobe acrobat pro files.

 

thanks a bunch

kenrock777

troy99 on Fri, 10 Sep 2010 08:12:41


Hi Kenrock777,

As it says above, just use the odbcad32.exe in the c:\windows\syswow64 folder instead of the one in control Panel. That is the 32-bit version instead of the 64-bit one.

 

HTH

Gordon

ImproperUsername on Fri, 29 Oct 2010 22:28:09


Use odbcad32.exe under %WINDIR%\SYSWOW64, you will find all the 32bit drivers enumerated. I'm sure MS Access 32-bit ODBC driver is shipped.

I found this topic while searching about the same issue as the OP. Thank you for this answer; it was exactly what I needed to know and I have now gotten the database connection set up that I needed.

Joel Sam on Wed, 05 Jan 2011 08:50:50


i was spendin a whole day tryin to figure out wat was happenin.... all forums told about  syswow64 and obcad32 in it but nothing worked....as nothin was inthere for me..... nut as for everone who encounters this problem try to go this path in system and find out    it worked for me  C:\Windows.old\Windows\winsxs

sonnet38 on Thu, 27 Jan 2011 14:35:22


I am having the same problem only there is no file under syswow64 that has an exe at the end. There is odbcad32- when I click on it it takes me to system dns, file dns, user, etc. I click on user dns -- running as administrator -- and then click on add. The next screen shows data source drivers...I choose Microsoft Access Driver mdb and accdb -- I am running access 2010 -- I create a data source name -- is this what I am supposed to do?-- and description, click to add my database which is located in my xampp database folder and then what? How do I proceed to connect my access database to my dreamweaver cs5 php web pages? I have tried to create a connection string in dreamweaver by creating an asp page- the steps become a bit confusing...must be doing this incorrectly.

In the connection string area I add: "Driver= {MicrosoftAccessDriver(*.mdb , *.accdb)};DBQ=C:\C:\xampp\htdocs\folder\database.accdb;Uid=userid;Pwd=password;"

Do I need to configure access as well? Which user id and password should I be entering...not sure.

 

For the right person, these questions will be a breeze so I am hopeful some of the sharp minds in here can talk me through this.

 

Thank you!

callmeasULIke on Tue, 19 Apr 2011 02:21:48


 I wish I could came to this forum a week a go. Any ways I solved the problem I had with this question and plus with some other suggestions at the bottom.  I am soooooooooooooo happppppppppy ... 4 THUMBS UP.LOL

Khurram Bhatti on Wed, 04 May 2011 07:56:41


Use odbcad32.exe under %WINDIR%\SYSWOW64, you will find all the 32bit drivers enumerated. I'm sure MS Access 32-bit ODBC driver is shipped.

Thanks a LOT.I  spent a whole day on this thing,finally i found it on this forum.

FARRUKH KHALID on Fri, 03 Jun 2011 11:45:51


Khurram is right !

Guys do one  thing go to control panel- admin tools - odbc ( right click properties) n to its target location replace the system32 location to syswow64-odbccad32
i have no idea but the problem was that for 64 bit version they have linked it to 32 bit so once u give it the right path it would work 100% 

Saroop Trivedi on Sat, 25 Jun 2011 09:54:06


it's simple , it's only window 7 for 64bit

 

Administration Tool--->ODBC Driver--> Right Click --> Properties

 

[1] change the Target : %windir%\syswow64\odbcad32.exe

 

[2] Start in : %windir%\SysWOW64

 

and then Save it's work perfectly

 

 

fri0 on Thu, 30 Jun 2011 19:45:46


it's simple , it's only window 7 for 64bit

 

Administration Tool--->ODBC Driver--> Right Click --> Properties

 

[1] change the Target : %windir%\syswow64\odbcad32.exe

 

[2] Start in : %windir%\SysWOW64

 

and then Save it's work perfectly

 

 

I did that and I can't do the conection. I want to import to IBM SPSS Statistics 19 an Excel file and I have an error.

mani.diem on Wed, 10 Aug 2011 21:20:46


thnx 4 da proper steps... nw i'm getting all da drivers....    bt nw 1 more problem... nw its giving an error dat DSN  contains an architecture mismatch b/w the driver and application...

 

plzz help..

cornPone1 on Wed, 24 Aug 2011 21:14:21


I'm having the same problem too: "The specified DSN contains an architecture mismatch between the driver and application"

Can anyone please help?  Thanks!

 

troy99 on Thu, 25 Aug 2011 11:04:57


Sounds like you have a 64-bit application (and so need to use the 'Control Panel' version of ODBC Manager), or you have a 32-bit application and need to use the one in the SYSWOW64 folder as above.

cornPone1 on Fri, 26 Aug 2011 19:00:16


I'm using a 32-bit application (eclipse), and I'm using the ODBC manager in the SYSWOW64 folder (which is the only one that contains an Access driver), but I'm still getting this error message.  Am I missing something?  Thanks again!

Andre_Analytics on Fri, 09 Sep 2011 18:44:06


Hello,

Good to see that so many are helped here.
But I myself still have a problem. I have SQL Server 2008 64 bit and MS Access on one machine. I would like to have a linked server in my SQL Server instance to the MS Access database.

What I did:
- run syswow64\odbcad32.exe
- System-DNS -> Add -> Driver to MS Access
- and then give a name and select the database file

Then in the SQL Server Manamgement Studio:
- Server objects -> Linked servers -> New linked server
- I hoped to be able to use now the above configured ODBC driver to MS Access, but I don't know how.
Is this possible ?

Thanks in advance.
Regards, André.

Ajudoha on Thu, 20 Oct 2011 05:49:13


it's simple , it's only window 7 for 64bit

 

Administration Tool--->ODBC Driver--> Right Click --> Properties

 

[1] change the Target : %windir%\syswow64\odbcad32.exe

 

[2] Start in : %windir%\SysWOW64

 

and then Save it's work perfectly

 

 


Thank you.. thanku.. thanku............................ it works perfectly.................. Iam sooooooooooooooooooo happy..

 

troy99 on Thu, 20 Oct 2011 10:19:07


If you change the target in Control Panel then you can't create 64-bit ODBC connections. Leave Control Panel alone and pin the version in C:\Windows\SYSWOW64 to the Start Menu and add '(32-bit)' to its description, then you have access to both.

Salatun Prajanban on Tue, 08 Nov 2011 14:02:56


หามานานเลยครับ ขอบคุณมากครับ นึกว่าจะใช้งาน ODBC Intersystems For 64 ไม่ได้ รอดแล้ว

Awaiter on Mon, 12 Dec 2011 07:22:59


did you ever find out how to solve the architecture mismatch problem?  I'm having the same problem?

troy99 on Mon, 12 Dec 2011 09:54:41


This was answered by my post of 25th August.

Andre_Analytics on Wed, 14 Dec 2011 06:38:08


@Awaker,

I did not found a way to create a linked server from my SQL Server 2008 64 bit database to an MS Access 2007 database (on the same machine). In this thread a solution is provided by creating a 64-bit ODBC connection. It seems like this solves some problem, but not mine. In another thread someone told me that it is just not possible to create a linked server to MS Access 2007 from/in a 64-bit environment.

Best regards, André.

 

Behdrex on Thu, 05 Jan 2012 01:13:29


Successfully worked for me. :) thanks

yoyoz432 on Thu, 19 Jan 2012 20:08:41


I'm trying to connect to an Access DB file using:

1. Windows 7 x64

2. Python x64

3. Microsoft Access 2010 x32

4. The right version of the ODBC (located at: \sysWOW64\odbcad32.exe)

I've successfully set up a File DSN, but when I try to connect to the Access DB, I'm still getting the famous error, just in python form: "[IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application (0) (SQLDriverConnectW)"

 

So what's the problem here, is it Python? I mean, if I used a 32 bit of Python would it work?

Thanks!


col99 on Sat, 04 Feb 2012 12:25:02


I have a similar problem.
New 64bit pc with Windows 7 Home Premium.
MS Office Pro 2010 - tried both 32 bit and 64 bit with same results.

An existing Access 2003 .mdb which I need to connect to, to build a website using a vbs script (combined with html docs and css etc)

This script works fine on my old 32 bit pc with Windows XP Pro and Access 2003.

Had the initial problem of the ODBC Data Source Admin not working at all but reconfigured it to C:\Windows\SysWOW64\odbcad32.exe and was able to add the target database under the System DSN.

But when I run the script the last line immediately below creates the following error.

'-- Connect to database
set conntemp=createobject("adodb.connection")
conntemp.open DataSourceName

Error:
'Specified driver could not be loaded due to system error 193: (Microsoft Access Driver (*.mdb)
C\:WINDOWS\system32\odbccjt32.dll)
Code: 80004005
Sources: Microsoft OLE DB Provider for ODBC Drivers'


odbccjt32.dll is in both the system32 and SysWOW64 folders

Should the ODBC connection be using the SysWOW64 folder? and, if so, how do I change the setup please?

Or is it something else?

I first installed a 32 bit version of MS Office Pro including Access 2010, and then, when that did not work, uninstalled it and tried a 64 bit version, but same error.

Any help would be appreciated. I have changed the DSN etc settings in the ODBC Data Source Admin several times now - is there a way to get back to a clean ODBC Data Source Admin without rolling back everything else?

thanks,

Col

Akshat_Bhargava_mca on Wed, 08 Feb 2012 20:54:14


thankuuuuuuuu............................very happy:)

Qez9998Orz on Thu, 09 Feb 2012 04:33:50


Quaeyi Vuni I Qnbui Duni ?

ABC I Qqcei Grti Solvi Mamai Butni Fngri !

Taiwan Dri Drzni Fntii Mjtei Tceyi Frmni !

Oktomr Lo To You !

angelarshie on Sun, 26 Feb 2012 13:07:36


Hi.

How are you enumerating the drivers? ODBC Administrator? Did you run its 32-bit or 64-bit version? Directly starting it would yield the 64-bit version and there you would only see only the SQL Server 64-bit driver. However if you start the 32-bit version (for instance by changing directory in a CMD to %windir%\syswow64) you should be able to see all the 32-bit drivers enumerated.

HTH,
Jivko Dobrev - MSFT
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.

Thank you so much ...you are a life saver..my project was stuck because of this..n u made it possible..chaow!! :) 

Lex_37 on Mon, 27 Feb 2012 22:50:39


I did it all, but it is still not working, I can't connect to the Access database.

troy99 on Thu, 08 Mar 2012 14:37:13


Please provide further detail.

CSpeerly on Sun, 11 Mar 2012 04:16:20


Here are the five steps that I did.             

1) regsvr32 c:\Windows\SysWOW64\odbcconf.dll

2) loaded and installed 2007 Office System Driver: Data Connectivity Components from here.
C:\Users\Homer\Downloads\ODBC\Download 2007 Office System Driver Data Connectivity Components - Microsoft Download Center - Download Details_aspx.mht

3) To use Windows 7 32-bit subsystem. You need to use the ODBC control panel here.
        c:\windows\sysWOW64\odbcad32.exe
        I used DSNLess so I did not need this. But it does work.
       The one in the system32 folder gives an  errors if you try to use it.

4) My DSNLess Connection string
DSN =  "Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=c:\inetpub\wwwroot\Database\gdbhelp.mdb"

5)  Gave the IIS_Iuser account READ and WRITE rights to edit and add on the gdbhelp.mdb database.

Orlando M on Fri, 06 Apr 2012 19:45:40


Hi Col99,

Now i have the same problem, if you founded a solution please let me know,

karimvirani on Tue, 22 May 2012 07:25:08


it's simple , it's only window 7 for 64bit

 thanks for such a nice idea i applied and successfully done ODBC in windows 7

Narayani_Rockz on Sun, 08 Jul 2012 10:49:32


hi, i was having this same problem. thank you for ur answer. it helped me alot.

Elchin3d on Mon, 16 Jul 2012 18:21:20


man you are great )) thankssss it worked with 32 bt driver ))

kerkgil on Fri, 07 Sep 2012 09:25:51


thank you so much sir

ShaiKry on Mon, 10 Sep 2012 09:05:59


Hi

I have a similar problem and couldn't overcome it. Here's the situation: I have a website (asp.net) that I want to install on localhost. I create the web application with VisualStudio for "any cpu" (so I guess it runs as 64bit app in Windows 7).  The application uses DSN to interact with access mdb. In teh regular odbcad32 there is no option to add the mdb driver. When I used the odbcad32 in syswow64 I get the "Mismatch" error. When I tried to compile the application for x86 cpu I couldn't run the website at all.

jonaswestberg on Wed, 26 Sep 2012 13:03:08


Try to enable 32 bit application in the pool: http://help.webcontrolcenter.com/KB/a1114/how-to-enable-32-bit-application-pool-iis-7-dedicatedvps.aspx

ShaiKry on Wed, 26 Sep 2012 14:37:07


Actually I found this solution myself after in-depth investigation. But thanks for your reply.

BCoward on Tue, 05 Feb 2013 18:23:40


Thanks for the post!  Crazy that all of the drivers aren't available in one place.  I'm up and running now though... thanks.

Brian