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,296 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

695 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