Skip to Content.
Sympa Menu

freetds - [freetds] fisql or ssqldb or sqsh.....

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Keehan Mallon <keehan_mallon AT yahoo.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] fisql or ssqldb or sqsh.....
  • Date: Mon, 18 May 2009 11:34:07 -0700 (PDT)

I have setup and configured FreeTDS and unixODBC. I can connect to Oracle
and SQL Server using native tools and ODBC. What I am needing is a native
tool to connect to SQL Server from shell scripts and run SQL jobs. In
particular, I need to be able to issue something like:

fisql -S $tdsname -U $user -P $password -Q $SQL

The code that I am working on used a structure similar to that, but it was a
Windows utility (running from Microsoft's Services for UNIX.

With the existing fisql and/or bsqldb, I could echo $SQL > file and then use
fisql to run the file, but I'd rather not have to write the file to disk
every time I try to run a query. Can either of these tools take the $SQL
inline?

My other option is sqsh. It seems to be able to take the SQL argument
inline. However, I have been unable to get it to configure. I have FreeTDS
installed via rpm, so the FreeTDS libs are in /usr/lib64, executables in
/usr/bin and the includes in /usr/include. I have not been able to set the
SYBASE variable to any path that configure was able to use to find the sybase
libs. Anybody have any idea if what I am trying should work? Where should I
be pointing SYBASE in this instance?

I'd rather not have to compile FreeTDS from source as I would have to go back
and do the same for unixODBC as well then.

Thanks,

Keehan








Archive powered by MHonArc 2.6.24.

Top of Page