[freetds] unixODBC+FreeTDS isql query problems

Crompton, SY (Shirley) s.y.crompton at dl.ac.uk
Mon Dec 3 12:25:36 EST 2007


Hi James

Many thanks for the suggestion. 

--Maybe try something like this:

$ echo 'select * from systypes select count(*) as nrows from systypes' \
	> query.txt

$ TDSVER=7.0 TDSDUMP=stdout isql -S [...] < query.txt > query.log

and have a look at query.log.  Are there two resultsets (output from two
queries)? 

Yes, the query.log contains the 2 resultsets as expected.  (Have not
appended the log as it takes up far too much space.)  Does this means
that freeTDS is configured incorrectly?  I've directly edited the
freeTDS.conf file as root.  Do I have to install the file with a install
function?


Thanks

Shirley


More information about the FreeTDS mailing list