Windows Server 2003 and ADODB.Connection.2.5 generate an error

  • Article

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.