I have a major problem. I decided that it was time to upgrade MDAC on our 2
webservers, and ran an installation on both servers. However, to my surpise,
a major problem has occured.
Both servers runs applications, that uses a SQL2000 database. When making
quiries using a single connection to a single recordset, everything works as
usual. But when making f.ex.:
RS = Conn.Execute("SELECT * FROM DB-1")
Do While Not RS.EOF
RS2 = Conn.Execute("SELECT * FROM DB-2")
- i can expect up to 1 minute waitingtime, no matter how few records are in
both recordssets. The query time before upgrading MDAC was
1 second !!!
It seems that nested queries are almost impossible.
Can anybody help???