Re: (no subject)

Il lun, 2003-07-28 alle 19:59, dirtydozen@xxxxxxxxx ha scritto:
> Hi guys!
> 

Ciao Alex!
Benvenuto tra gli utilizzatori di FreeTDS (NDT: Welcome in FreeTDS user
group).

> 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

Mmm... it's not good to use TDS 4.2 with mssql2k. Try using TDS7 or
TDS8.

> 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'll try by myself... it's very strange...

freddy77