I'm new in MYSQL is there anybody who is expert in MSQL as backend and VB6 as front end please i'll be willing to study espcially on the connection. How and what are the procedures?

Thanks a lot in advance...hope to share also my little ideas soon...

u will require the latest version of Connector / ODBC (formerly MyODBC), (currently 3.51.06).
download and install it.
then use the following code

Dim rs As ADODB.Recordset
Dim adoconn As ADODB.Connection

Private Sub Command1_Click()

Set adoconn = New ADODB.Connection

adoconn.ConnectionString = "DRIVER={MySQL ODBC 3.15 Driver};SERVER=servername;DATABASE=dbname;UID=userid;PWD=password;OPTION=3;"


Set rs = New ADODB.Recordset

rs.ActiveConnection = adoconn

rs.LockType = adLockOptimistic

rs.CursorLocation = adUseClient

rs.CursorType = adOpenDynamic

rs.Open "mysql Query "

While Not rs.EOF

Text2.Text = rs!Name 'Name is the field name

g = MsgBox("press ok", 1, "")



End Sub

Thanks you i'll try to download...and try the code.