isql connects, tsql does not
Bernard Moreton <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Organization | TNAUK |
| Message-ID | <[email protected]> |
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