How to connect MySQL database to VB2005 at design time?

[nev]

Can anyone tell me the steps how to do this or direct me to a link? I connect MySQL during runtime. I was wondering if its possible during design time so that I can use the IDE to manage all my MySQL tables.

[Dököll]

Can anyone tell me the steps how to do this or direct me to a link? I connect MySQL during runtime. I was wondering if its possible during design time so that I can use the IDE to manage all my MySQL tables.

Hiya, Nev!

It's likely you have tried this already, but there are some amazing videos I've seen with examples on connecting to SQL Server, might be able to mix it up to make it do what you need for MySQL:

http://msdn2.microsoft.com/en-us/express/aa718409.aspx

If this does not work for you, please stay tuned!

Also, Welcome!

Dököll

[nev]

Hiya, Nev!

It's likely you have tried this already, but there are some amazing videos I've seen with examples on connecting to SQL Server, might be able to mix it up to make it do what you need for MySQL:

http://msdn2.microsoft.com/en-us/express/aa718409.aspx

If this does not work for you, please stay tuned!

Also, Welcome!

Dököll

Thank you! I'll check out the link.

[nev]

Hi dokoll, I checked out the link but it only talks of Microsoft's SQL Server. This can be done because when I click the 'Add Datasource', I can select SQL Server from the list. For MySQL however, it doesn't appear in the list that's why I can't select it. How will I 'Add Datasource' MySQL database using the IDE so that I can use for example the Query Designer?

[thelner]

Hey nev,

I just started learning vb.net and mysql today and this site is really helping me a lot. They have an artice on vb.net and mysql.

[nev]

Hey nev,

I just started learning vb.net and mysql today and this site is really helping me a lot. They have an artice on vb.net and mysql.

thaksn for the input.

[WinblowsME]

Download MySQL Connector Net 5.0.8.1

Start a new project and add a reference to Microsoft Active Data Objects 2.x.
Project -> Add Reference -> COM tab -> Microsoft Active Data Objects 2.x

Modify the code to suit your needs.

Public Class Form1
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim conn As New ADODB.Connection
        Dim rs As New ADODB.Recordset
        Dim mysql_server As String = "localhost"
        Dim db As String = "database_name"
        Dim user As String = "user_name"
        Dim pass As String = "password"
        Dim sql As String
        Dim fields As Array
        Dim i As Integer
 
        Try
            conn.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};Server=" & mysql_server & ";Database=" & db & ";User=" & user & ";Password=" & pass & ";Option=3;"
            conn.Open()
 
            sql = "SELECT FirstName, LastName FROM tbladdresses ORDER BY FirstName;"
            rs.Open(sql, conn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic)
 
            fields = rs.GetRows
            rs.Close()
        Catch ex As Exception
            MsgBox("Connection string is incorrect.")
            Exit Sub
        End Try
 
        For i = 0 To UBound(fields, 2)
            Debug.Print(fields(1, i))
        Next
 
        conn.Close()
    End Sub
End Class
 

[WinblowsME]

Sorry, I misunderstood the question with my previous post. Why not download the QueryBrowser?

http://www.mysql.com/products/tools/query-browser/