Connection to MySQL

[Arc]

Hi, What would the Provider name be for a MySQL DB? I'm using the oledb connection type and must provide a provider name and i have no idea what to put as the provider for MySQL.

Here's the code i have but it no worky...

Imports System.Data.OleDb
Public Class specialeventinfo
    Inherits System.Web.UI.Page
    Protected WithEvents Text1 As System.Web.UI.HtmlControls.HtmlInputText
    Protected WithEvents txtEventInfo As System.Web.UI.HtmlControls.HtmlTextArea
 
 
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
 
        If Application("Connection") Is Nothing Then
            Dim MySQLConn As OleDbConnection, ConString As String
            Try
                ConString = "Provider=MySQL;Data Source=111.11.111.11;Initial Catalog=wild;User ID=uid;Password=pwd;"
                MySQLConn = New OleDbConnection(ConString)
                MySQLConn.Open()
            Catch ex As Exception
                Response.Write("Connection Error")
            End Try
        End If
    End Sub
 
End Class

Thanks!

[Arc]

I've also tried using the Microsoft.Data.ODbc namespace to no avail...

Imports Microsoft.Data.Odbc
Public Class specialeventinfo
    Inherits System.Web.UI.Page
    Protected WithEvents Text1 As System.Web.UI.HtmlControls.HtmlInputText
    Protected WithEvents txtEventInfo As System.Web.UI.HtmlControls.HtmlTextArea
 
 
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
 
        If Application("Connection") Is Nothing Then
            Dim MySQLConn As OdbcConnection, ConString As String
            Try
                ConString = "Driver={MySQL ODBC 3.51 Driver};Server=11.11.11.11;Database=wild;uid=uid;pwd=pwd;option=3"
 
                MySQLConn = New OdbcConnection(ConString)
                MySQLConn.Open()
            Catch ex As Exception
                Response.Write("Connection Error")
            End Try
        End If
    End Sub
 
End Class

I get this error...

Microsoft.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at Microsoft.Data.Odbc.OdbcConnection.Open() at OptimaBackEndTest.specialeventinfo.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\OptimaBackEndTest\specialeventinfo.aspx.vb:line 33

[BradRoberts]

Try looking here:

http://aspwire.com/brief.asp?7410