468,532 Members | 1,721 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,532 developers. It's quick & easy.

Sybase driver and MSSQL 2k

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
Jun 16 '06 #1
2 2934
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
Jun 16 '06 #2
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.

Jun 20 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by William Holroyd | last post: by
reply views Thread by Josh Close | last post: by
18 posts views Thread by David Rysdam | last post: by
3 posts views Thread by John Fabiani | last post: by
1 post views Thread by jamilah | last post: by
2 posts views Thread by Jim Douglas | last post: by
1 post views Thread by xinhuanet.com | last post: by
3 posts views Thread by Alex Murphy | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.