freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] (no subject)

From: Frediano Ziglio <freddyz77 AT tin.it>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] (no subject)
Date: Mon, 28 Jul 2003 19:54:04 -0000

Il lun, 2003-07-28 alle 19:59, dirtydozen AT libero.it 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

[freetds] (no subject), dirtydozen AT libero.it, 07/28/2003
- Re: [freetds] (no subject), Frediano Ziglio, 07/28/2003
- <Possible follow-up(s)>
- RE: [freetds] (no subject), Lowden, James K, 07/28/2003
  - [freetds] Connecting TO MSSQL server, Gaurav Nangia, 07/28/2003