[freetds] fisql or ssqldb or sqsh.....
keehan_mallon at yahoo.com
Mon May 18 14:34:07 EDT 2009
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.
More information about the FreeTDS