Windows Server 2003 and ADODB.Connection.2.5 generate an error
When you use Windows Server 2003, avoid using the following code with a Solution Site:
Server.CreateObject("ADODB.Connection.2.5")
If you use this code, the site displays the following error code:
Server object, ASP 0177 (0x800401F3) Invalid ProgID
Solution
Windows Server 2003 runs ActiveX Data Objects (ADO) version 2.7; ADO version 2.7 will not make a connection specified for ADO version 2.5. To avoid this incompatibility, change the code to the following:
Server.CreateObject("ADODB.Connection")
Copyright © 2005 Microsoft Corporation.
All rights reserved.