Issue with MDAC 2.8 with ASP databases
I recently upgraded my Win XP Pro machine from MDAC 2.7 to MDAC 2.8 and now all my asp codes that used to work are no longer working. Debugging the code got me to the part where the database connects and errors. Looking through Microsoft's site and google show that MDAC 2.8 have issues with ADO recordsets and OLEDB connections.
On Microsoft's website, they say that they have a fix for it but you will have to contact them and pay. Uninstalling the MDAC 2.8 does not work.
Two Options that I have is to reinstal Win XP to get back to MDAC 2.7. Or upgrade my codes from ASP to use ADO.NET
Since my Production server is using Win 2003, MDAC 2.8 is installed by default and it is causing a big issue with ASP codes that call databases. My only option might be to go back to Win 2000. If anybody know a workaround or fix, I would appreciate it.