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:
and it's OK.