IIS ErrMsg: Specified Driver Could Not Be Loaded (142561)

The information in this article applies to:

Microsoft Internet Information Server 1.0

This article was previously published under Q142561

We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 6.0 running on Microsoft Windows Server 2003. IIS 6.0 significantly increases Web infrastructure security. For more information about IIS security-related topics, visit the following Microsoft Web site:

http://www.microsoft.com/technet/security/prodtech/IIS.mspx

SYMPTOMS

The following error appears when you query an ODBC data source from Internet Information Server (IIS):

[State=IM003][Error=0][Microsoft][ODBC Driver Manager] Specified driver
could not be loaded

CAUSE

This error occurs because the ODBC driver (SQLSRV32.DLL in this case) specified by your DSN is not in the path which is listed in the ODBC.INI file.

RESOLUTION

Check the ODBC driver path specified by your DSN in the ODBC.INI file and correct it. Below is an excerpt from an ODBC.INI file:

   [ODBC 32 bit Data Sources]
   YourDSNname=SQL Server (32 bit)

   [YourDSNname]
   Driver32=D:\WINDOWS\SYSTEM\sqlsrv32.dll

Modification Type:	Minor	Last Reviewed:	6/23/2005
Keywords:	kbinterop KB142561