Skip to Content.
Sympa Menu

freetds - [freetds] Re: FreeTDS Digest, Vol 25, Issue 15

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael David <mdavid AT district125.k12.il.us>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Re: FreeTDS Digest, Vol 25, Issue 15
  • Date: Mon, 14 Feb 2005 11:48:36 -0600

Freddy,

Yes, I'm using protocol version 8. Here's my freetds config:
[SERVER]
host = xyz.district125.k12.il.us
port = 1433
tds version = 8.0

Here's the debugging output from TDSDUMP=stdout /usr/local/bin/tsql -Sserver -Uuser -Ppasswd

locale is "C"
locale charset is "US-ASCII"
util.c:261Starting log file for FreeTDS 0.64.dev.20050209
on 2005-02-14 11:45:58 with debug flags 0x4fff.
iconv.c:198names for ISO-8859-1: ISO-8859-1
iconv.c:198names for UTF-8: UTF-8
iconv.c:198names for UCS-2LE: UCS-2LE
iconv.c:198names for UCS-2BE: UCS-2BE
iconv.c:349iconv to convert client-side data to the "US-ASCII" character set
iconv.c:501tds_iconv_info_init: converting "US-ASCII"->"UCS-2LE"
iconv.c:501tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:149Connecting to 216.125.128.177 port 1433.
net.c:636Sending packet
0000 12 01 00 34 00 00 00 00-00 00 15 00 06 01 00 1b |...4.... ........|
0010 00 01 02 00 1c 00 0c 03-00 28 00 04 ff 08 00 01 |........ .(......|
0020 55 00 00 00 4d 53 53 51-4c 53 65 72 76 65 72 00 |U...MSSQ LServer.|
0030 c1 3c 00 00 - |.<..|

net.c:423Received header
0000 04 01 00 25 00 00 01 00- |...%....|

net.c:517Received packet
0000 00 00 15 00 06 01 00 1b-00 01 02 00 1c 00 01 03 |........ ........|
0010 00 1d 00 00 ff 08 00 02-fe 00 00 00 00 |........ .....|

login.c:943detected flag 0
util.c:117Changing query state from TDS_IDLE to TDS_DEAD
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
token.c:2431tds_client_msg: #20014: "Login incorrect.". Connection state is now 4.
mem.c:478tds_free_all_results()
There was a problem connecting to the server

Hope this helps. Thanks for the recommendation on the version to use in production systems. We're using FreeTDS on an internal web applications server, and it's been quite an asset to our school district.

Michael

From: Frediano Ziglio <freddyz77 AT tin.it>
Subject: Re: [freetds] Heads up: MacOSX = broken in latest -current
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>

Il giorno mer, 09-02-2005 alle 16:16 -0600, Michael David ha scritto:
Using freetds-0.63.dev.20040824 I can use sqsh and tsql to a MSSQL 2K
server running on a Win2K box. However, with
freetds-0.64.dev.20050209, I cannot connect. I get this:
<snip>
If someone can tell me how to generate additional debugging output, I'd
be happy to include that.

Michael


Simply
TDSDUMP=stdout /usr/local/bin/tsql --Sxxx -Uxxx -Pxxx
Are you using protocol version 8.0 ?
If you are using FreeTDS for production I suggest you latest 0.63 RC
version instead.
In 0.64 there has been some changes in network layer so it's possible it
fails.

freddy77



--
--Michael A. David, Technology Specialist @ A.E. Stevenson High School
--Email: mdavid AT district125.k12.il.us - Phone: 847.634.4000 x2170
--1 Stevenson Drive, Lincolnshire, IL 60069 - http://www.district125.k12.il.us

"Here's to a better day; and if not a better day, then a
better attitude. Or some attitude. I must not fall." -- aletheis





Archive powered by MHonArc 2.6.24.

Top of Page