asterisk users - May 2009 - func_odbc.c: Unable to execute query

Dear List,

I have an asterisk 1.6.2 installation. I'm trying to configure func_odbc to
read some mysql tables... but every time I tried I got this message:

ERROR[24968] func_odbc.c: Unable to execute query [SELECT bloqueada FROM
funciones WHERE extension='750']

I'm sure the DSN is right because I can do this:

[root at grupodelavega asterisk]# su - asterisk
[asterisk at grupodelavega ~]$ isql mysql_dsn
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select bloqueada from funciones where extension='750'
+-----------+
| bloqueada |
+-----------+
| 0         |
+-----------+
SQLRowCount returns 1
1 rows fetched
SQL>


Thanks in advance,
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20090507/e5918e22/attachment.htm

On Thursday 07 May 2009 18:21:55 arturo arturo wrote:
> I have an asterisk 1.6.2 installation. I'm trying to configure
func_odbc to
> read some mysql tables... but every time I tried I got this message:
>
> ERROR[24968] func_odbc.c: Unable to execute query [SELECT bloqueada FROM
> funciones WHERE extension='750']
What is the output of 'odbc show' from the Asterisk CLI?  What is in
your
odbc.ini, res_odbc.conf, and func_odbc.conf?  Remember that the entry in
odbc.ini is referenced by res_odbc.conf, and the entry in func_odbc.conf
references the entry in res_odbc.conf, not odbc.ini.

-- 
Tilghman