Solved

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

Posted on 2003-11-08
7
3,223 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
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 

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 125 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

733 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