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:
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!![]()





Reply With Quote