I have developed a program in VB6 connecting to an SQL server using ADO and the OLEDB provider. Now I want connect to a mySQL server. The only option next to using ODBC is by my knowledge mySQLProv. I have 2 problems with this provider:
1) When I use the connection.Open with the following connection string (or any other):
connection.Open "Provider= mysqlprov;" & _
"Server = Localhost" & _
"DataBase= myDB;" & _
"Uid = myUser;Pwd = myPW;"
I get a popup screen "MySQL data source Name Set up" where I have to fill in the same data. Is there any way around this?
2) When I fill the data I am able to connect to the database but I am getting some problems with SQL statements that do work in mySQL directly but not via the connection:
a) tablenames longer than 19 characters generate an error
b) JOIN expressions do not seem to work?
Can anybody shed some light on this?
Thanks in advance,