hi everybody, i have a problem regarding sql remote connection.

i have this connection string:
DRIVER={MySQL ODBC 3.51 Driver};DESC=;DATABASE=mydb;SERVER=myserver;UID=un ame;PASSWORD=pass;PORT=;OPTION=;STMT=;

connection source:
Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DRIVER={MySQL ODBC 3.51 Driver};DESC=;DATABASE=mydb;SERVER=mydb;UID=uname; PASSWORD=pass;PORT=;OPTION=;STMT=;"

wherein mydb,uname, pass, & myserver are all confidentials.

when i run the program(vb6 of course), i get this message: "catastrophic error"

and when i try to test the connection is says: "The connection failed because of error in initializing provider." Im woondering cause my provider = msdasql right?

if my provider causes this problem, then what should i replace it?

Thanks so much.

see here for the right connection strings
http://www.able-consulting.com/ADO_Conn.htm

thnks, do i need to have the provider or not? thnks again, i'll try to fix this thing out.