I am pulling my hair out on this one as well. Everything was working fine for about a week and then sometime after I rebooted the server I have been getting this error but only when I use the execute stream option of the command object.

At one point I used "SET ANSI_WARNINGS OFF" and it worked that one time. I figured it was solved but unfortunetly it hasn't worked since.

Very very frustrating and lacking clues.

I too am having this problem debugging someone else ASP, it happens when we do a ADODBCommand.Execute, no clues. Have you found the cause?

I already faced with this proplem and already sold its follow my way.
- OS: Windows XP SP2
- DB: SQL Server 2000 SP4
- IIS: 5.1
- MDAC: 2.0, 2.1, 2.5, 2.6, 2.7, 2.8: I used CreateObject method so I couldnot recognize what version was used in ASP page.

At first, I used connection string like:

"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=VL050816;Data Source=thienan"

and this caused error (0x800A01FB)


After that, I changed to new connection string:

"Provider=SQLOLEDB;Data Source=thienan;database=VL050816;uid=sa;pwd=sa;"

and it's OK.