odbc architecture mismatch

Both Laptops have:
Windows 7 64 bit
Access 2013
Excel 2013
----------------------
I have a working query.  From one Windows 7 64-bit laptop, I can run the query no problem.  I tried to set up ODBC on another laptop and run the same query.  It gives me an error - "the specified dsn contains an architecture mismatch between the driver and application".  
I verified 64-bit odbc (under system32) and made sure System DSN is blank.  I also verified 32-bit odbc (under (syswow64) and deleted an existing one in System DSN and recreated a new one.  I rerun the same query, but got the same error above.    
Can anybody know why and how to fix it?  I appreciate your advice in advance.  Thank you.
kg6lfzAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Access 2013>>

 But here's the rub; is it Office 32 or 64 bit?   The fact that the OS is 64 bit really doesn't matter, it's the version of Office that counts (and apps within office can't be mixed - you can't have 64 bit Excel and 32 bit Access).

 If Office is 64 bit, then all ODBC calls (and hence drivers), need to be 64 bit.   If 32, then 32.

 From the control panel, you get the 64 bit ODBC manager.   For 32 bit, you need to use the one under \syswow64  (sounds like you already are aware of that though).

Jim.
0
kg6lfzAuthor Commented:
Thank you for your comment.  I checked his Office.  it was 64-bit.  What kind of vendors sell laptops with 2 different Office, one is 32 and the other, 64.
Anyway, I will go to System 32 folder and set up 64-bit odbc.  I will get it back to you later.  Thank you.
0
kg6lfzAuthor Commented:
I tried to set up 64-bit odbc.  Went to System DSN and add.  But only choice I got is SQL.  Nothing else.  How can I add Access so that it will be listed under System DSN?  thank you.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<I tried to set up 64-bit odbc.  Went to System DSN and add.  But only choice I got is SQL.  >>

I'm a little confused over what the situation is.  Need a little more detail on what the setup is.

If Office is installed and it is 64 bit, then you should see the driver to connect to Access databases.  The driver for Access should already be installed with Office being installed.   You don't need that driver either unless your app (it is written in Access yes?) is trying to connect to another Access DB via ODBC (which you don't have to do).

Jim.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
BTW, if this is something like a C# or ASP.net app that is connecting to an Access DB, and Access is not installed but Office is, than you can get the 64 bit drivers for Access installed by down loading and installing this:

Microsoft Access Database Engine 2010 Redistributable
http://www.microsoft.com/en-us/download/details.aspx?id=13255

 Click the download, and then you'd want the second link for 64 bit.

Jim.
0
kg6lfzAuthor Commented:
Sorry for the late response.  The Access and Excel are both installed.  "About Access" and "About Excel" both say "64-bit".  But when I go to odbc for 64-bit, there is nothing under System DSN.  Under User DSN, there is Excel Files, and MS Access Database choices are listed.  But I prefer to use System DSN.  I am attaching the file for reference.
 
This is why I need to set up odbc -  User runs the query, which opens up Excel and retrieves data.  The records are in Access.  

If you can give me suggestions, it will be appreciated.  Thank you.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Don't see an attachment.

<<But when I go to odbc for 64-bit, there is nothing under System DSN. >>

 You would create the DSN there.

<<If you can give me suggestions, it will be appreciated.  Thank you. >>

  What I would suggest is setting up the DSN you need, then testing it there.  However I would use a unique name for testing to ensure that there are no mix-ups with something already created for 32 bit.   As suggested in this article:

ODBC Administrator tool displays both the 32-bit and the 64-bit user DSNs in a 64-bit version of Windows
https://support.microsoft.com/en-us/kb/942976

 I would append _32 and _64 to anything you create to tell which is which.   As the article points out (and read carefully), the DSN's that are displayed in the two versions of the ODBC applet can be mixed up (64 bit DSN's showing in the 32 bit manager) depending on the type of DSN (User, File, or System).

  This is most likely the root of your problem.

 Use the %windir%\System32\odbcad32.exe, and define a system DSN with _64 on the end.  If that works, then I would delete all existing DSN's that you created, check the registry keys mentioned in the article to ensure that everything is cleared out, and then start over.

Jim.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.