Hi,

We've been using Sybase:BLib in a Perl script to connect from a Unix
(Solaris) box to a Microsoft SQL Server 7.0. This has been fine but now
they DB guys have upgraded the MS SQL Server from 7.0 to MS SQL Server
2000 and it now no longer works.
We are getting the following error (from the 2000 server) for the same
code that works on the 7.0 DB:
Sybase error: Unexpected EOF from SQL Server.

Ideally I'd like to not have to use FreeTDS as I don't have easy access
to the QA and Prod servers to install this.

Has anyone got any idea's about getting this to work?

Thanks,

Jeremy

On Mon, 27 Mar 2006 02:50:22 -0800, jmalherbe wrote:

Short answer - you can't. MS has made their most recent servers
incompatible with the basic 4.0 TDS protocol as implemented by Sybase.

You can use FreeTDS, or you can use an ODBC driver (commercial), or you
could use a gateway of some sort so that you don't connect directly
between the Unix host and the MS-SQL db server.

Michael
--
Michael Peppler [TeamSybase] mpeppler (AT) peppler (DOT) org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html