MySQL in OLE DB

[ariel_klien]

Hello all,

Did Anyone succeed to implement OLE DB with MySQL DB?

BR

Ariel

[its_anandrjs]

Hi,

Create the ODBC connection for this first and then use it in the OLE DB connection string.

Regards

Anand

[ariel_klien]

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?

BR

Ariel

[ariel_klien]

Hello All,

Does anyone have an answer for that?

BR

Ariel

[ariel_klien]

Hello all,

I still have the problem to connect OLE DB with MySQL Directly  (without configured ODBC connection)

Does anyone have an Idea?

Ariel

[ariel_klien · Accepted solution]

Please look at Connection string MySQL