How to make iSQL/FreeTDS behave like a normal client?
4
votes
1
answer
1447
views
I have a third-party Sybase database, which my users would like to connect to and query from a Linux box, using [iSQL](http://isql.sourceforge.net/) . I have installed [UnixODBC](http://www.unixodbc.org/) and [FreeTDS](http://www.freetds.org/) . As it is third-party database however, I am not able to perform any GRANTs. The query fails with iSQL on Linux:
[unixODBC][FreeTDS][SQL Server]ASA Error -121: Permission denied: you do not have permission to use the "CREATE PROCEDURE" statement
It appears that the actual SQL that is getting sent by iSQL is
CREATE PROCEDURE AS
. I have read the iSQL and FreeTDS manpages but there is no hint in there about how to disable this behavior.
This works OK in Python:
>>> import Sybase
>>> db = Sybase.connect('host:port', 'user', 'password', 'db')
>>> c = db.cursor()
>>> c.execute('select table_name from systable')
>>> len(c.fetchall())
570
So I believe I have installed the Sybase client libraries correctly. Before I recommend this solution instead, can I as a DBA do anything about fixing iSQL?
Asked by Gaius
(11238 rep)
Jan 11, 2011, 05:25 PM
Last activity: Aug 23, 2011, 08:06 PM
Last activity: Aug 23, 2011, 08:06 PM