[unixODBC-support] tsql is working isql is not, tried everything I can think of, been working on this for a couple of days.

Thu Jul 9 23:04:17 BST 2009

I am running unixODBC 2.2.12.  Free tds 0.64  ( have tried with freetds .082 and unixODBC 2.2.14 with same results).  I also had easysoft driver initially installed but removed it.

tsql works IF I don't supply a password in the initial command string.

 tsql -H dcsv166 -p 1433 -U Radius
locale is "en_US.UTF-8"
locale charset is "UTF-8"
Password:
1>

IF I supply the password it fails, not sure why...I have triple checked the username and password and from above it obviously works.

tsql -H dcsv166 -p 1433 -U Radius -P Password
locale is "en_US.UTF-8"
locale charset is "UTF-8"
Msg 18456, Level 14, State 1, Server DCSV166, Line 1
Login failed for user 'Radius'.
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server

isql doesn't work at all...

isql RADIUS_CDR Radius Password -v
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[37000][unixODBC][FreeTDS][SQL Server]Login failed for user 'Radius'.
[28000][unixODBC][FreeTDS][SQL Server]Login incorrect.
[ISQL]ERROR: Could not SQLConnect

Here is the freetds.log file from the isql attempt:

cat /tmp/freetds.log
17:54:26.385119 2005 (util.c:288):Starting log file for FreeTDS 0.64
        on 2009-07-09 17:54:26 with debug flags 0xffff.
17:54:26.385370 2005 (iconv.c:195):names for ISO-8859-1: ISO-8859-1
17:54:26.385394 2005 (iconv.c:195):names for UTF-8: UTF-8
17:54:26.385412 2005 (iconv.c:195):names for UCS-2LE: UCS-2LE
17:54:26.385430 2005 (iconv.c:195):names for UCS-2BE: UCS-2BE
17:54:26.385448 2005 (iconv.c:361):iconv to convert client-side data to the "UTF-8" character set
17:54:26.385487 2005 (iconv.c:514):tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
17:54:26.385536 2005 (iconv.c:514):tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
17:54:26.385563 2005 (net.c:168):Connecting to 10.99.3.27 port 1433.
17:54:26.385832 2005 (write.c:134):tds_put_string converting 24 bytes of "dcsv507.accentonline.com"
17:54:26.385877 2005 (write.c:162):tds_put_string wrote 48 bytes
17:54:26.385904 2005 (write.c:134):tds_put_string converting 6 bytes of "Radius"
17:54:26.385925 2005 (write.c:162):tds_put_string wrote 12 bytes
17:54:26.385944 2005 (write.c:134):tds_put_string converting 4 bytes of "TSQL"
17:54:26.385964 2005 (write.c:162):tds_put_string wrote 8 bytes
17:54:26.385983 2005 (write.c:134):tds_put_string converting 7 bytes of "dcsv166"
17:54:26.386003 2005 (write.c:162):tds_put_string wrote 14 bytes
17:54:26.386021 2005 (write.c:134):tds_put_string converting 11 bytes of "TDS-Library"
17:54:26.386041 2005 (write.c:162):tds_put_string wrote 22 bytes
17:54:26.386058 2005 (write.c:134):tds_put_string converting 10 bytes of "us_english"
17:54:26.386078 2005 (write.c:162):tds_put_string wrote 20 bytes
17:54:26.386096 2005 (write.c:162):tds_put_string wrote 0 bytes
17:54:26.386138 2005 (token.c:310):tds_process_login_tokens()
17:54:26.388415 2005 (net.c:446):Received header
0000 04 01 00 6c 00 4e 01 00-                        |...l.N..|
17:54:26.388456 2005 (net.c:542):Received packet
0000 aa 58 00 18 48 00 00 01-0e 1f 00 4c 00 6f 00 67 |.X..H... ...L.o.g|
0010 00 69 00 6e 00 20 00 66-00 61 00 69 00 6c 00 65 |.i.n. .f .a.i.l.e|
0020 00 64 00 20 00 66 00 6f-00 72 00 20 00 75 00 73 |.d. .f.o .r. .u.s|
0030 00 65 00 72 00 20 00 27-00 52 00 61 00 64 00 69 |.e.r. .' .R.a.d.i|
0040 00 75 00 73 00 27 00 2e-00 07 44 00 43 00 53 00 |.u.s.'.. ..D.C.S.|
0050 56 00 31 00 36 00 36 00-00 01 00 fd 02 00 00 00 |V.1.6.6. ........|
0060 00 00 00 00            -                        |....|
17:54:26.388547 2005 (token.c:314):looking for login token, got  aa(ERROR)
17:54:26.388570 2005 (token.c:105):tds_process_default_tokens() marker is aa(ERROR)
17:54:26.388607 2005 (token.c:2439):tds_process_msg() reading message from server
17:54:26.388627 2005 (read.c:179):tds_get_string: reading 62 from wire to give 31 to client.
17:54:26.388655 2005 (read.c:179):tds_get_string: reading 14 from wire to give 7 to client.
17:54:26.388680 2005 (token.c:2501):tds_process_msg() calling client msg handler
17:54:26.388779 2005 (token.c:2514):tds_process_msg() returning TDS_SUCCEED
17:54:26.388800 2005 (token.c:314):looking for login token, got  fd(DONE)
17:54:26.388818 2005 (token.c:105):tds_process_default_tokens() marker is fd(DONE)
17:54:26.388837 2005 (token.c:2143):tds_process_end: more_results = 0
                was_cancelled = 0
                error = 1
                done_count_valid = 0
17:54:26.388860 2005 (token.c:2159):tds_process_end() state set to TDS_IDLE
17:54:26.388878 2005 (util.c:119):Changing query state from IDLE to IDLE
17:54:26.388897 2005 (token.c:387):leaving tds_process_login_tokens() returning 0
17:54:26.388931 2005 (util.c:119):Changing query state from IDLE to DEAD
17:54:26.389013 2005 (token.c:2252):tds_client_msg: #20014: "Login incorrect.".  Connection state is now 4.
17:54:26.389035 2005 (mem.c:519):tds_free_all_results()

Here is my odbc.ini file..

[RADIUS_CDR]
Driver          = FreeTDS
Description             = Radius_CDR
Server          = 10.99.3.27
Port            = 1433
Database                = Radius_CDR
TDS_Version             = 7.0

Here is my odbcinst.ini file

[FreeTDS]
Description             = v0.64 with protocol v7.0
Driver          = /usr/local/lib/libtdsodbc.so
Setup           = /usr/local/lib/lidtdsS.so
UsageCount              = 3

[ODBC]
Trace                   = Yes
TraceFile               = sql.log
ForceTrace              = Yes

I have tried using version 8.0 of tds also.  At this point I'm at a loss and do not know where to turn.  

Any thoughts, suggestions etc.  Thanks very much, I'm pretty linux green but can usually follow the directions and get what I need done, but right now I'm severely stumped.  

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20090709/df642978/attachment.html>