Solved

MS-Access 2007/2010/2013 ODBC 32-bit connector to MySQL 64-bit Server on W-7 localhost?

Posted on 2013-06-01
6
3,107 Views
Last Modified: 2013-06-02
EE Experts,

I have a MS Access report application that connects to a MySQL database using ODBC with SELECT privileges only. On my Windows XP machines this has never been a problem. It was 32 bit all the way. 32-bit versus 64-bit was never an issue. But making it work from MS-Access 2007/2010/2013 using a 32 bit connector to a 64-bit server has become a problem. I had this working at one time in MS-Access 2007. Now that doesn't work either. I must of messed something up and don't know what it is. I have attached 5 JPG screen shots to show what I am getting. I hope somebody has a solution for this problem.

Thanks,
Ted Palmer
ODBC--connection-to.jpg
ODBCdataSourceAdministrator-01.jpg
ODBCdataSourceNameDeclared.jpg
ConnectionSuccessful-01.jpg
Users-Privileges.jpg
0
Comment
Question by:Ted Palmer
  • 3
  • 3
6 Comments
 

Author Comment

by:Ted Palmer
ID: 39213819
This may not be a 32-bit versus 64-bit issue. I just know it doesn't work like I expect it to. I can define the Data Source Name (DSN) correctly, and it tests OK on the connector declaration screen. But it doesn't work when I try to run it. Oh! also in linked table manager the DSN doesn't appear.

Ted Palmer
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 39213842
For Access 32 bit) you MUST use the 32 bit ODBC driver. If you use the 64 bit one, you will not be able to see it in the linked table manager.

In 64 windows, the ODBc connections you see by default from Control Panel are the 64 bit ones. To view the 32 bit ones you need to go to C:\Windows\SYSWOW64 and look for odbcad32.exe. This runs the 32bit ODBC control panel.

If you are downloading drivers - always use the 321 bit ones - even if connecting to a 64 bit server.

Kelvin
0
 

Author Comment

by:Ted Palmer
ID: 39214486
Kelvin,

First of all thank you for your help. It is desperately needed, and much appreciated. First of all I am challenged in responding to your comment because I am getting so many conflicting results. Please see attached JPG file of 4 screen shots. You can see that the property screen for both files are almost the same. The property screen for odbc32.exe from directory C:\Windows\SYSWOW64 is on the left. And the one on the right is from directory C:\Windows\system32. The one on the left should be for 32 bit connectors, and the one on the right should be for 64 bit connectors. They both display what looks like the same ODBC data source administrator that causes the same data source parameters screen to be displayed. This is all from a PC for which my MS-Access 2007 Reports module works just fine. I am not disputing anything you are saying, but I am getting conflicting results. I have to go do the same thing on the remote client PC that is failing.

If you can shed any light on this while I am doing that, it would help.

Thank you for your time and effort.

Ted Palmer
odbcad32-Properties.jpg
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 500 total points
ID: 39215154
Note there is a size difference between to two odbcad32.exe files - these are the same as the two on my 64 bit system. As I mentioned, Access can only use the 32 bit version which is located in the SYSWOW64 folder. I have spent many hours on this as a customer of mine ships an Access runtime to around 100 customers worldwide and we have had to resolve the setup in many different environments. If you manually create an ODBC connection, you have to use this ODBC panel. If you do it from Access it self, it will put it in this one - not the Systrem32 one.

Kelvin
0
 

Author Closing Comment

by:Ted Palmer
ID: 39215353
THANK YOU..!!
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 39215365
A pleasure. I sweated many hours resolving this a few years back, so can understand the nightmare you were enduring.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now