RE: error when connecting to Sybase 11.x using ODBC: The buflen parameter must be set to CS_UNUSED

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: vishal subramaniam (vishalsu_at_microsoft.com)
Date: 05/13/04 

Date: Thu, 13 May 2004 10:16:01 GMT

vishalsu@online.microsoft.com

RESOLUTION:
=============
INF: ODBC Connections to Sybase SQL Servers
View products that this article applies to.
This article was previously published under Q137637
SUMMARY
The current Microsoft ODBC SQL Server Driver is not certified for use
against Sybase SQL Servers.
MORE INFORMATION
As noted in the documentation that comes with the Microsoft SQL Server ODBC
Driver, the 2.00.1912 or later versions of the Microsoft drivers are
certified for use only with Microsoft SQL Servers (the 2.00.1912 driver
shipped with SQL Server 4.21a). Though older versions of the Microsoft SQL
Server ODBC Driver could be connected to older versions of Sybase SQL
Servers, if you now need to connect to Sybase SQL Servers you should
contact ODBC vendors who are in the market of providing drivers for Sybase.
The current ODBC drivers provided by Microsoft are optimized to work with
Microsoft SQL Server and depend on features present in the Microsoft
product.

If you need to connect to Sybase SQL Servers, you can still do so by using
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. Some of the third party drivers can be used to
connect to both Microsoft and Sybase SQL Servers.

LINKS:
======
http://support.microsoft.com/default.aspx?scid=kb;en-us;280102&Product=sql
http://support.microsoft.com/default.aspx?kbid=137637

This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Alert: MS SQL worm
    ... extended procedures within most Microsoft SQL servers. ... XP_CMDSHELL to get a DOS environment and then run FTP to download a program ... BEST-OF-BREED ANTIVIRUS SOLUTION FOR MICROSOFT EXCHANGE 2000 ...
    (NT-Bugtraq)
  • Re: ODBC
    ... Yes, All SQL Servers will install MDAC 2.6, unless you already have an MDAC with ... > Does the install for the Desktop Engine include the ODBC drivers? ...
    (microsoft.public.sqlserver.msde)
  • Re: Enumerate SQL servers?
    ... enumerate all SQL servers on the network if I am not connected to a browser ... much like you do when creating a DSN through the ODBC ... connections. ...
    (microsoft.public.sqlserver.msde)
  • Re: Get all sql servers on network from dot net app.. sqldmo or reflection
    ... I have code to retrieve a list of SQL Servers (including named ... This code uses the libraries from MDAC, ... installed with newer versions of Windows or can be downloaded at Microsoft. ... > a dropdown list of all sql servers on the network. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Servers
    ... Yes, via ODBC. ... George Christoforakis. ... > Does ADO support other SQL servers except MS SQL Server? ...
    (borland.public.delphi.database.ado)