Sybase driver and MSSQL 2k - Microsoft SQL Server

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

Jun 16 '06 #1

Subscribe Reply

3092

Erland Sommarskog

Martin Lukasik (ma****@milea.p l.i.hate.this.s pam) 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****@sommarsk og.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

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.p l.i.hate.this.s pam) 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

Similar topics

1586

Using Sybase to access SQL2000?

by: William Holroyd | last post by:

I recently took over a web project that utilizes a MS SQL2000 server via PHP. The web server itself is screwed and so I'm trying to configure another box to act as a temporary server until i can get the current one fixed and updated. I looked at the phpinfo() output on the current webserver and saw the previous guy had configured php with "--with-sybase=/usr/local/freetds". I have no clue as to why this was done and can't for the life of...

PHP

1540

python sybase errors

by: Josh Close | last post by:

I'm getting these errors almost every time I use sybase. I'm using it with mssql. I build it like so: python setup.py build_ext -D WANT_THREADS -D HAVE_FREETDS -U WANT_BULKCOPY python setup.py install and I'm getting these errors: Traceback (most recent call last): File "./check_mx.py", line 69, in ?

Python

6751

Python and Sybase

by: David Rysdam | last post by:

What module is most recommended for accessing Sybase from Python? This one: http://www.object-craft.com.au/projects/sybase/sybase/ ? Also, is there any module that provides a generic DB API and can be hooked to both Sybase and postgresql? This (http://www.python.org/peps/pep-0249.html) looks pretty old.

Python

2300

connecting to Sybase/MsSQL from python

by: John Fabiani | last post by:

Hi, I'm hoping someone on the list has connected to sybase/MsSQL with something that works with DBAPI 2.0 from a linux box (SUSE 9.2) because I can't seem to get it done. I found Object Craft's python code that uses FreeTDS. But I can't get it compiled. The code is looking for "sybdb.h" (first error) - of course I don't have "sybdb.h". It is not in Object Crafts code nor in the FreeTDS source. I'm guessing that I need sybase develop...

Python

2528

sybase driver

by: jamilah | last post by:

I am on windows xp, have installed sybase client, what driver do i need for tcp/ip connection to sybase12 sql server? For odbc, I only have Microsoft sql server driver Version 2000.81.9042.00

Microsoft SQL Server

3570

Sybase .NET Provider

by: Jim Douglas | last post by:

Anyone using this .NET provider. Any problems or should I stick with the Sybase OLEDB? Or worse check with the DataDirect folks for their .NET provider for Sybase? Thanks! -- Jim Douglas

.NET Framework

6115

how to connect to sybase

by: xinhuanet.com | last post by:

can you tell me how to connect to sybase database with vb.net? please give me one example.thank you!

ASP.NET

3601

Does any one know how to use php to connect sybase 5.5?

by: Alex Murphy | last post by:

As title, Thanks

PHP

5636

MS Access Connect to Sybase ASE database

by: mohsin | last post by:

Hi Expert Hope i point to the right grps, I need to connect my access to sybase ASE database and the collect/import the data. I have to use right driver to connect. Questions is, which one? and where can i get it.. I try www.sybase.com but not able to find the link to download the driver,

Microsoft Access / VBA

8031

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8443

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8107

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8315

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5971

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5467

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

2452

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1565

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1309

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General