[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2003-11-08
7
Medium Priority
?
3,246 Views
Last Modified: 2007-12-19
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

0
Comment
Question by:TSTFS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 17

Expert Comment

by:Squeebee
ID: 9708136
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
 

Author Comment

by:TSTFS
ID: 9715787
Hi,
       Yes my connection string is identical and the DSN has the same value as the old server.

Thanks,

TSTFS
0
 
LVL 17

Expert Comment

by:Squeebee
ID: 9716142
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
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 

Author Comment

by:TSTFS
ID: 9762644
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
 
LVL 17

Accepted Solution

by:
Squeebee earned 500 total points
ID: 9763456
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
 

Author Comment

by:TSTFS
ID: 9809796
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
 
LVL 17

Expert Comment

by:Squeebee
ID: 9810369
Glad you found a solution.

Regards,
Mike Hillyer
www.vbmysql.com
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question