Skip to Content.
Sympa Menu

freetds - Re: [freetds] cannot connect with tsql

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Igor Korot <ikorot AT earthlink.net>
  • To: Kevin Reed <theeswashbuckler AT gmail.com>, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] cannot connect with tsql
  • Date: Wed, 7 Jan 2009 18:42:01 -0500 (EST)

Hi, Kevin,

-----Original Message-----
>From: Kevin Reed <theeswashbuckler AT gmail.com>
>Sent: Jan 7, 2009 6:27 PM
>To: Igor Korot <ikorot AT earthlink.net>, FreeTDS Development Group
><freetds AT lists.ibiblio.org>
>Subject: Re: [freetds] cannot connect with tsql
>
>Hello Igor,
>I removed the ip address from the log file as it is a production
>machine and i would prefer not to have its ip address posted on a
>publicly accessible page which this mailing list is.
>
>so yes the raw log file did have the ip address listed where "[ip
>address removed]" is.

Umm... I didn't talk about ip address...

>and i am rather sure it is listening on port 5000 i can telnet into
>that port and it connects then disconnects with this output:
>
>Escape character is '^]'.
>Connection closed by foreign host.
>
>so it looks like the port is open.

but talked about your MS SQL Server listening on port 5000.
This is kind of unusual port.

Standard (default) freeTDS is looking at port 1434.
Did you override the .ini file to look at this port?

>-kevin

Thank you.

>
>On 7-Jan-09, at 2:04 PM, Igor Korot wrote:
>
>> Hi, Kevin,
>>
>> -----Original Message-----
>>> From: Kevin Reed <theeswashbuckler AT gmail.com>
>>> Sent: Jan 7, 2009 3:23 PM
>>> To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
>>> Subject: Re: [freetds] cannot connect with tsql
>>>
>>> right then:
>>> 1: according the ODBC that does connect to the server the version is
>>> 2000.86.3959.00
>>> 2. set TDSVER to 8.0 according to this
>>> page(http://www.freetds.org/userguide/freetdsconf.htm#FREETDSCONFPURPOSE
>>> ) statement of MSQL 2000 being set to 8.0
>>>
>>> 3, 4: here is said dump file with the ip address removed for security
>>> reasons.
>>>
>>>
>>> log.c:190:Starting log file for FreeTDS 0.82
>>> on 2009-01-07 12:16:42 with debug flags 0x4fff.
>>> iconv.c:197:names for ISO-8859-1: ISO-8859-1
>>> iconv.c:197:names for UTF-8: UTF-8
>>> iconv.c:197:names for UCS-2LE: UCS-2LE
>>> iconv.c:197:names for UCS-2BE: UCS-2BE
>>> iconv.c:363:iconv to convert client-side data to the "UTF-8"
>>> character
>>> set
>>> iconv.c:516:tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
>>> iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
>>> net.c:210:Connecting to [ip address removed] port 5000 (TDS version
>>> 8.0)
>> ^^^^^^^^
>> What is this? Are you sure you server listens on port 5000?
>>
>>>
>>>
>>> again thanks for the assistance.
>>> -kevin
>>
>> Thank you.
>>
>>>
>>> On 7-Jan-09, at 10:38 AM, James K. Lowden wrote:
>>>
>>>> Kevin Reed wrote:
>>>>>
>>>>> which leads me to ask the question are there version of SQL server
>>>>> that freetds cannot connect to?.
>>>>
>>>> No. I don't get to make many categorical declarations, and I thank
>>>> you
>>>> for the opportunity! ;-)
>>>>
>>>>> i set the TDSVER as in the example shown, and tried all the values
>>>>> listed in the help pages(4.2, 5.0, 7.0, 8.0)
>>>>> all of which created the same response.
>>>>
>>>> 1. State the version of your server.
>>>> 2. Set TDSVER to the version you think is correct for your server.
>>>> 3. export TDSDUMP=tdsdump.log
>>>> 4. Run tsql.
>>>>
>>>> Post tdsdump.log here and let's see what's what.
>>>>
>>>> HTH.
>>>>
>>>> --jkl
>>>> _______________________________________________
>>>> 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
>>
>> _______________________________________________
>> 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