I have a VB6 program that connects with a MySQL 4.0.17 through MyOLEDB
Provider v3.0.
At the begining of the program, when I try to connect with the
MySQL server and this one is not running, appears a MyOLEDB window
with the connection SetUp titled "MySQL Data Source Name Setup" and
with params like:
Data source name, MySQL hosts, MySQL Database name, etc...
My connection in VB is:
On Error GoTo Errores
Set oMyConexion = New ADODB.Connection
oMyConexion.ConnectionTimeout = 50
oMyConexion.CommandTimeout = 5
oMyConexion.CursorLocation = adUseClient
oMyConexion.Provider = "MySQLProv"
oMyConexion.Properties("Data Source").Value = sConnect
'oMyConexion.Properties("Data Source").Value =
"SERVER=111.111.111.111;DB=database;UID=username;P WD=pass;PORT=3306"
oMyConexion.Open
ConexionMySQL = True
Exit Function
Errores:
'Here I handle my possibles errors
Does exist any way to avoid this window and control the connection as
an error?
What's the problem, the provider, the mysql server version?
Please, I am hopeless
Thanks for all.