A user reports an occasional error when opening an ADODB.Connection to his Oracle 7 db from an ASP page through ODBC (under IIS - Windows 2000). His ODBC driver is the Oracle one, not the MS one (the driver name in ODBC administrator reportedly is "Oracle 73 ver 2.5", where "73" probably is "7.3"). The ASP error code is 0x8000FFFF, which means "Catastrophic failure" (sic) and it's related to several different situations; unfortunately i couldn't find the mine and now i'm stuck. The code of the ASP page where the error occurs is: ... set myCon = CreateObject("ADODB.Connection") myCon.Open "DSN=MYDSNNAME;uid=MyUID;pwd=MyPwd" ... and the error is on the 2nd line. The error occurs just sometimes. Most of the times this page works fine, the connection gets succesfully opened. Has anybody any clue or maybe has experienced something similar ?

It may be the reason, I'm not sure but: When creating an ActiveX object in an ASP page you need to prefix it with Server. i.e.: set myCon = Server.CreateObject("ADODB.Connection") Hope this helps! Cheers.