hi...
i found this code
Code:
Private Sub ConnServer()
  'connect to MySQL server using MySQL ODBC 3.51 Driver
  Set conn = New ADODB.Connection
  conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
                        & "SERVER=localhost;" _
                        & " DATABASE=PERSONAL;" _
                        & "UID=root;PWD=root; OPTION=3"
conn.Open
End Sub
on this threat for connect to mysql from VB6.

in other web/blog, i found this code for connect to mysql from vb6
Code:
 strConn = "DRIVER={MySQL ODBC 3.51 Driver};" _
                & "SERVER=" & strServer & ";" _
                & "DATABASE=manajemen_sms;" _
                & "UID=" & UNAME & "; PWD=" & UPASS & ";" _
                & "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384
- what is the purpose of use "OPTION=3"
- where to get the other option parameter??

thanks b4