IIS Fails to Connect to Sybase Server (148953)



The information in this article applies to:

  • Microsoft Windows NT Server 3.5
  • Microsoft Windows NT Server 3.51
  • Microsoft Internet Information Server 1.0

This article was previously published under Q148953
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:

SYMPTOMS

If you try to connect to a Sybase Database via an .idc file using the ODBC drivers included in Internet Information Server (IIS), you may get the following error message:
Error performing query state=01000, error 1225 Microsoft ODBC SQL Server
Driver DBNMPNTW Connection open Create file

State = 08001 error = 1225 Microsoft ODBC SQL Server Driver unable to
connect to data source.

CAUSE

The current Microsoft ODBC SQL Server Driver is not certified for use against Sybase SQL Servers.

For additional information on ODBC drivers, please see the following article in the Microsoft Knowledge Base:

137637 : INF: ODBC Connections to Sybase SQL Servers

RESOLUTION

To correct this problem you need to use a Sybase SQL Server ODBC drivers available from other vendors. You can contact Sybase Corporation for drivers certified for use against Sybase SQL Servers. Many third party ODBC vendors also provide ODBC drivers certified for use against Sybase. Most ODBC driver vendors maintain a presence in the ODBC section of the WINEXT forum on CompuServe.

Modification Type:MinorLast Reviewed:6/23/2005
Keywords:kb3rdparty KB148953