Re: osql and isql -- how to test ODBC config?
Tony Esposito <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <197C3C50EA91BF4DBE52558A4007816B43504E2A@SN2PRD0202MB131.namprd02.prod.outlook.com> |
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of James K. Lowden Sent: Monday, September 17, 2012 3:54 PM To: [email protected] Subject: Re: [freetds] osql and isql -- how to test ODBC config? On Sun, 16 Sep 2012 20:20:09 +0000 Tony Esposito <[email protected]> wrote: >> I tried 'bsqlodbc' and it just hangs.... >It doesn't "just" hang. :-) Dimes to donuts it's waiting for the server. TDSDUMP will show the status. I like that!! :-) Dimes to donuts. Anyway, I tried a SELECT that returns 1 row, 1 column and it still fails with SQL RowCount -1. I have been told by the unixODBC group -1 from a SQLRowCount is entirely ok and it just means that the driver does not know how many rows are in the result set which is common with forward only cursors. >One possibility is that your query runs a long time, and that isql uses a shorter query timeout than bsqlodbc does. That would be consistent with you seeing an active connection in admin tools, and with being able to >retrieve metadata. >If the same query runs quickly using bsqldb, it could be an indication that connection properties are altering the behavior of the query, or that the ODBC driver is somehow altering the SQL text. >> I unfortunately get no results from 'man bsqldb' or man bsqlodbc' >> from my Linux system. >You will find the file bsqlodbc.1 in your FreeTDS build tree. By running "make install", it is copied to $PREFIX/share/man/man1. PREFIX is defined in the configure script; the default is /usr/local. >If you have run "make install" and "man bsqlodbc" fails to find the page, it's because man(1) isn't looking at the directory where it was installed. IOW your system is misconfigured! "man man" should display the man >utility's manual, which explains how & where man pages are searched. GNU man has a -w option that reports the search path, and a -l option to read uninstalled files. I did find bsqlodbc1 but not in my build tree. Should I reinstall? How does one uninstall? And why does 'tsql' work just fine? Thanks for your help. >HTH. --jkl _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2437/5273 - Release Date: 09/17/12