Hello everyone,

I have an ASP app that calls a COM object which returns a recordset that has two
recordsets - one behind the other.  On my local machine, the testing machine and the
staging server - the call to

Set rs = rs.NextRecordset

has always worked.  However, we just built a new production machine and are testing
our apps on it before we officially release.  This new server has win2k sp3, and the
aforementioned boxes only have sp2.  The new production server is telling us that
"Object or provider is not capable of performing requested operation."  I installed
sp3 on my local box and now I'm getting the error!

I've checked the version of the msado15.dll - and it matches between my box and the
new prod box.  I also used microsoft's dll service desk app
(http://support.microsoft.com/default.aspx?scid=/servicedesks/fileversion/dllinfo.asp&SD=MSDN&FR=0)
and the version i have is called MDAC sp3, and the version on the staging is called
MDAC sp2 (expected).

So, my question is this:  has anyone else had any problems with this?  and does
anyone have any suggestions?

i have not yet installed the latest security update for the MDAC though (but, from
what i understand, that's an RDS problem and i'm not sure if it would affect what
i'm doing).

Thanks,

John

John Pirkey
MCSD
http://www.stlvbug.org

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com