DOCUMENT:Q148953  09-AUG-2001  [iis]
TITLE   :IIS Fails to Connect to Sybase Server
PRODUCT :Internet Information Server
PROD/VER:1.0
OPER/SYS:
KEYWORDS:kb3rdparty

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Windows NT Server versions 3.5, 3.51 
 - Microsoft Internet Information Server 1.0 
-------------------------------------------------------------------------------

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:

   Q137637 : 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.
======================================================================
Keywords          : kb3rdparty 
Technology        : kbWinNTsearch kbWinNT351search kbWinNT350search kbWinNTSsearch kbWinNTS351 kbWinNTS350 kbWinNTS351search kbWinNTS350search kbiisSearch kbiis100
Version           : 1.0

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 2001.