Skip to Content.
Sympa Menu

freetds - [freetds] SQL Server 2005 Connection Problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Mat W <lmw94002 AT hotmail.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] SQL Server 2005 Connection Problem
  • Date: Fri, 6 Jun 2008 11:50:49 -0400


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



Archive powered by MHonArc 2.6.24.

Top of Page