VB DataEnvironment with MySQL

[rmdl1975]

I have a db in MySQL and I want to use VB DataEnvironment, but I do not get the conection to work.
In the connection I select the "OLE DB Provider for ODBC Drivers", then I select "MySQL" driver, then I put the user, pass and the name of DB.
When I do the connection test I obtain that error:
"Failure in the test to the connection due to a mistake in the initialization of the vendor. Catastrophic failure."

Does anybody know how to do this?
Thanks, in advance.

 

[dglienna]

Check out

http://www.connectionstrings.com

for the proper configuration of the connection string.

David

 

[rmdl1975]

Through connection string its everithing ok, I manage the db without any problem.

db.Open "PROVIDER=MSDASQL;dsn=MySQL;uid=root;pwd=;database=db;"

Only in VB DataEnvironment gives that error. Does anybody know the reason?

 

[rmdl1975]

Thanks dglienna, I tried to get the ConnectionSource manual and it works fine.

DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;PORT=3306;DATABASE=db; USER=root;PASSWORD=;OPTION=3;