FreeTDS Development Group

["dirtydozen AT libero.it" <dirtydozen AT libero.it>]

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.