Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Sybase ODBC Connection error: [Sybase][ODBC Driver]Bad TDS response stream received from server Options

3 posts in General Discussion Last posting was on 2012-10-24 01:24:00.0Z
Ganesh Posted on 2012-05-09 06:13:44.0Z
Sender: 72a9.4faa0ac1.1804289383@sybase.com
From: ganesh
Newsgroups: sybase.public.ase.general
Subject: Sybase ODBC Connection error: [Sybase][ODBC Driver]Bad TDS response stream received from server Options
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4faa0b18.72bd.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 8 May 2012 23:13:44 -0700
X-Trace: forums-1-dub 1336544024 172.20.134.41 (8 May 2012 23:13:44 -0700)
X-Original-Trace: 8 May 2012 23:13:44 -0700, 172.20.134.41
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31097
Article PK: 73989

Dear Sybase Experts

I am trying to connect to Sybase ASE server remotely using
C++ ODBC
client. ODBC Client and Sybase ASE Server both are on
Windows 2008 R2
64 bit.
The call to SQLDriverConnect fails with following error:
[Sybase][ODBC Driver]Bad TDS response stream received from
server.
Unexpected end of reponse during login negotiation
and sqlstate set to 08S01.
When I "Test Connection" in ODBC Data Source Administrator,
connection
succeeds without any problems.
I am using 64 bit Sybase ODBC driver and "sa" login for
connection.
I tried using the DSN & DSN-less connection strings, but
still the
error appears.
DSN=sybase_ase_64
Driver=Adaptive Server
Enterprise;server=remote_host_name;Port=5000;uid=ase_user;pwd=xxxx;
Can you please help to guide me about this error and how to
resolve it?

Thanks in advance.
Best Regards,
Ganesh


Paul Vero [Sybase] Posted on 2012-05-14 16:36:07.0Z
From: "Paul Vero [Sybase]" <pvero@nospam.com>
Newsgroups: sybase.public.ase.general
References: <4faa0b18.72bd.1681692777@sybase.com>
Subject: Re: Sybase ODBC Connection error: [Sybase][ODBC Driver]Bad TDS response stream received from server Options
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fb13477$1@forums-1-dub>
Date: 14 May 2012 09:36:07 -0700
X-Trace: forums-1-dub 1337013367 10.22.241.152 (14 May 2012 09:36:07 -0700)
X-Original-Trace: 14 May 2012 09:36:07 -0700, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31106
Article PK: 73996

Hi Ganesh,

What are the exact versions of

ASE ODBC Driver
ASE server

The error sounds like some bad tds is being received and the driver isn't
able to interpret this response from the server. Does this happen everytime
you connect or randomly?

Thank you,
-Paul

<ganesh> wrote in message news:4faa0b18.72bd.1681692777@sybase.com...
> Dear Sybase Experts
>
> I am trying to connect to Sybase ASE server remotely using
> C++ ODBC
> client. ODBC Client and Sybase ASE Server both are on
> Windows 2008 R2
> 64 bit.
> The call to SQLDriverConnect fails with following error:
> [Sybase][ODBC Driver]Bad TDS response stream received from
> server.
> Unexpected end of reponse during login negotiation
> and sqlstate set to 08S01.
> When I "Test Connection" in ODBC Data Source Administrator,
> connection
> succeeds without any problems.
> I am using 64 bit Sybase ODBC driver and "sa" login for
> connection.
> I tried using the DSN & DSN-less connection strings, but
> still the
> error appears.
> DSN=sybase_ase_64
> Driver=Adaptive Server
> Enterprise;server=remote_host_name;Port=5000;uid=ase_user;pwd=xxxx;
> Can you please help to guide me about this error and how to
> resolve it?
>
> Thanks in advance.
> Best Regards,
> Ganesh


Steve Posted on 2012-10-24 01:24:00.0Z
Sender: 4c8c.508742a5.1804289383@sybase.com
From: Steve
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase ODBC Connection error: [Sybase][ODBC Driver]Bad TDS response stream received from server Options
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50874330.4cb6.1681692777@sybase.com>
References: <4faa0b18.72bd.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 23 Oct 2012 18:24:00 -0700
X-Trace: forums-1-dub 1351041840 172.20.134.41 (23 Oct 2012 18:24:00 -0700)
X-Original-Trace: 23 Oct 2012 18:24:00 -0700, 172.20.134.41
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31467
Article PK: 74355

Did you ever find a solution to this? I am having the same
issue.

> Dear Sybase Experts
>
> I am trying to connect to Sybase ASE server remotely using
> C++ ODBC
> client. ODBC Client and Sybase ASE Server both are on
> Windows 2008 R2
> 64 bit.
> The call to SQLDriverConnect fails with following error:
> [Sybase][ODBC Driver]Bad TDS response stream received from
> server.
> Unexpected end of reponse during login negotiation
> and sqlstate set to 08S01.
> When I "Test Connection" in ODBC Data Source Administrator
> , connection
> succeeds without any problems.
> I am using 64 bit Sybase ODBC driver and "sa" login for
> connection.
> I tried using the DSN & DSN-less connection strings, but
> still the
> error appears.
> DSN=sybase_ase_64
> Driver=Adaptive Server
> Enterprise;server=remote_host_name;Port=5000;uid=ase_user
> ;pwd=xxxx; Can you please help to guide me about this
> error and how to resolve it?
>
> Thanks in advance.
> Best Regards,
> Ganesh