471,084 Members | 796 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,084 software developers and data experts.

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 3004
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.