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;
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?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.