Skip to Content.
Sympa Menu

freetds - [freetds] osql and isql -- how to test ODBC config?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Tony Esposito <Tony.Esposito AT region10.org>
  • To: "freetds AT lists.ibiblio.org" <freetds AT lists.ibiblio.org>
  • Cc: Tony Esposito <Tony.Esposito AT region10.org>
  • Subject: [freetds] osql and isql -- how to test ODBC config?
  • Date: Tue, 11 Sep 2012 22:18:39 +0000

Using FreeTDS with unixODBC on Linux.


(1) tsql works fine.

(2) but osql gets issue below:

looking up hostname for ip address 207.235.236.120
osql: warning: no DNS hostname found for "207.235.236.120"

in other blogs I see it mentioned that this is not an 'error' to be concerned
with. And in fact it is shown as a' warning', not an 'error'.
But how does one check out the ODBC configuration? The osql tool stops
because of this 'warning' so I never get connected and therefore never verify
my ODBC setup.
And isql fails with:

[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[01000][unixODBC][FreeTDS][SQL Server]Unknown host machine name.
[ISQL]ERROR: Could not SQLConnect

Please advise.

Tony





Archive powered by MHonArc 2.6.24.

Top of Page