connect to mysql database with ADO.NET

[djcybex]

i am desperate....

 

i connect to the database BUT when i want to read data i get errors like:

No error information available: DB_E_NOTABLE(0x80040E37).

 

anyway here is my code:

Dim SqlCMD As New OleDbCommand()
Dim strSql As String

Dim conString As String = "Provider=MySQLProv;Location=localhost;Data Source=mzp_sem;User Id=uid;Password=pass;"
Dim con As New OleDbConnection(conString)

If con.State = ConnectionState.Closed Then con.Open()
Console.WriteLine("Connection State:" & con.State.ToString)

SqlCMD.Connection = con
SqlCMD.CommandText = "SELECT * FROM foto ORDER BY id"

Dim MyDataReader As OleDbDataReader = SqlCMD.ExecuteReader' here is error

While MyDataReader.Read
  MsgBox(MyDataReader("id"))
End While

 

any ideas?

 

 

i've tried also this code but produces same error:

Dim da As New System.Data.OleDb.OleDbDataAdapter("Select * from foto", con)
Dim ds As New DataSet()
da.Fill(ds, "foto") 'here is error

 

HELP!!! (or i will have to go back to COM ADO.... there it works)

 

thanks in advance!

Matej

Edited December 18, 2002 by djcybex

[djcybex]

i found out that it doesn't support TEXT/BIGTEXT Type...

if i don't use this type i don't get the error but if i use it then i get that error

 

that error is for "table not found"

 

realy strange... but this means i can't use MySQL database...

damn.... i am so angry

[Derek Stone]

http://www.mysql.com/articles/dotnet/

[djcybex]

aaaaaa THANX MAN!

i needed that HotFix ..... I told you that it was a bug :)

 

it works perfect now!!

 

thank you again