FreeTDS Development Group

[Mat W <lmw94002 AT hotmail.com>]

I'm sure someone must have had something similar to this.  
 
I have a FC8 box trying to connect to a MSSQL 2005.  Took awhile to get all 
the bits together and I think I'm good, but now I get some errors.  Looks 
like I'm almost there.  But I think I'm needing to tweak some settings 
somewhere to get the connection to go through.  I read something about about 
a "tokensize" registry setting but it involves rebooting my server which I'd 
rather avoid until I'm a bit more sure may fix it.
 
Here's the SQL2005 error:
Event Type: ErrorEvent Source: MSSQLSERVEREvent Category: (4)Event ID: 
17832Date:  6/6/2008Time:  11:36:11 AMUser:  N/AComputer: 
<obscured>Description:The login packet used to open the connection is 
structurally invalid; the connection has been closed. Please contact the 
vendor of the client library. [CLIENT: <obscured>]
For more information, see Help and Support Center at 
http://go.microsoft.com/fwlink/events.asp.Data:0000: a8 45 00 00 14 00 00 00  
 <obscured>0008: 09 00 00 00 42 00 45 00   <obscured>0010: 4c 00 4c 00 41 00 
47 00   <obscured>
0018: 49 00 4f 00 00 00 00 00   <obscured>0020: 00 00                     ..  
    
And on my FreeDTS log... 
 
11:36:04.707642 6106 (util.c:368):tdserror: client library returned 
TDS_INT_CANCEL(2)11:36:04.707697 6106 (util.c:389):tdserror: returning 
TDS_INT_CANCEL(2)11:36:04.707808 6106 (util.c:162):Changed query state from 
IDLE to DEAD11:36:04.707854 6106 (token.c:316):looking for login token, got  
0()11:36:04.707885 6106 (token.c:108):tds_process_default_tokens() marker is 
0()11:36:04.707908 6106 (token.c:111):leaving tds_process_default_tokens() 
connection dead11:36:04.707926 6106 (util.c:334):tdserror(0x90800a8, 
0x9080a40, 20002, 0)11:36:04.708125 6106 (util.c:368):tdserror: client 
library returned TDS_INT_CANCEL(2)11:36:04.708186 6106 (util.c:389):tdserror: 
returning TDS_INT_CANCEL(2)11:36:04.708209 6106 
(mem.c:563):tds_free_all_results()[root@ballys bin]# cat 
/tmp/freetds.log11:36:04.704752 6106 (log.c:190):Starting log file for 
FreeTDS 0.82     on 2008-06-06 11:36:04 with debug flags 
0xffff.11:36:04.705107 6106 (iconv.c:197):names for ISO-8859-1: 
ISO-8859-111:36:04.705173 6106 (iconv.c:197):names for UTF-8: 
UTF-811:36:04.705193 6106 (iconv.c:197):names for UCS-2LE: 
UCS-2LE11:36:04.705210 6106 (iconv.c:197):names for UCS-2BE: 
UCS-2BE11:36:04.705227 6106 (iconv.c:363):iconv to convert client-side data 
to the "UTF-8" character set11:36:04.705295 6106 
(iconv.c:516):tds_iconv_info_init: converting 
"UTF-8"->"UCS-2LE"11:36:04.705347 6106 (net.c:210):Connecting to 
69.147.173.220 port 1433 (TDS version 5.0)11:36:04.705783 6106 
(net.c:264):tds_open_socket: connect(2) returned "Operation now in 
progress"11:36:04.705961 6106 (net.c:303):tds_open_socket() 
succeeded11:36:04.706001 6106 (util.c:162):Changed query state from DEAD to 
IDLE11:36:04.706034 6106 (net.c:779):Sending packet0000 02 00 02 00 00 00 00 
00-62 61 6c 6c 79 73 2e 68 |........ <obscured>|0010 75 62 74 65 61 6d 2e 
63-6f 6d 00 00 00 00 00 00 |<obscured>......|0020 00 00 00 00 00 00 12 42-45 
4c 4c 41 47 49 4f 41 |.......<obscured>|0030 64 6d 69 6e 69 73 74 72-61 74 6f 
72 00 00 00 00 |dministr ator....|0040 00 00 00 00 00 15 54 72-61 63 74 6f 72 
31 32 00 |......<obscured>.|0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 
00 |........ ........|0060 00 00 00 00 09 33 37 38-37 36 00 00 00 00 00 00 
|.....378 76......|0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|0080 00 00 00 05 03 01 06 0a-09 01 00 00 00 00 00 00 
|........ ........|0090 00 00 00 00 54 53 51 4c-00 00 00 00 00 00 00 00 
|....TSQL ........|00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|00b0 00 00 04 62 65 6c 6c 61-67 69 6f 00 00 00 00 00 
|...<obscured>.....|00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|00d0 00 08 00 09 54 72 61 63-74 6f 72 31 32 00 00 00 
|....<obscured>...|00e0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|00f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|0100 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|0110 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|0180 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|0190 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|01a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|01b0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|01c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|........ ........|01d0 00 0b 05 00 00 00 54 44-53 2d 4c 69 62 72 61 72 
|......TD S-Librar|01e0 0a 05 00 00 00 00 0d 11-75 73 5f 65 6e 67 6c 69 
|........ us_engli|01f0 73 68 00 00 00 00 00 00-00 00 00 00 00 00 00 00 
|sh...... ........|
11:36:04.706354 6106 (net.c:779):Sending packet0000 02 01 00 61 00 00 00 
00-00 00 00 00 00 00 0a 00 |...a.... ........|0010 00 00 00 00 00 00 00 00-00 
00 00 00 00 69 73 6f |........ .....iso|0020 5f 31 00 00 00 00 00 00-00 00 00 
00 00 00 00 00 |_1...... ........|0030 00 00 00 00 00 00 00 00-00 00 00 05 01 
35 31 32 |........ .....512|0040 00 00 00 03 00 00 00 00-e2 16 00 01 09 00 08 
0e |........ ........|0050 6d 7f ff ff ff fe 02 09-00 00 00 00 02 68 00 00 
|m....... .....h..|0060 00                     -                        |.|
11:36:04.706489 6106 (token.c:312):tds_process_login_tokens()11:36:04.707423 
6106 (util.c:334):tdserror(0x90800a8, 0x9080a40, 20017, 115)11:36:04.707642 
6106 (util.c:368):tdserror: client library returned 
TDS_INT_CANCEL(2)11:36:04.707697 6106 (util.c:389):tdserror: returning 
TDS_INT_CANCEL(2)11:36:04.707808 6106 (util.c:162):Changed query state from 
IDLE to DEAD11:36:04.707854 6106 (token.c:316):looking for login token, got  
0()11:36:04.707885 6106 (token.c:108):tds_process_default_tokens() marker is 
0()11:36:04.707908 6106 (token.c:111):leaving tds_process_default_tokens() 
connection dead11:36:04.707926 6106 (util.c:334):tdserror(0x90800a8, 
0x9080a40, 20002, 0)11:36:04.708125 6106 (util.c:368):tdserror: client 
library returned TDS_INT_CANCEL(2)11:36:04.708186 6106 (util.c:389):tdserror: 
returning TDS_INT_CANCEL(2)11:36:04.708209 6106 
(mem.c:563):tds_free_all_results()-- Mat W. - lmw94002 AT hotmail.com
_________________________________________________________________
It’s easy to add contacts from Facebook and other social sites through 
Windows Live™ Messenger. Learn how.
https://www.invite2messenger.net/im/?source=TXT_EML_WLH_LearnHow