469,904 Members | 1,898 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,904 developers. It's quick & easy.

A window setup is opened when I try to connect VB to MySQL

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.
Jul 20 '05 #1
0 1338

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Krzysztof Ksi±żek | last post: by
2 posts views Thread by find clausen | last post: by
reply views Thread by Luca | last post: by
3 posts views Thread by simora | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.