Solved

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

Posted on 2003-11-08
7
3,175 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
  • 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

706 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now