Mysql Odbc Connector 64 Bit

[Karriem Drewery]

Anerror message from Data Direct ODBC drivers for MySQL is shown when trying to connect to MySQL Community Servers database using DataStage ODBC enterprise stage or trying to import the table definition from the same database.IBM Information...

I had tried installing the mysql-connector-odbc_8.0.22-1ubuntu18.04_amd64.deb package and it had complained about not finding the mysql-community-client-plugins package. I tried a few variations of apt-cache search mysql-community-client-plugins to locate this additional package but nothing came up.

I have gone through the following steps to install from the more generic unix files - MySQL :: MySQL Connector/ODBC Developer Guide :: 4.2.2 Installing Connector/ODBC from a Binary Tarball Distribution

When I look at the ODBC Data Source Administrator on my desktop (where the query fails), the drivers tab shows 2 MySQL drivers: MySQL ODBC 5.3 ANSI Driver and MySQL ODBC 5.3 Unicode Driver. I tried uninstalling the MySQL drivers and installing the latest MySQL drivers with the same error.

Sounds like a bug in Toad Data Point. We bundle our own mySQL drivers, so the error you are getting should not be a problem. What version are you using? Can you download the latest Toad Data Point, which is 4.1?

Yes, I am attempting to run the query in TDP. Yes, windows is a 64 bit version. I did uninstall the MySQL ODBC drivers, and installed the 64 bit MySQL ODBC drivers. The download file is entitled: mysql-connector-odbc-5.3.7-winx64. Do you think I need to reinstall using a different file?

It doesn't work for me as well for the version mentioned upper (and Connector/NET 8.0.33 as well)

The solution mention upper to downgrade to the 8.0.16 version (Connector/NET) works for me (Exit Power BI application, remove old installation of old connectors, install the 8.0.16 version, and then reopen the Power BI desktop solution and it should work).

The version 8.0.32 works for me as well (by following the same step as above (exit the Power BI Desktop app, install the 8.0.32 version, and then reopen the Power BI desktop solution and it should work as well)

I tried everything. This is ridiculous.

I end up with seting up data pipiline with a python connector connecting to the mysql database and retreiving data as csv file

then I will connect that csv file to the power bi...

Thanks Microsoft

UPDATE: I went to install MySQL Community on a fresh device and the dialogue box came up with a mandatory upgrade : Connector/NET 8.0.31 (Upgrading Connector/NET 8.0.16) - see attached. So maybe this is a fix from MS/Oracle? it would be nice to know so that we can all use the latest version - MS/Oracle are you there? can you respond?

Hey I'm on Windows 11. I had the same issue with MySQL Connector Net 8.0.29. My fix was uninstall MySQL Connector Net 8.0.29. Then I installed an older version. MySQL Connector Net 8.0.23 to be specific. Seems like bug with version 8.0.29. On the download page click Archives tab to try an older version.

There are no headers on the functions as they should be pretty easy to understand anyway. The functions that I have written are named after the PHP counterparts since I use them a lot and they make sense to me.

Good timing for me because I need to start working on a MySQL app to talk to a remote database, but my utility will be run from many different locations and bringing along an install of ODBC is really not going to be practical.

I think I see the problem. In the included udf file, it doesn't just define functions, it also calls __mysql_odbc() looking for a MySQL installed driver and if none is found, it sits spinning in an endless loop. In my case here, I see that this machine doesn't currently have a MySQL ODBC driver installed.

*GERMAN* [note: you are not allowed to remove author / modified info from my UDFs]My UDFs:[_SetImageBinaryToCtrl] [_TaskDialog] [AutoItObject] [Animated GIF (GDI+)] [ClipPut for Image] [FreeImage] [GDI32 UDFs] [GDIPlus Progressbar] [Hotkey-Selector] [Multiline Inputbox] [MySQL without ODBC] [RichEdit UDFs] [SpeechAPI Example] [WinHTTP]UDFs included in AutoIt: FTP_Ex (as FTPEx), _WinAPI_SetLayeredWindowAttributes

This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.

Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here

RegExp tutorial: enough to get started

PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.

SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.

An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.

SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)

A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!

SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Anticipating Errors : "Any program that accepts data from a user must include code to validate that data before sending it to the data store. You cannot rely on the data store, ...., or even your programming language to notify you of problems. You must check every byte entered by your users, making sure that data is the correct type for its field and that required fields are not empty."

Since your ODBC connection is failing, you need to look at your odbc config extremely carefully and ensure that all of your required dependencies are installed for a successful Mysql/ODBC connection. The full list of ODBC DSN settings for the mysql odbc connector can be found here:

-odbc/en/connector-odbc-configuration-connection-parameters.html

3a8082e126