MySQL ODBC connector 32bit or 64bit?

mysql odbc mysql-odbc-connector
Raffael picture Raffael · Dec 6, 2012 · Viewed 8.2k times · Source

I want a 32bit bit application (running on Windows 7 64bit) to connect to MySQL 5 64bit through ODBC.

Does the MySQL ODBC connector have to be 32 or 64 bit?

Does the MySQL ODBC connector's register size have to match the application's or MySQL's? Windows 7 64bit can handle 32bit as well as 64bit connectors - so this does not matter.

Answer

Raffael picture Raffael · Dec 10, 2012

(verified with R 32bit and 64bit / Windows 7 64bit / MySQL 5 32bit.)

Only the application's architecture (32bit or 64bit) that connects via the ODBC adapter does matter and has to be matched by it.

Windows 7 64bit can handle both 32bit and 64bit ODBC connectors (different data source managers though)

To MySQL 5 32bit you can connect with a 32bit as well as with a 64bit ODBC connector.

Related questions

I'm trying to install the MySQL connector on a windows 7 systembut it doesn't show up in the ODBC add window

This is under Windows 7 64 bit. I downloaded the 64 bit drivers and as a matter of fact I tried all the windows drivers(uninstalling the previous ones first though). But when I try to configure a new ODBC connection the MySQL …

Read More
How to search for rows containing a substring?

If I store an HTML TEXTAREA in my ODBC database each time the user submits a form, what's the SELECT statement to retrieve 1) all rows which contain a given sub-string 2) all rows which don't (and is the search case sensitive?) …

Read More
How does OPENQUERY differ for SELECT and INSERT?

I'm aware that the following query will pull down the result set from a linked server: SELECT * FROM openquery(DEVMYSQL, 'SELECT event_id, people_id, role_id, rank, last_updated FROM event_cast') However, is this the same case when …

Read More