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,233 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
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.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

749 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