SQL Server 2005 Connection Problem

Mat W <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
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. - [email protected]
_________________________________________________________________
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.