Adapter.Fill ?

[Nick Seng]

Using VB.net Can somebody help me? I'm using vb to connect to MySQL through ODBC using the following code Dim Con as New ODBCConnection("_some connection_") Dim Adp as New ODBCDataAdapter Dim ds as New DataSet() Con.Open() Adp.SelectCommand.Connection = Con Adp.SelectCommand.CommandText = "SELECT * FROM tablename" Adp.Fill(ds,"tablename") The error occurs at the Fill with message: NO_DATA, but if I use ExecuteReader instead, there's no error and the data's there. Is there something wrong with the code? Or is there something I should know about the Microsoft.Data.Odbc namespace? Please Help! Notorious SMC

---

The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning Mark Twain
Get your facts first, and then you can distort them as much as you please Mark Twain