Member Avatar for rustyboy

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
  • 74 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by rustyboy
Member Avatar for swapna7999

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

Member Avatar for rustyboy

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.