Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS & Sybase SQL Anywhere 11

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS & Sybase SQL Anywhere 11
  • Date: Mon, 21 Dec 2009 12:41:17 +0100

2009/12/21 Michal Seliga <michal.seliga AT visicom.sk>:
>
>
> On 21. 12. 2009 10:58, Frediano Ziglio wrote:
>> 2009/12/21 Michal Seliga <michal.seliga AT visicom.sk>:
>>>
>>>
>>> On 19. 12. 2009 4:56, James K. Lowden wrote:
>>>> Michal Seliga wrote:
>>>>>
>>>>> - always when i close database connection server reports:
>>>>> Connection terminated abnormally
>>>>> Disconnected TCPIP client's AppInfo: HOST=visibuntu;PID=1906
>>>>> however freetds & odbc don't seem to detect any problem (according to
>>>>> logs)
>>>>
>>>> Which API are you using?  Does it happen with bsqldb/bsqlodbc/tsql/sqsh?
>>>  yes, with tsql it happens too
>>>> A TDSDUMP log of the session would help.  If all applications produce the
>>>> same error, a tcpdump(8) log might be helpful, too, but don't post that
>>>> until we know we need it.
>>>  tdsdump is attached (freetds.log.gz)
>>>  if it will come to tcpdump please write me what you want me to set, i
>>> saw it
>>> has really lot of switches....
>> ...
>>
>> Mmm.. you login and after 2 seconds close tsql, right ??
> right, but its only for test to have log short. it happens also when i do
> some
> actions in session
>

Please try this patch (apply to CVS HEAD). I cannot test it (my server
does not detect this problem).

freddy77

>> Probably ASA 11 wants the LOGOUT token which we don't send. I would
>> add a tds_disconnect which would send TDS_LOGOUT token and that close
>> connection. I noted that we have
>> - tds_connect_and_login (login.c) which connect and manage login
>> - tds_connect (net.c) which is a small tds_open_socket wrapper
>> - tds_close_socket (net.c) which disconnect socket
>> - tds_open_socket (net.c) which connect the socket
>> Perhaps tds_disconnect is a bad name... a tds_logout is better but we
>> would probably like to have a symmetric tds_login.
>> tds_connect_and_login calls tds_send_login, tds7_send_login and
>> tds8_do_login but are all static function. Perhaps a
>> tds_logout_and_disconnect would be a perfect name. This function
>> should be called before every tds_free_socket function.
>>
>> freddy77
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS AT lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>

Attachment: vedi.diff
Description: Binary data




Archive powered by MHonArc 2.6.24.

Top of Page