[freetds] unixODBC+FreeTDS isql query problems
James K. Lowden
jklowden at freetds.org
Fri Nov 30 15:04:44 EST 2007
Crompton, SY (Shirley) wrote:
> H jkl
>
> Thanks for the info. I append the freeTDS log below for info. Not sure
> if it helps, as it only contains trace for the tsql session and nothing
> is logged for the isql session.
Something isn't right with what you're doing. It's not possible to set
TDSDUMP correctly, execute a query, get a response, and not get a log
file. We already know tsql works; the question is why isql doesn't. (I
think isql itself is OK; I'm trying to help you figure our what's going on
that causes the behavior you're seeing.)
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)?
The log you sent used TDS 4.2, I believe. You want 7.0 or 8.0 with a
Microsoft server.
HTH.
--jkl
More information about the FreeTDS
mailing list