Windows 7 RC ODBC Access driver

Question

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.

Answer 1

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.

Answer 2

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.

Answer 3

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?

Answer 4

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

Answer 5

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

Answer 6

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

Answer 7

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

Jose Santos de Almeida. [e-mail] 

Answer 8

thanks for the post :)

Answer 9

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

Answer 10

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.

Answer 11

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.

Answer 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

Answer 13

Thank you to.

Answer 14

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

Answer 15

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

Answer 16

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.

Answer 17

Thanks for the Tips =) I got this working now

http://devpinoy.org/blogs/comgen/archive/2010/11/28/windows-7-64bit-microsoft-access-2007-problem-solved-quot-architecture-mismatch-between-the-driver-and-application-quot.aspx

Answer 18

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

Answer 19

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!

Answer 20

 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

Answer 21

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.

Answer 22

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% 

Answer 23

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

 

 

Answer 24

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.

Answer 25

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

Answer 26

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

Can anyone please help?  Thanks!

 

Answer 27

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.

Answer 28

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!

Answer 29

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

Answer 30

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

 

Answer 31

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.

Answer 32

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

Answer 33

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

Answer 34

This was answered by my post of 25th August.

Answer 35

@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é.

 

Answer 36

Successfully worked for me. :) thanks

Answer 37

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!

Answer 38

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

Answer 39

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

Answer 40

Quaeyi Vuni I Qnbui Duni ?

ABC I Qqcei Grti Solvi Mamai Butni Fngri !

Taiwan Dri Drzni Fntii Mjtei Tceyi Frmni !

Oktomr Lo To You !

---

Q123xup

Answer 41

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!! :) 

Answer 42

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

Answer 43

Please provide further detail.

Answer 44

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.

Answer 45

Hi Col99,

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

Answer 46

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

Answer 47

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

---

Narayani!!@@!!

Answer 48

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

Answer 49

thank you so much sir

Answer 50

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.

Answer 51

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

Answer 52

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

Answer 53

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