Skip to Content.
Sympa Menu

freetds - [freetds] (no subject)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "dirtydozen AT libero.it" <dirtydozen AT libero.it>
  • To: "freetds" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] (no subject)
  • Date: Mon, 28 Jul 2003 19:59:26 +0200

Hi guys!

I have a problem connecting to a MSSQL 2000 server

this is the version:

Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3)


I tried to connect with

# tsql -S 192.168.0.253 -U <username>

and it seems to work fine, it responds as follow:

locale is "it_IT"
charset is "ISO-8859-15"
1>exit

#

i also tried to give some sql command and they work...

ok that's ok.. So i tried to connect with

isql -v TDS <username> <password> and it doesn't work:

[unixODBC]Il contesto di database è stato sostituito con 'dipendenti'.
[unixODBC]Login incorrect.
[unixODBC]Client unable to establish connection

i'm sure the login is correct, may be i have to configure the server in some
way?
I don't know how to resolve this problem wath could it be?

Here's the freeTDS log:

Starting log file with debug level 99.
2003-07-28 19:02:15.211343 iconv will convert client-side data to the ""
character set
2003-07-28 19:02:15.217092 Connecting addr 192.168.0.2 port 1433 with TDS
version 4.2
Sending packet @ 2003-07-28 19:02:15.218434
0000 02 00 02 00 00 00 00 00 57 65 62 62 79 00 00 00 |........ Webby...|
0010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0020 00 00 00 00 00 00 05 6c 61 62 6f 72 61 74 6f 72 |.......l aborator|
0030 69 6f 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |io...... ........|
0040 00 00 00 00 00 0b 76 65 6e 65 74 61 31 30 38 36 |......ve neta1086|
0050 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0060 00 00 00 00 0a 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 02 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 31 39 32 2e 31 36 38 2e 30 2e 32 00 00 |...192.1 68.0.2..|
00c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
00d0 00 0b 76 65 6e 65 74 61 31 30 38 36 00 00 00 00 |..veneta 1086....|
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 0a 04 02 00 00 54 44 53 2d 4c 69 62 72 61 72 |......TD S-Librar|
01e0 0a 00 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...... ........|


Sending packet @ 2003-07-28 19:02:15.219088
0000 02 01 00 4c 00 00 00 00 00 00 00 00 00 00 0a 00 |...L.... ........|
0010 00 00 00 00 00 00 00 00 00 00 00 00 00 49 53 4f |........ .....ISO|
0020 2d 38 38 35 39 2d 31 35 00 00 00 00 00 00 00 00 |-8859-15 ........|
0030 00 00 00 00 00 00 00 00 00 00 00 0b 01 35 31 32 |........ .....512|
0040 00 00 00 03 00 00 00 00 00 00 00 00 |........ ....|


2003-07-28 19:02:15.219207 inside tds_process_login_tokens()
Received header @ 2003-07-28 19:02:15.354632
0000 04 01 00 c5 00 37 01 00 |...Å.7..|


Received packet @ 2003-07-28 19:02:15.354780
0000 e3 1c 00 01 13 56 65 72 62 61 6c 69 41 63 63 65 |ã....Ver baliAcce|
0010 74 74 61 7a 69 6f 6e 65 06 6d 61 73 74 65 72 ab |ttazione .master«|
0020 56 00 45 16 00 00 02 00 45 00 49 6c 20 63 6f 6e |V.E..... E.Il con|
0030 74 65 73 74 6f 20 64 69 20 64 61 74 61 62 61 73 |testo di databas|
0040 65 20 e8 20 73 74 61 74 6f 20 73 6f 73 74 69 74 |e è stat o sostit|
0050 75 69 74 6f 20 63 6f 6e 20 27 56 65 72 62 61 6c |uito con 'Verbal|
0060 69 41 63 63 65 74 74 61 7a 69 6f 6e 65 27 2e 05 |iAccetta zione'..|
0070 44 41 44 44 59 00 00 00 e3 09 00 03 05 69 73 6f |DADDY... ã....iso|
0080 5f 31 01 00 ad 20 00 01 04 02 00 00 16 4d 69 63 |_1..­ .. .....Mic|
0090 72 6f 73 6f 66 74 20 53 51 4c 20 53 65 72 76 65 |rosoft S QL Serve|
00a0 72 00 00 5f 08 00 c2 e3 0a 00 04 03 35 31 32 04 |r.._..Âã ....512.|
00b0 34 30 39 36 fd 00 00 00 00 00 00 00 00 |4096ý... .....|


2003-07-28 19:02:15.355035 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-07-28 19:02:15.355098 inside tds_process_default_tokens() marker is
ab(INFO)
2003-07-28 19:02:15.355138 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-07-28 19:02:15.355175 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-07-28 19:02:15.355204 inside tds_process_default_tokens() marker is
fd(DONE)
2003-07-28 19:02:15.355232 inside tds_process_end() more_results = 0,
was_cancelled = 0
2003-07-28 19:02:15.355259 inside tds_process_default_tokens() setting state
to COMPLETED
Sending packet @ 2003-07-28 19:02:15.355313
0000 01 01 00 15 00 00 00 00 73 65 6c 65 63 74 20 40 |........ select @|
0010 40 73 70 69 64 |@spid|


Received header @ 2003-07-28 19:02:15.359141
0000 04 01 00 20 00 37 01 00 |... .7..|


Received packet @ 2003-07-28 19:02:15.359188
0000 a0 01 00 00 a1 05 00 06 00 00 00 34 d1 37 00 fd | ...¡... ...4Ñ7.ý|
0010 10 00 c1 00 01 00 00 00 |..Á.....|


2003-07-28 19:02:15.359234 processing result tokens. marker is a0(COLNAME)
2003-07-28 19:02:15.359272 processing result tokens. marker is a1(COLFMT)
2003-07-28 19:02:15.359309 processing result. type = 52(smallint),
varint_size 0
2003-07-28 19:02:15.359342 processing row tokens. marker is d1(ROW)
2003-07-28 19:02:15.359367 processing row. column is 0 varint size = 0
2003-07-28 19:02:15.359391 processing row. column size is 2
2003-07-28 19:02:15.359418 clearing column 0 NULL bit
2003-07-28 19:02:15.359443 processing row tokens. marker is fd(DONE)
2003-07-28 19:02:15.359466 inside tds_process_end() more_results = 0,
was_cancelled = 0
2003-07-28 19:02:15.359492 inside tds_process_result_tokens() state is
COMPLETED
2003-07-28 19:02:15.359515 leaving tds_process_login_tokens() returning 1
Sending packet @ 2003-07-28 19:02:15.359557
0000 01 01 00 1b 00 00 00 00 73 65 74 20 74 65 78 74 |........ set text|
0010 73 69 7a 65 20 36 34 35 31 32 20 |size 645 12 |


Received header @ 2003-07-28 19:02:15.360075
0000 04 01 00 11 00 37 01 00 |.....7..|


Received packet @ 2003-07-28 19:02:15.360121
0000 fd 00 00 be 00 00 00 00 00 |ý..¾.... .|


2003-07-28 19:02:15.360153 processing result tokens. marker is fd(DONE)
2003-07-28 19:02:15.360177 inside tds_process_end() more_results = 0,
was_cancelled = 0
2003-07-28 19:02:15.360203 inside tds_process_result_tokens() state is
COMPLETED


--------------------------------------------------------------------------------------------

I can't understand the problem, i hope in your fast answer!

Thanx a lot

Alex.






Archive powered by MHonArc 2.6.24.

Top of Page