Re: osql and isql -- how to test ODBC config?
Tony Esposito <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <197C3C50EA91BF4DBE52558A4007816B43504C48@SN2PRD0202MB131.namprd02.prod.outlook.com> |
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of James K. Lowden Sent: Saturday, September 15, 2012 10:23 AM To: [email protected] Subject: Re: [freetds] osql and isql -- how to test ODBC config? On Thu, 13 Sep 2012 14:35:03 +0000 Tony Esposito <[email protected]> wrote: >>(1) tsql connects and returns data fine. >> (2) fisql connects and returns data fine. >> >> So it appears the FreeTDS client is setup correctly but... >One cannot generalize from tsql to odbc because ODBC requires additional setup. "tsql servername" and "isql servername" may use different servers and even different copies of FreeTDS. >> isql connects yet returns no data when doing a SELECT (see error >> below): >> >> isql -v txeis dba sql >> +---------------------------------------+ >> | Connected! | >> | | >> | sql-statement | >> | help [tablename] | >> | quit | >> | | >> +---------------------------------------+ >> SQL> select * from rsccc.sr_stu_demo >> SQLRowCount returns -1 >> SQL> >> >>Yet isql will return system table information via the 'help' command >> (see SQL below): > >No, the reply you quoted showed column headers only, no data. > >> Please advise. > >Your freetds.conf and odbc.ini look correct to me. I think isql is swallowing an error from the server. I would try the same query using bsqldb using TDSDUMP viz: > > $ TDSDUMP=stdout bsqldb -S txeis -U dba -P sql Tried the following from the Linux shell prompt: bsqldb -S txeis -U dba -P sql And got the following error message: bsqldb: Msg 20012, Level 2 Server name not found in configuration files bsqldb: Msg 20013, Level 2 Unknown host machine name >HTH. > >--jkl > >P.S. Please don't top-post. Inline replies such as I have used here make the thread of the conversation easier for others to follow. >_______________________________________________ >FreeTDS mailing list >[email protected] >http://lists.ibiblio.org/mailman/listinfo/freetds Please advise ... I am not familiar with 'bsqldb'. Can I just run it from bash shell prompt? Thank you for your time and effort. :-) Tony Esposito ETL Developer Information Services Programming Region 10 Education Service Center 400 E Spring Valley Rd Richardson, TX 75081 (Ph) 972-348-1284 (Fax) 972-348-1285 Reveal Data Analytics