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...

VB Code:
  1. Imports System.Data.OleDb
  2. Public Class specialeventinfo
  3.     Inherits System.Web.UI.Page
  4.     Protected WithEvents Text1 As System.Web.UI.HtmlControls.HtmlInputText
  5.     Protected WithEvents txtEventInfo As System.Web.UI.HtmlControls.HtmlTextArea
  6.  
  7.  
  8.     Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
  9.  
  10.         If Application("Connection") Is Nothing Then
  11.             Dim MySQLConn As OleDbConnection, ConString As String
  12.             Try
  13.                 ConString = "Provider=MySQL;Data Source=111.11.111.11;Initial Catalog=wild;User ID=uid;Password=pwd;"
  14.                 MySQLConn = New OleDbConnection(ConString)
  15.                 MySQLConn.Open()
  16.             Catch ex As Exception
  17.                 Response.Write("Connection Error")
  18.             End Try
  19.         End If
  20.     End Sub
  21.  
  22. End Class

Thanks!