Did Anyone succeed to implement OLE DB with MySQL DB?
Create the ODBC connection for this first and then use it in the OLE DB connection string.
Thanks for the quick answer,
But I have more then 200 DB to connect to...
I don't want to set ODBC to all....
I want to manage an Excel Sheet with all the connections and use variables in the connection string.
do you have an idea how to accomplish that?
Does anyone have an answer for that?
I still have the problem to connect OLE DB with MySQL Directly (without configured ODBC connection)
Does anyone have an Idea?
Please look at Connection string MySQL
Retrieving data ...