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

Mon Nov 23 12:22:02 GMT 2009

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:

[ODBC Data Sources]
CW2K_TDS        = LMS 

[CW2K_TDS]
Driver          = /usr/local/lib/libtdsodbc.so
Description             = Connection to CW2K
Server          = xxxxx
Port            = 43455
Database                = rmengdb
TDS_VERSION     = 5.0

We have set up a trace and isql sends a create procedure..( I don't post 
the whole trace just the important packages)

No.     Time        Source                Destination           Protocol 
Info
     49 17.560123   XXXX     YYYY    TDS      TDS5 Query Packet

0000  00 03 ba f0 53 e5 00 11 0a 9c 23 79 08 00 45 00   ....S.....#y..E.
0010  00 95 34 2d 40 00 40 06 2e 3d c2 9c a9 47 c2 9c   ..4- at .@..=...G..
0020  a9 78 bb 5a a9 bf 69 2d b8 e9 b2 31 b3 c6 80 18   .x.Z..i-...1....
0030  00 5c d8 80 00 00 01 01 08 0a 44 2b 8c 41 26 af   .\........D+.A&.
0040  18 7c 0f 01 00 61 00 00 00 00 e7 56 00 01 00 0a   .|...a.....V....
0050  69 6b 38 30 33 33 36 30 30 30 47 00 63 72 65 61   ik80336000G.crea
0060  74 65 20 70 72 6f 63 20 69 6b 38 30 33 33 36 30   te proc ik803360
0070  30 30 20 61 73 20 73 65 6c 65 63 74 20 50 52 43   00 as select PRC
0080  45 53 53 4f 52 5f 4d 45 4d 4f 52 59 20 66 72 6f   ESSOR_MEMORY fro
0090  6d 20 4d 45 4d 4f 52 59 5f 49 4e 56 45 4e 54 4f   m MEMORY_INVENTO
00a0  52 59 20                                          RY 

No.     Time        Source                Destination           Protocol 
Info
     54 17.565034   YYYY       XXXX       TDS      Response Packet
00 11 0a 9c 23 79 00 03 ba f0 53 e5 08 00 45 00   ....#y....S...E.
0010  00 db ee 3c 40 00 40 06 73 e7 c2 9c a9 78 c2 9c   ...<@. at .s....x..
0020  a9 47 a9 bf bb 5a b2 31 b3 e7 69 2d b9 64 80 18   .G...Z.1..i-.d..
0030  c0 50 b2 15 00 00 01 01 08 0a 26 af 1c 50 44 2b   .P........&..PD+
0040  8c 41 04 01 00 a7 00 00 00 00 e7 0d 00 20 00 0a   .A........... ..
0050  69 6b 38 30 33 33 36 30 30 30 e5 83 00 06 01 00   ik80336000......
0060  00 00 10 05 34 32 35 30 31 00 01 00 6e 00 53 51   ....42501...n.SQ
0070  4c 20 41 6e 79 77 68 65 72 65 20 45 72 72 6f 72   L Anywhere Error
0080  20 2d 31 32 31 3a 20 50 65 72 6d 69 73 73 69 6f    -121: Permissio
0090  6e 20 64 65 6e 69 65 64 3a 20 79 6f 75 20 64 6f   n denied: you do
00a0  20 6e 6f 74 20 68 61 76 65 20 70 65 72 6d 69 73    not have permis
00b0  73 69 6f 6e 20 74 6f 20 75 73 65 20 74 68 65 20   sion to use the 
00c0  22 43 52 45 41 54 45 20 50 52 4f 43 45 44 55 52   "CREATE PROCEDUR
00d0  45 22 20 73 74 61 74 65 6d 65 6e 74 00 00 00 00   E" statement....
00e0  fd 02 00 01 00 00 00 00 00                        .........

Is there a setting in odbc.ini that we are bypassing ? Could you help us 
with this issue ?

Thanks

IMPORTANT  -  CONFIDENTIALITY  NOTICE  - This e-mail is intended only for 
the use of the individual or entity shown above as addressees. It may 
contain information which is privileged, confidential or otherwise 
protected from disclosure under applicable laws.  If the reader of this 
transmission is not the intended recipient, you are hereby notified that 
any dissemination, printing, distribution, copying, disclosure or the 
taking of any action in reliance on the contents of this information is 
strictly prohibited.  If you have received this transmission in error, 
please immediately notify us by reply e-mail or using the address below 
and delete the message and any attachments from your system. 

Amadeus Data Processing GmbH 
Geschäftsführer: Eberhard Haag 
Sitz der Gesellschaft: Erding 
HR München 48 199 
Berghamer Strasse 6 
85435 Erding 
Germany

IMPORTANT  -  CONFIDENTIALITY  NOTICE  - This e-mail is intended only for 
the use of the individual or entity shown above as addressees. It may 
contain information which is privileged, confidential or otherwise 
protected from disclosure under applicable laws.  If the reader of this 
transmission is not the intended recipient, you are hereby notified that 
any dissemination, printing, distribution, copying, disclosure or the 
taking of any action in reliance on the contents of this information is 
strictly prohibited.  If you have received this transmission in error, 
please immediately notify us by reply e-mail or using the address below 
and delete the message and any attachments from your system. 

Amadeus Data Processing GmbH 
Geschäftsführer: Eberhard Haag 
Sitz der Gesellschaft: Erding 
HR München 48 199 
Berghamer Strasse 6 
85435 Erding 
Germany
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20091123/4e314808/attachment.html>