By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,780 Members | 1,550 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,780 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.