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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.