Re: tsql connection attempt returns Message 20000 "No error"

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 :

<snippet>
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
</snippet>

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.

Regards,
--
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: [email protected]
www.savvis.com

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

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

On Tue, 23 Jul 2013 13:42:35 +0000
"Gulati, Samveen" <[email protected]> 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@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.  

HTH.

--jkl
 
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds

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.