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: Kevin Reed <theeswashbuckler AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] cannot connect with tsql
  • Date: Wed, 7 Jan 2009 12:23:11 -0800

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)
net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:303:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
login.c:735:quietly sending TDS 7+ login packet
token.c:312:tds_process_login_tokens()
util.c:334:tdserror(0x100270, 0x100710, 20017, 0)
util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:389:tdserror: returning TDS_INT_CANCEL(2)
util.c:162:Changed query state from IDLE to DEAD
token.c:316:looking for login token, got 0()
token.c:108:tds_process_default_tokens() marker is 0()
token.c:111:leaving tds_process_default_tokens() connection dead
util.c:334:tdserror(0x100270, 0x100710, 20002, 0)
util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:389:tdserror: returning TDS_INT_CANCEL(2)
mem.c:563:tds_free_all_results()


again thanks for the assistance.
-kevin

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





Archive powered by MHonArc 2.6.24.

Top of Page