Microsoft OLE DB Provider for ODBC Drivers (0x80020009) Error when viewing data on ASP page

Hi,
    I have been using ASP & MySql for a while now on my server (Win2K Av Server) and all has been ok. I recently had a hardware failure on my server due to it's age in which I fixed and all was ok again. A few weeks ago I brought a new server (higher spec) and rebuilt it and configured it as far as I can see identically to the old server (e.g Win2K Av Server) and transferred all the information (Folders,Website etc..) to the new server and everything worked just as it does on the old server apart from one ASP webpage that I am trying to view the data on. When I try to view the data I get the following error : -

Microsoft OLE DB Provider for ODBC Drivers (0x80020009)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/databases/doa/viewrec.asp

I am sure this is not down to the ASP code as when I view this data on my old server with the same database and ASP code it displays the information ok whitout any problems. All my other web pages on my new server that view data work ok apart from this one.

I suspect that there is a setting in MySql which is not set correctly but I cannot see where

Please Help !!!

Many Thanks

TSTFS

TSTFSAsked:
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.

SqueebeeCommented:
Are you certain that your connection string is identical on both machines? If you use a DSN is it the same option values as the old server?
0
TSTFSAuthor Commented:
Hi,
       Yes my connection string is identical and the DSN has the same value as the old server.

Thanks,

TSTFS
0
SqueebeeCommented:
Are you using the same version of MySQL? If not, are you using the same version group? (Still 3.x if you used 3.x before)
Are you using the same version of MyODBC?
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

TSTFSAuthor Commented:
Hi,
      Yes, everything is identical to the old sever but the problem still persists, which is quite annoying, as it is probably somthing really simple which will solve my problem.

Thanks,

TSTFS
0
SqueebeeCommented:
Do you still have access to the old machine? Try point the ASP on the new machine to the old machine's database, then try pointing the old ASP to the new machine's database. If scenario 1 breaks and 2 does not then look at the new machine's ASP and MyODBC, if 2 breaks and 1 does not, then look at the new machine's database.
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
TSTFSAuthor Commented:
Squeebee, Thanks for pointing me in the kind of right direction, after reading your last comment I decided to look at the ODBC drivers and found that the MDAC was v 2.1 on my new machine and the MDAC was v 2.5 on my old machine. I upgraded my MDAC to v 2.8 and it displayed all the information ok first time.

Cheers,

TSTFS .
0
SqueebeeCommented:
Glad you found a solution.

Regards,
Mike Hillyer
www.vbmysql.com
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
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.