trying to open connection through OLEDB for MYSQL

C

chris

Hello,

I am trying to open a connectionstring for MYSQL through OLEDB.
I installed : OLE DB Provider for MySQL (MyOLEDB)
Updated 11/02/00
Versie : v.3.0

My database is a remote Database (on another server) so i think i have to
give the ip adres and then the name of the database
I tried serveral connectionstring but

Dim conconfig As IDbConnection
Dim connectieparameter As String
connectieparameter = "Provider=MySqlProv.3.0;Data
Source=;server=192.168.0.20,DB=webwiz;Password=;User ID=root;"
conconfig = New OleDbConnection(connectieparameter)
Try
conconfig.Open()
Catch ex As Exception
Dim testje As String
testje = ex.Message.ToString
End Try
WHEN STEPPING THE CONNECTIONSTRNIG
ConnectionString: "Provider=MySqlProv.3.0;Data
Source=;server=192.168.0.20,DB=webwiz;Password=;User ID=root;"
I registered myprov.dll

I get the errormessage :
ex
{System.Data.OleDb.OleDbException}
[System.Data.OleDb.OleDbException]: {System.Data.OleDb.OleDbException}
HelpLink: Nothing
InnerException: Nothing
Message: "Er is geen foutinformatie beschikbaar: E_UNEXPECTED(0x8000FFFF)."
Source: Nothing
StackTrace: " at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()
at WebApplication3.WebForm1.Button1_Click(Object sender, EventArgs e) in
c:\inetpub\wwwroot\WebApplication3\WebForm1.aspx.vb:line 50"
TargetSite: {System.Reflection.RuntimeMethodInfo}
Thanks for any help.
 
R

Reggie Burnett

Unless it has been updated recently, the OleDB provider is very broken. I
would suggest using either the ODBC driver or one of the native providers.
My native provider can be found at http://www.bytefx.com

Reggie


chris said:
Hello,

I am trying to open a connectionstring for MYSQL through OLEDB.
I installed : OLE DB Provider for MySQL (MyOLEDB)
Updated 11/02/00
Versie : v.3.0

My database is a remote Database (on another server) so i think i have to
give the ip adres and then the name of the database
I tried serveral connectionstring but

Dim conconfig As IDbConnection
Dim connectieparameter As String
connectieparameter = "Provider=MySqlProv.3.0;Data
Source=;server=192.168.0.20,DB=webwiz;Password=;User ID=root;"
conconfig = New OleDbConnection(connectieparameter)
Try
conconfig.Open()
Catch ex As Exception
Dim testje As String
testje = ex.Message.ToString
End Try
WHEN STEPPING THE CONNECTIONSTRNIG
ConnectionString: "Provider=MySqlProv.3.0;Data
Source=;server=192.168.0.20,DB=webwiz;Password=;User ID=root;"
I registered myprov.dll

I get the errormessage :
ex
{System.Data.OleDb.OleDbException}
[System.Data.OleDb.OleDbException]: {System.Data.OleDb.OleDbException}
HelpLink: Nothing
InnerException: Nothing
Message: "Er is geen foutinformatie beschikbaar: E_UNEXPECTED(0x8000FFFF)."
Source: Nothing
StackTrace: " at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()
at WebApplication3.WebForm1.Button1_Click(Object sender, EventArgs e) in
c:\inetpub\wwwroot\WebApplication3\WebForm1.aspx.vb:line 50"
TargetSite: {System.Reflection.RuntimeMethodInfo}
Thanks for any help.
Click to expand...
 
Top