[freetds] SQL Server 2005 Connection Problem

Mat W lmw94002 at hotmail.com
Fri Jun 6 11:50:49 EDT 2008


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 at 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


More information about the FreeTDS mailing list