[Asterisk-Dev] what do I need to implement odbc

[Mark Aiken]

Julian,

I've worked with unixODBC quite a bit and it can often be instructive to 
enable tracing and have a look at the log for why the SQLExecute is failing. 
It can sometimes reveal silly mistakes in the query or quoting errors, 
permissions, etc.

In the /etc/odbcinst.ini file add this to enable tracing:

[ODBC]
Trace = Yes
TraceFile = /tmp/sql.log
ForceTrace = Yes

Mark

On 9/19/05, Julian Lyndon-Smith <asterisk at dotr.com> wrote:
> 
> Guys, I've got a serious problem in that for political reasons I need to
> be able to use ODBC for realtime against a progress (not postgres) 
> database.
> 
> I've got a problem with * and my current odbc driver, as any update
> statement fails (SQLExecute error). (However, on the same box, the same
> UPDATE statement works if embedded in a php page)
> 
> I did have unixODBC installed, but thought that I would try iODBC. I
> uninstalled unixODBC, and installed iODBC. However, res_odbc will not
> compile because /usr/include/odbcinst.h is missing. Nearest thing that
> I've found is /usr/local/include/iodbcinst.h.
> 
> Do I need unixODBC ? If so, does * only compile with unixODBC and does
> not support iODBC ?
> 
> Many thanks.
> 
> Julian.
> 
> 
> _______________________________________________
> Asterisk-Dev mailing list
> Asterisk-Dev at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-dev
> To UNSUBSCRIBE or update options visit:
> http://lists.digium.com/mailman/listinfo/asterisk-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-dev/attachments/20050919/5b0c3820/attachment.htm