423,680 Members | 2,394 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,680 IT Pros & Developers. It's quick & easy.

how i can read data in vb6 with mysql

P: 1
hi i want to select any data form mysql with vb6

i cannected mysql with this

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

Expand|Select|Wrap|Line Numbers
  1. Set conn = New ADODB.Connection
  2.   conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
  3.                         & "SERVER=localhost;" _
  4.                         & "PORT=3306;" _
  5.                         & "DATABASE=myproject;" _
  6.                         & "UID=root;PWD=; OPTION=3;" _
  7.                         & "STMT=;"
  8.  
  9.   conn.Open
  10.  
  11.   Set rs = New ADODB.Recordset
  12.   rs.CursorLocation = adUseServer
########################

can any one hellp me
Nov 8 '14 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.