[unixODBC-support] Fw: isql: select sends a create procedure

Nick Gorham nick.gorham at easysoft.com
Mon Nov 23 12:31:12 GMT 2009


Lourdes Llorente wrote:
>
> Hello,
>
> I need some help with isql.
>
> We are trying to connect with FreeTDS and UnixODBC, using isql, to a 
> cisco database, LMS, which is a Sybase database.
> We manage to connect  with isql
>
>
> isql -v CW2K_TDS lmsdatafeed *****
> +---------------------------------------+
> | Connected!                            |
> |                                       |
> | sql-statement                         |
> | help [tablename]                      |
> | quit                                  |
> |                                       |
> +---------------------------------------+
> SQL>
>
> The userid has only read-only access.
> We try to do a select, but we get the error :
>
>  SQL> select PRCESSOR_MEMORY from MEMORY_INVENTORY
> *[42501][unixODBC][FreeTDS][SQL Server]SQL Anywhere Error 
> -121:Permission denied: you do not have permission to use the "CREATE 
> PROCEDURE" statement*
> [ISQL]ERROR: Could not SQLExecute
>
> Our question is why isql sends a "create procedure" instead of just a 
> "select" ?
> The odbc.ini looks like this:

Hi,

It doesn't, thats the freeTDS driver thats doing that. I suspect 
preparing a statement by creating a stored procedure.

-- 
Nick Gorham


More information about the unixODBC-support mailing list