[asterisk-dev] ODBC error

[Tilghman Lesher]

On Thursday 14 July 2011 17:28:58 riscphree wrote:
> I'm having a problem getting asterisk to execute odbc commands.
> Asterisk is successfully using odbc to store CDR just fine.
> 
> acallpbx*CLI> odbc show all
> 
> ODBC DSN Settings
> -----------------
> 
>  Name:   acall-cdr-db
>  DSN:    *edited*
>    Last connection attempt: 1969-12-31 19:00:00
>  Pooled: No
>  Connected: Yes
> 
> 
> acallpbx*CLI> odbc read
> GET_CLIENTLIST    GET_PRECEDENCE    GET_SUB_STATUS    ODBC_CLIENTCOUNT
> 
> acallpbx*CLI> odbc read GET_PRECEDENCE testcorp
> SELECT event_precedence from user_profile where company = 'testcorp'
> limit 1
> 
> acallpbx*CLI> odbc read GET_PRECEDENCE testcorp exec
> Failed to execute query. [SELECT event_precedence from user_profile
> where company = 'testcorp' limit 1]
> 
> Any hints on where to debug? CDR is writing to the same DB and DSN
> (same connection) fine.

What happens if the identical query is done on the isql command line?

-- 
Tilghman