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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

adrpoCommented:

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.