ODBC connection

[Tal Jacob]

Hi,

How do I make ODBC connection to Mysql DB in VB?

[Moran Nave]

Hi,

You can use ADO by making New ADODB.Connection, and use this function to connect to DB:

Code: Select all

Private Function ConnectString() As String
Dim strServerName as String
Dim strDatabaseName as string
Dim strUserName as string
Dim strPassword as string

    'Make sure that you d/l and install the MySQL Connector/ODBC 3.51 Driver

strServerName = "localhost"
strDatabaseName = "DatabaseName"
strUserName = "UserName"
strPassword ="Password"

ConnectString = "DRIVER={MySQL ODBC 3.51 Driver};" & _
                "SERVER=" & strServerName & _
                ";DATABASE=" & strDatabaseName & ";" & _
                "USER=" & strUserName & _
                ";PASSWORD=" & strPassword  & _
                ";OPTION=3;"

End Function

Moran Nave,
ProcessGene Ltd.

[Tal Jacob]

And how do I make a SELECT statement?

[Moran Nave]

Use Recordset,see this code:

Code: Select all

Set rs = New ADODB.Recordset       'Creates record set
strSQL = "SELECT * FROM table WHERE id = ..."
rs.Open strSQL, cn, strDBCursorType, strDBLockType, strDBOptions


And to get the results use: rs.GetString()

Moran Nave,
ProcessGene Ltd.