FreeTDS Development Group

[Zhongming cai <caizjh AT yahoo.co.uk>]

Hi,

I need some help on how to implemente the blk_textfer in freetds ctlib.  I 
have a proprietary library which is built on top of the ctlib and uses 
blk_textxfer function.  Can someone point me some directions on how I should 
accomplish this?

Thanks,

David Cai
>From bernard AT tnauk.org.uk  Thu Jan 19 11:38:03 2012
Return-Path: <bernard AT tnauk.org.uk>
X-Original-To: freetds AT lists.ibiblio.org
Delivered-To: freetds AT lists.ibiblio.org
Received: by lists.ibiblio.org (Postfix, from userid 20217)
        id 6300DE8C07; Thu, 19 Jan 2012 11:38:03 -0500 (EST)
X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on 
mailman1.ibiblio.org
X-Spam-Level:
X-Spam-Status: No, score=-1.9 required=5.0 testsºYES_00 autolearn=ham
        version=3.3.1
X-Greylist: delayed 1458 seconds by postgrey-1.33 at mailman1.ibiblio.org;
        Thu, 19 Jan 2012 11:38:02 EST
Received: from tnaukmailserver.tnauk.org.uk (mailgate.tnauk.org.uk
        [80.176.241.106])
        by lists.ibiblio.org (Postfix) with ESMTP id B4A2EE8BE9
        for <freetds AT lists.ibiblio.org>; Thu, 19 Jan 2012 11:38:02 -0500 (EST)
Received: from localhost (unknown [127.0.0.1])
        by tnaukmailserver.tnauk.org.uk (Postfix) with ESMTP id DFC38BA85C0
        for <freetds AT lists.ibiblio.org>; Thu, 19 Jan 2012 16:13:43 +0000 (UTC)
X-Virus-Scanned: amavisd-new at tnauk.org.uk
Received: from tnaukmailserver.tnauk.org.uk ([127.0.0.1])
        by localhost (tnaukmailserver.tnauk.org.uk [127.0.0.1]) (amavisd-new,
        port 10024)
        with ESMTP id eZbrP2DrGTdg for <freetds AT lists.ibiblio.org>;
        Thu, 19 Jan 2012 16:13:43 +0000 (GMT)
Received: from [192.168.1.49] (it-23.tnauknrc.tnauk.org.uk [192.168.1.49])
        by tnaukmailserver.tnauk.org.uk (Postfix) with ESMTP id 08EEDBA85B7
        for <freetds AT lists.ibiblio.org>; Thu, 19 Jan 2012 16:13:42 +0000 (GMT)
Message-ID: <4F184136.4040109 AT tnauk.org.uk>
Date: Thu, 19 Jan 2012 16:13:42 +0000
From: Bernard Moreton <bernard AT tnauk.org.uk>
Organization: TNAUK
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:8.0) Gecko/20111105 
Thunderbird/8.0
MIME-Version: 1.0
To: freetds AT lists.ibiblio.org
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: [freetds] isql connects, tsql does not
X-BeenThere: freetds AT lists.ibiblio.org
X-Mailman-Version: 2.1.9
Precedence: list
Reply-To: itman AT tnauk.org.uk,
        FreeTDS Development Group <freetds AT lists.ibiblio.org>
List-Id: FreeTDS Development Group <freetds.lists.ibiblio.org>
List-Unsubscribe: <http://lists.ibiblio.org/mailman/listinfo/freetds>,
        <mailto:freetds-request AT lists.ibiblio.org?subject=unsubscribe>
List-Archive: <https://lists.ibiblio.org/sympa/arc/freetds>
List-Post: <mailto:freetds AT lists.ibiblio.org>
List-Help: <mailto:sympa AT lists.ibiblio.org?subject=HELP>
List-Subscribe: <http://lists.ibiblio.org/mailman/listinfo/freetds>,
        <mailto:freetds-request AT lists.ibiblio.org?subject=subscribe>
X-List-Received-Date: Thu, 19 Jan 2012 16:38:03 -0000

I know the problem is usually the other way round, but -

1
mbm@devbox:~$ tsql -S tnauk-sql -U TNAUKNRC\\Bernard -D tnauk
locale is "en_GB.UTF-8"
locale charset is "UTF-8"
Password:
Default database being set to tnauk
Msg 20002, Level 9, State -1, Server OpenClient, Line -1
Adaptive Server connection failed
There was a problem connecting to the server

- so I seem to have got connection to the database, but password refusal.


2
mbm@devbox:~$ isql -v tnauk 'TNAUKNRC\Bernard' '<PASSWORD>'
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>


3
mbm@devbox:~$ tsql -C
Compile-time settings (established with the "configure" script)
                             Version: freetds v0.82
              freetds.conf directory: /etc/freetds
      MS db-lib source compatibility: no
         Sybase binary compatibility: yes
                       Thread safety: yes
                       iconv library: yes
                         TDS version: 4.2
                               iODBC: no
                            unixodbc: yes


4
On trying to access from application Aubit4GL I get:
4glc: login.c:856: tds7_send_login: Assertion `0' failed.
/home/aubit4gl/bin/aubit: line 5516: 19401 Aborted                 4glc 
discount
s.4gl -S -o discounts
WARNING: 'aubit':Command ( 4glc discounts.4gl -S -o discounts) exited with 
code  134
Error status: 134


5
I have a working setup on an elderly DEBIAN server, where also tsql will not
work, though isql does - and where the critical Aubit4GL application also 
works.
  The only differences seem to be in the output of tsql -C, where on the 
Debian
box I get TDS version: 5.0.


6
Resetting 'TDS version' lines in freetds.conf appears to make no difference.
Setting TDSVER on the command line makes no difference to the output of tsql 
-C,
nor does exporting TDSVER.


7
unixodbc and FreeTDS are from apt-get on a Ubuntu 11.10 server.



I'd be most grateful for any help!

--

Bernard Moreton
IT Director, National Talking Newspapers and Magazines (TNAUK)
Charity registered in the UK 293656

DDI: 01 435 869 316