FreeTDS Development Group

["Gulati, Samveen" <Samveen.Gulati AT savvis.com>]

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: samveen.gulati AT savvis.com
www.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@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
FreeTDS AT lists.ibiblio.org
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.