how i can read data in vb6 with mysql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • irvbman
    New Member
    • Nov 2014
    • 1

    how i can read data in vb6 with mysql

    hi i want to select any data form mysql with vb6

    i cannected mysql with this

    ############### ############### ########

    Code:
    Set conn = New ADODB.Connection
      conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
                            & "SERVER=localhost;" _
                            & "PORT=3306;" _
                            & "DATABASE=myproject;" _
                            & "UID=root;PWD=; OPTION=3;" _
                            & "STMT=;"
     
      conn.Open
     
      Set rs = New ADODB.Recordset
      rs.CursorLocation = adUseServer
    ############### #########

    can any one hellp me
Working...