Solved

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

Posted on 2003-11-08
7
3,204 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Instering to MySQL table 5 49
Create a Select Query and Populate a Table 3 48
insert row field data graphically 4 24
Help needed with Powershell  XML to MySQL 5 46
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

832 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