freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: Tony Esposito <Tony.Esposito AT region10.org>
To: "nick AT unixodbc.org" <nick AT unixodbc.org>, "freetds AT lists.ibiblio.org" <freetds AT lists.ibiblio.org>
Cc: Tony Esposito <Tony.Esposito AT region10.org>
Subject: Re: [freetds] osql and isql -- how to test ODBC config?
Date: Thu, 13 Sep 2012 17:19:14 +0000

I should have included these files earlier, my apologies:

==========================
freetds.conf
==========================

[DB246111]
host = 207.235.236.120
port = 2638
tds version = 5.0
dump file = /usr/freetdsdump.log
client charset = UTF-8

==========================
odbc.ini
==========================

[ODBC Data Sources]
txeis = Sybase TXEIS Database

[txeis]
Driver=FreeTDS
Description=Sybase TXEIS Database
Servername=DB246111
Port=2638
TDS_Version=5.0
Trace=No

[Default]
Driver=/usr/local/freetds/lib/libtdsodbc.so

==========================
odbcinst.ini
==========================

[FreeTDS]
Description=Free TDS 5.0 for Sybase Anywhere
Driver=/usr/local/freetds/lib/libtdsodbc.so

==========================

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

Threading = 1
-----Original Message-----
From: Tony Esposito
Sent: Thursday, September 13, 2012 10:35 AM
To: 'unixodbc-support AT mailman.unixodbc.org.'
Cc: 'tony.esposito AT region10.org'; 'freetds AT lists.ibiblio.org'
Subject: RE: [freetds] osql and isql -- how to test ODBC config?

Environment (Linux client accessing Windows 'server'):

CentOS 5.6 Linux 64-bit
FreeTDS 0.91
unixODBC 2.3.1
|
|
|
V
Windows XP Professional SP3 32-bit
Sybase SQL Anywhere 10

Just some extra info that may be of help. Also, cannot execute any stored
procedures -- get same error as when trying to execute SELECTs i.e.
SQLRowCount returns -1

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

-----Original Message-----
From: Tony Esposito
Sent: Thursday, September 13, 2012 10:01 AM
To: 'unixodbc-support AT mailman.unixodbc.org.'
Cc: 'tony.esposito AT region10.org'; 'freetds AT lists.ibiblio.org'
Subject: FW: [freetds] osql and isql -- how to test ODBC config?
Importance: High

Cc: unixODBC mailing list for assistance.

FreeTDS and unixODBC installed on CentOS 5.6. FreeTDS seems to work fine --
see below -- yet while isql connects it does not return data. Yet isql
'help' does return system table data.
Any help would be greatly appreciated!
Thanks.

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

-----Original Message-----
From: Tony Esposito
Sent: Thursday, September 13, 2012 9:35 AM
To: freetds AT lists.ibiblio.org
Cc: 'tony.esposito AT region10.org'
Subject: RE: [freetds] osql and isql -- how to test ODBC config?
Importance: High

Here's what I found out:

(1) tsql connects and returns data fine.
(2) fisql connects and returns data fine.

So it appears the FreeTDS client is setup correctly but...

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):

+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> help rsccc.sr_stu_demo
+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+--------+---------------------------------------------------------------------------------------------------------------------------------+------------+------------+-------+-------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-------------+
| TABLE_QUALIFIER
| TABLE_OWNER

| TABLE_NAME

| COLUMN_NAME
| TYPE_ID| TYPE_NAME

| PRECISION | LENGTH | SCALE | RADIX
| NULLABLE| REMARKS

| SS_DOMAIN_ID| COLUMN_ID |
+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+--------+---------------------------------------------------------------------------------------------------------------------------------+------------+------------+-------+-------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-------------+
+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+--------+---------------------------------------------------------------------------------------------------------------------------------+------------+------------+-------+-------+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Please advise.

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K. Lowden
Sent: Thursday, September 13, 2012 1:44 AM
To: freetds AT lists.ibiblio.org
Subject: Re: [freetds] osql and isql -- how to test ODBC config?

On Tue, 11 Sep 2012 22:18:39 +0000
Tony Esposito <Tony.Esposito AT region10.org> wrote:

> osql: warning: no DNS hostname found for "207.235.236.120"
...
> The osql tool stops because of this 'warning' so I never get connected
> and therefore never verify my ODBC setup.

The script shouldn't stop there because of that. Check the version you're
using; revision 1.12 doesn't exit after producing that message on line 342.
In fact, the only check remaining after that is that the hostname has an
address. If so, it prints what it found out and starts isql.

Perhaps something in your environment causes the shell to terminate the
script when host(1) returns nonzero status? I'd be interested it hear what
you find out.

--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
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/5266 - Release Date: 09/13/12

Re: [freetds] osql and isql -- how to test ODBC config? , (continued)