Error occuring in Mysql 5.0 -VB.net2003 connection using adodb connection

Hi experts,
         I am trying to upgrade my project from mysql 4.x to mysql 5.x . My codes are working fine with mysql 4.x.
         but when I connect my code to mysql 5.x database at one point i got End of file thought there is data in database which I can find using client software for mysql like Toad and Heidi Sql.

       I am using adodb connectivity in my code from beginning so it will be very hart to migrate to ado.net oledb or mysql default providers.

        When i connect my code to mysql 4.x database it works fine and fetches the data.

this is my query

select sum(qd.cost) from qt_quote_details qd, qt_client_details c, qt_benefit_details b where c.client_id=b.client_id AND b.benefit_id=qd.benefit_id and qd.process_id=c.process_id and c.client_id=501 and qd.application_name='AVI'

same query works with mysql 4.x but not with mysql 5.x in my vb.net 2003 code only else it works fine in client softwares like toad and mysql.

         Few weeks before I faced the same problem and at time there was a column in database with datatype decimal and after changing it to double everything starts working again but now there is not such column in my database.

         Please give appropriate solutions.

thanks
navtaraincAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
adrpoConnect With a Mentor Commented:

Hi,

What driver are you using to connect to the mysql 5.x database?
It might be that you need to use the newer ODBC driver for 5.x.

Try to take and install the new driver:
http://dev.mysql.com/downloads/connector/odbc/5.1.html#win32

Then use this new one when you connect to the 5.x MySQL.

Cheers,
za-k/
0
 
navtaraincAuthor Commented:
I am using mysql odbc driver 3.51.11
0
 
adrpoCommented:

Then try using the odbc 5.1 and see how that goes.

Cheers,
za-k/
0
 
navtaraincAuthor Commented:
thanks it is working now
0
All Courses

From novice to tech pro — start learning today.