 | | | Problem with MyOdbc 3.51.11 and MySql4.1.10 and VB .Net | Problem with MyOdbc 3.51.11 and MySql4.1.10 and VB .Net 2005-02-18 - By Jorge Nunes (GN/dpi)
Back
Hi everyone!
I have a strange problem with MyOdbc 3.51.11, MySql 4.1.10 and VB .Net
Recently I moved to MySqlFront version 3.2 to be able to connect to
MySql 4.1.10 on my Windows XP notebook.
To connect successfully, I'd to install MyOdbc 3.51.11 instead of MyOdbc
3.51.06. This solution works like a charm but...... when I run a program
made in VB .Net I get strange errors when I try to make a query to the
database. In this situation the object get equal to Nothing, I explain
with some code:
Dim reader As IDataReader
For i=0 to 10000
Dim qry As String = "SELECT * FROM table WHERE id=" & I & "
........."
reader = Me._dbCom.query(qry)
While reader.Read()
... some code
If Not reader Is Nothing Then reader.Close()
End While
Next I
Note that object _dbCom hides that code needed to make the connection
bla bla bla...
The problem is that the "reader" becomes NOTHING randomly and the system
throws an exception (of course!).
This didn't occurred with versions of MyOdbc 3.51.06, MySql 4.0.xx and
the sabe VB code.
Is there anyone that already passed through this and found a solution?
Thank you and thanks to the guys that make MySql* a good piece of
software.
Jorge
Earn $52 per hosting referral at Lunarpages.
|
|
|