Skip to Content.
Sympa Menu

freetds - RE: [freetds] Problem connecting to SQL Server 8.0 and XP Professional

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: lsunley AT mb.sympatico.ca
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Problem connecting to SQL Server 8.0 and XP Professional
  • Date: Tue, 19 Oct 2004 21:58:13 -0400

AFAIK SQL Server v7 should use the 7.0 protocol. That is the one that I
have working here

Lorne

In <0EFEDF9D507FF6409CE7B4D24B20E7BF694B15 AT xchng.msc.tamu.edu>, on
10/19/04
at 06:21 PM, "Danny Raetzsch" <danny AT msc.tamu.edu> said:

>This actually sounds exactly like the problem I'm having (see: 'Login
>Incorrect with MS SQL Server' thread). Is there any reason FreeTDS
>wouldn't be working with SQL 8.0 or are we both just having the same
>configuration problem?

>Dan


>-----Original Message-----
>From: freetds-bounces AT lists.ibiblio.org
>[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
>fishtail100-freetds AT yahoo.com
>Sent: Thursday, October 14, 2004 11:26 AM
>To: freetds AT lists.ibiblio.org
>Subject: [freetds] Problem connecting to SQL Server 8.0 and XP
>Professional

>Hi,

>I'm trying to connect to SQL Server 8.0 on XP PRO from
>Linux - Redhat 8.0 using freetds 0.62.4. Both
>computers are on the same network and I can both ping
>the box with SQL Server 8.0 and telnet to SQL Server
>8.0 using the IP and port.

>I keep getting Login incorrect ... even though I'm
>sure this a correct login. Also, I 've set SQL server
>to allow SQL Server and Windows authentication. I
>don't think the request is getting to SQL Server since
>I don't see any replies in the tds log file, and I
>don't see any authentication requests in the SQL
>Server logs. But this is puzzling since I can clearly
>connect from the linux box to SQL Server ?

>Any help would be greatly appreciated ... Thanks much.
>I've included a transcript of the session and the log
>file below.

>Thanks,
>Mike

>[mhonner@localhost bin]$ export
>TDSDUMP=/tmp/freetds.log
>[mhonner@localhost bin]$ ./tsql -H 192.168.254.2 -p
>1533 -U mhonner -P XXXXX
>locale is "C"
>locale charset is "ANSI_X3.4-1968"
>Msg 20004, Level 9, State 0, Server OpenClient, Line 0
>Read from SQL server failed.
>Msg 20014, Level 9, State 0, Server OpenClient, Line 0
>Login incorrect.
>There was a problem connecting to the server


>ping 192.168.254.2
>PING 192.168.254.2 (192.168.254.2) 56(84) bytes of
>data.
>64 bytes from 192.168.254.2: icmp_seq=1 ttl=128
>time=1.28 ms
>64 bytes from 192.168.254.2: icmp_seq=2 ttl=128
>time=1.27 ms

>telnet 192.168.254.2 1533
>Trying 192.168.254.2...
>Connected to 192.168.254.2.
>Escape character is '^]'.
>Connection closed by foreign host.



>honner@localhost tmp]$ more freetds.log
>Starting log file for FreeTDS 0.62.4
> on 2004-10-14 10:28:03 with debug level 99.
>names for ISO-8859-1: ISO-8859-1
>names for UTF-8: UTF-8
>names for UCS-2LE: UCS-2LE
>names for UCS-2BE: UCS-2BE
>iconv to convert client-side data to the
>"ANSI_X3.4-1968" character set
>10:28:03.228574 tds_iconv_info_init: converting
>"US-ASCII"->"UCS-2LE"
>10:28:03.228675 Connecting to 192.168.254.2 port 1533,
>TDS 4.2.
>Sending packet @ 10:28:03.229925
>0000 02 00 02 00 00 00 00 00-6c 6f 63 61 6c 68 6f 73
>|........ localhos|
>0010 74 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
>|t....... ........|
>0020 00 00 00 00 00 00 09 6d-68 6f 6e 6e 65 72 00 00
>|.......m honner..|
>0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
>|........ ........|
>0040 00 00 00 00 00 07 7a 69-6d 62 61 31 00 00 00 00
>|......XX XXX....|
>0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
>|........ ........|
>0060 00 00 00 00 06 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 32 35 34 2e 32
>|...192.1 68.254.2|
>00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
>|........ ........|
>00d0 00 0d 7a 69 6d 62 61 31-00 00 00 00 00 00 00 00
>|..XXXXX........|
>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 06 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 @ 10:28:03.230661
>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 69 73 6f
>|........ .....iso|
>0020 36 34 36 00 00 00 00 00-00 00 00 00 00 00 00 00
>|646..... ........|
>0030 00 00 00 00 00 00 00 00-00 00 00 06 01 35 31 32
>|........ .....512|
>0040 00 00 00 03 00 00 00 00-00 00 00 00
>|........ ....|


>10:28:03.230800 tds_process_login_tokens()
>10:29:09.774652 tds_client_msg: #20004: "Read from SQL
>server failed.". Connect
>ion state is now 0.
>10:29:09.774798 looking for login token, got 0()
>10:29:09.774834 tds_process_default_tokens() marker is
>0()
>10:29:09.774863 leaving tds_process_default_tokens()
>connection dead
>10:29:09.774909 tds_client_msg: #20014: "Login
>incorrect.". Connection state is
> now 4.


>=====
>Honner Consulting, LLC
>818 Forestdale Road
>Royal Oak, MI 48067
>248-506-1020
>mike AT honner.com
>_______________________________________________
>FreeTDS mailing list
>FreeTDS AT lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>_______________________________________________
>FreeTDS mailing list
>FreeTDS AT lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds

--
-----------------------------------------------------------
lsunley AT mb.sympatico.ca
-----------------------------------------------------------





Archive powered by MHonArc 2.6.24.

Top of Page