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: FreeTDS Development Group <freetds AT lists.ibiblio.org>, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] cannot connect with tsql
  • Date: Wed, 7 Jan 2009 17:04:06 -0500 (EST)

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





Archive powered by MHonArc 2.6.24.

Top of Page