Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ariel_klien
Valued Contributor

MySQL in OLE DB

Hello all,

Did Anyone succeed to implement OLE DB with MySQL DB?

BR

Ariel

Tags (2)
1 Solution

Accepted Solutions
ariel_klien
Valued Contributor

Re: MySQL in OLE DB

Please look at Connection string MySQL

5 Replies

Re: MySQL in OLE DB

Hi,

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

Regards

Anand

ariel_klien
Valued Contributor

Re: MySQL in OLE DB

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
Valued Contributor

Re: MySQL in OLE DB

Hello All,

Does anyone have an answer for that?

BR

Ariel

ariel_klien
Valued Contributor

Re: MySQL in OLE DB

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
Valued Contributor

Re: MySQL in OLE DB

Please look at Connection string MySQL

Community Browser