Skip to Content.
Sympa Menu

freetds - [freetds] blk_textxfer

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Zhongming cai <caizjh AT yahoo.co.uk>
  • To: "FreeTDS AT lists.ibiblio.org" <FreeTDS AT lists.ibiblio.org>
  • Subject: [freetds] blk_textxfer
  • Date: Thu, 19 Jan 2012 09:50:16 +0000 (GMT)

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




Archive powered by MHonArc 2.6.24.

Top of Page