0

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...

2
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by rustyboy
0

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;"


adoconn.Open

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, "")

rs.MoveNext

Wend

End Sub

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.