How do i use Mysql with VB 6.0

[Blazer06]

...???
what i want to do is use a MySQL database from VB.. a short tutorial or code example would be much appriciative.


Blaze

[shawshank62]

im an idiot in this area....but

shouldnt it come with the code to type? And then you can just imput that code into something like phpMYadmin

[Blazer06]

umm.... it doesnt and after reading about 250 web pages (mostly junk), and 5 minutes of codeing i got this which reads from the database after connecting.

Option Explicit

Private Sub cmdConnectMySQL_Click()
Dim cnMySql As New rdoConnection
Dim rdoQry As New rdoQuery
Dim rdoRS As rdoResultset

' set up remote data connection using the
' MySQL ODBC driver

cnMySql.CursorDriver = rdUseOdbc
cnMySql.Connect = "uid=blaze;pwd=;server=Blaze;" & _
"driver={MySQL ODBC 3.51 Driver};database=test;dsn='';"
cnMySql.EstablishConnection

With rdoQry
.Name = "selectUsers"
.SQL = "select * from my"
.RowsetSize = 1
Set .ActiveConnection = cnMySql
Set rdoRS = .OpenResultset(rdOpenKeyset, rdConcurRowVer)
End With

txtMySQL.Text = ""

Do Until rdoRS.EOF
With rdoRS
txtMySQL.Text = txtMySQL.Text & !First & " - " & !Last & vbCrLf

rdoRS.MoveNext
End With
Loop

rdoRS.Close
cnMySql.Close
End Sub


just need to get it to write and improvise from there.


Blaze

[Agent_Embryo]

You need to send SQL commands to MySQL in order to read and write to the database. That code uses "SELECT * from my" to get the information in the database table my (from what I can tell).

Search for some SQL reference webpages. You'll figure it out in notime.

[Blazer06]

yeah yeah.. i know alittle mysql (select, insert, update, create), but i need to write alittle in my program to send those to the server. which i just did.

thanks however, google rocks.. jsut the first 100 sites it found didnt.


Blaze