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

[Brian K. West]

This is true.. Also did you try it with isql?

/b


On 9/19/05 1:29 PM, "Mark Aiken" <aiken.mark at gmail.com> wrote:

> 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
>> <http://lists.digium.com/mailman/listinfo/asterisk-dev>
>> 
> 
> 
> _______________________________________________
> 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/67ec5a18/attachment.htm