[freetds] tsql connection attempt returns Message 20000 "No error"

Gulati, Samveen Samveen.Gulati at savvis.com
Mon Aug 5 08:54:24 EDT 2013

Hi James,

Thank you for your response. It helped me solve the problem I encountered after the one listed here. The original issue of this thread was caused by incorrect credentials(I.D.I.O.T issue->Different credentials in different environments). 

The problem your response helped solve was :

Message String: Adaptive Server connection failed
 at dbConnect.pl line 19
Couldn't connect to DB Host: OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (34)
Server COL_P_1, database
Message String: Adaptive Server connection failed

This was caused by incorrectly selected TDS version (the default of 4.2 instead of the correct 5.0).

However, the next issue is that arose was that the server refused to accept the "set textsize ..." command, which I solved by commenting out the relevant setting from the freetds.conf.

Samveen S. Gulati | Senior Software Engineer | Enterprise Automation Systems

Savvis, A CenturyLink Company 
Salarpuria Touchstone, 2nd Floor
Survey No. 15/1A & 14P7
Kadubeesanahalli, Varthur Hobli
Bangalore, India
Mobile: +91.90.0886.6221
Email: samveen.gulati at savvis.com

Savvis Communications Private Limited | VAT/TIN No.: 29780609228 

-----Original Message-----
From: freetds-bounces at lists.ibiblio.org [mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of James K. Lowden
Sent: Sunday, August 04, 2013 1:42 AM
To: freetds at lists.ibiblio.org
Subject: Re: [freetds] tsql connection attempt returns Message 20000 "No error"

On Tue, 23 Jul 2013 13:42:35 +0000
"Gulati, Samveen" <Samveen.Gulati at savvis.com> wrote:

> there is no internal documentation on the Sybase server version, and I 
> don't have access to the DB. I only have the host, port, db and 
> credentials. This connection attempt is to debug perl-DBD-Sybase 
> (using FreeTDS) connectivity.
> On trying connecting to the server, I get:
> [tools at lookingglass src]$ tsql -H sl7ncappdv12.savvis.lab -p 4100  -U 
> netcool -P netcool locale is "en_US.UTF-8"
> locale charset is "UTF-8"
> using default charset "UTF-8"
> Msg 20000 (severity 0, state 0) from COL_P_1:
>         "No error"
> Error 20002 (severity 9):
>         Adaptive Server connection failed There was a problem 
> connecting to the server

You connect and log in, but the server responds with a user-defined error message 20000 ("No Error") and then disconnects.  i'm not sure if that's a message without an error or an error without a message.  

Since you know it's Sybase, you might try TDS 5.0. Perhaps maybe it could be the server might be configured to reject 4.2 connections, or treats them oddly.  It's been over a decade (two?) since Sybase made a
4.2 server.  

Otherwise I'd contact my sysadmin and ask what the significance of message 20000 is.  


FreeTDS mailing list
FreeTDS at lists.ibiblio.org

This message contains information which may be confidential and/or privileged. Unless you are the intended recipient (or authorized to receive for the intended recipient), you may not read, use, copy or disclose to anyone the message or any information contained in the message. If you have received the message in error, please advise the sender by reply e-mail and delete the message and any attachment(s) thereto without retaining any copies.

More information about the FreeTDS mailing list