Sybase driver and MSSQL 2k

[Martin Lukasik]

Hi,

I'm using Sybase driver under Linux and I'm trying to connect to MSSQL
server 2000.
But unfortunately connection fails.
In Event Log on my Win 2k3 SBS I'm getting the following error message:

Error: 17832, Severity: 20, State: 7
Connection opened but invalid login packet(s) sent. Connection closed.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

I tried to update SQL server to the lastest version; currently I'm using SP4
but it still didn't resolve the problem.
Has anyone got an idea what may be wrong?
Application is written in perl, using DBD::Sybase

Thanks,
Martin

[Erland Sommarskog]

Martin Lukasik (ma****@milea.pl.i.hate.this.spam) writes:

I'm using Sybase driver under Linux and I'm trying to connect to MSSQL
server 2000.
But unfortunately connection fails.
In Event Log on my Win 2k3 SBS I'm getting the following error message:

Error: 17832, Severity: 20, State: 7
Connection opened but invalid login packet(s) sent. Connection closed.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

I tried to update SQL server to the lastest version; currently I'm using
SP4 but it still didn't resolve the problem.
Has anyone got an idea what may be wrong?
Application is written in perl, using DBD::Sybase

It is not likely to be a supported means of connection. Have you ever been
able to get this combination to work?

A guess is that the older the version of Sybase's DB-Library, the better
the chances.

Also, make sure that SQL Server is configured for SQL Server authentication.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Mark T. Kennedy]

from linux, the freeTDS driver seems to work fine against sql server
2005. caveat: i haven't tried anything other than simmple queries.

/mark

Erland Sommarskog wrote:

Martin Lukasik (ma****@milea.pl.i.hate.this.spam) writes:

I'm using Sybase driver under Linux and I'm trying to connect to MSSQL
server 2000.
But unfortunately connection fails.
In Event Log on my Win 2k3 SBS I'm getting the following error message:

Error: 17832, Severity: 20, State: 7
Connection opened but invalid login packet(s) sent. Connection closed.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

I tried to update SQL server to the lastest version; currently I'm using
SP4 but it still didn't resolve the problem.
Has anyone got an idea what may be wrong?
Application is written in perl, using DBD::Sybase

It is not likely to be a supported means of connection. Have you ever been
able to get this combination to work?

A guess is that the older the version of Sybase's DB-Library, the better
the chances.

Also, make sure that SQL Server is configured for SQL Server authentication.