Connection string MySQL

[ariel_klien]

Hello all.

I have more then 500 connections to MySQL DB.

I have all the details of the connections in a table.

Is there an option that use connection string with the table without configure ODBC for each DB?

I tried:

ConnectionString = "DRIVER={MySQL ODBC 5.2 Unicode Driver};  SERVER=10.10.10.10; Port=3306;  USER=venu;  PASSWORD=venu; OPTION=3;"

But it is not working.

Does anyone have an Idea

Ariel.

[ariel_klien]

This is what i'm getting.

No matter what I put inside - it doesn't wok.

[Peter_Cammaert]

IMHO this has nothing to do with your connection string as such, but with failing SQL server authentication. The login prompt keeps coming back, whatever you enter in the two input fields, right?

I think you can solve this problem by using a windows account that has SQL Server access privileges by default, or by switching SQL server to mixed authentication mode (SQL Server+Windows Integrated Authentication) and using a SQL Server-defined UserID+Password.

You may want to verify this explanation with your SQL Server dba.

[Peter_Cammaert]

Now that I'm glancing over our latest posts again, this question came up: why does the dialog say "SQL Server login" when in reality you seem to want to connect to a MySQL database? Driver mixup?

Peter

[ariel_klien · Accepted solution]

i found the solution:

CONNECT TO [Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DRIVER={MySQL ODBC 5.1 Driver};
UID=$(vUser);Server=$(vServer);Database=$(vDB);Password=$(vPassword);OPTION=3;PORT=$(vPort);"];

Ariel