Skip to Content.
Sympa Menu

freetds - Re: [freetds] freetds failed to connect to MSSQL server ends with error ( Unable to open socket There was a problem connecting to the server )

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Arlen Drina <arlytex AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] freetds failed to connect to MSSQL server ends with error ( Unable to open socket There was a problem connecting to the server )
  • Date: Mon, 14 Sep 2009 22:29:55 +0200

Here is that connection over telnet works.

telnet 1.1.1.1 1433
Trying 1.1.1.1 ...
Connected to 1.1.1.1
Escape character is '^]'.


I am very cofused why is is "unable to connect " when used freetds, I
beleive config files are ok.

Suggestionas are welcome

Regards,

Arlen

On Mon, Sep 14, 2009 at 8:56 PM, Arlen Drina <arlytex AT gmail.com> wrote:
> Yes I can connect using telnet 1.1.1.1 1433 without any problems.
>
>
> Thank you for comments.
>
>
> Nice regards,
>
> Arlen
>
>
>
>
> On Mon, Sep 14, 2009 at 6:04 PM,  <jklowden AT schemamania.org> wrote:
>> On Mon, Sep 14, 2009 at 12:13:32PM +0200, Arlen Drina wrote:
>>> I read all what is already suggssted here :
>>>
>>> https://lists.ibiblio.org/sympa/arc/freetds/2009q3/024997.html
>>>
>>>  I do know much about freetds so any help is welcome. Bellow are
>>> outputs of proposed step on link above.
>>> I have also debian+freetds 0.8.2 but I cannot connect to MSSQL server
>>> using isql or tsql .
>> ...
>>> 11:35:29.422216 21769 (log.c:190):Starting log file for FreeTDS 0.82
>>>         on 2009-09-14 11:35:29 with debug flags 0xffff.
>> ...
>>> 11:35:29.423411 21769 (net.c:210):Connecting to 1.1.1.1 port 1433 (TDS
>>> version 8.0)
>>> 11:35:29.427509 21769 (net.c:264):tds_open_socket: connect(2) returned
>>> "Operation now in progress"
>>> 11:35:29.970187 21769 (util.c:334):tdserror(0x90100a8, 0x90109d8, 20008,
>>> 4)
>>> Msg 20008, Level 9, State -1, Server OpenClient, Line -1
>>> Unable to open socket
>>> 11:35:29.970414 21769 (util.c:368):tdserror: client library returned
>>> TDS_INT_CANCEL(2)
>>> 11:35:29.970519 21769 (util.c:389):tdserror: returning TDS_INT_CANCEL(2)
>>> 11:35:29.970621 21769 (net.c:310):tds_open_socket() failed
>>> 11:35:29.970737 21769 (mem.c:563):tds_free_all_results()
>>> There was a problem connecting to the server
>>
>> http://freetds.cvs.sourceforge.net/viewvc/freetds/freetds/src/tds/net.c?revision=1.71.2.1&view=markup&pathrev=BRANCH0_82
>>
>> Disregard my prior message.  The error "Unable to open socket" is
>> misleading in 0.82.  It should report, "Unable to connect".  (One
>> difference between CVS HEAD and 0.82 is that in 0.82 an error returned by
>> connect(2) is reported as a socket error.  It should be and currently is
>> reported as a connection error.)
>>
>> Are you able to telnet to 1.1.1.1 port 1433?  The message says you can't.
>>
>> --jkl
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS AT lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>




Archive powered by MHonArc 2.6.24.

Top of Page