Sybase Database - Connect from Unix (Perl) to MS SQL Server 2000

Author

Connect from Unix (Perl) to MS SQL Server 2000

jmalherbe@gmail.com

2006-03-27, 7:23 am

Hi,

We've been using Sybase::DBLib 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

Michael Peppler

2006-03-27, 1:23 pm

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

> Hi,
>
> We've been using Sybase::DBLib 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?

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@peppler.org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html

Sponsored Links