Julian,<br>
<br>
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.<br>
<br>
In the /etc/odbcinst.ini file add this to enable tracing:<br>
<br>
[ODBC]<br>
Trace = Yes<br>
TraceFile = /tmp/sql.log<br>
ForceTrace = Yes<br>
<br>
Mark<br><br><div><span class="gmail_quote">On 9/19/05, <b class="gmail_sendername">Julian Lyndon-Smith</b> <<a href="mailto:asterisk@dotr.com">asterisk@dotr.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Guys, I've got a serious problem in that for political reasons I need to<br>be able to use ODBC for realtime against a progress (not postgres) database.<br><br>I've got a problem with * and my current odbc driver, as any update
<br>statement fails (SQLExecute error). (However, on the same box, the same<br>UPDATE statement works if embedded in a php page)<br><br>I did have unixODBC installed, but thought that I would try iODBC. I<br>uninstalled unixODBC, and installed iODBC. However, res_odbc will not
<br>compile because /usr/include/odbcinst.h is missing. Nearest thing that<br>I've found is /usr/local/include/iodbcinst.h.<br><br>Do I need unixODBC ? If so, does * only compile with unixODBC and does<br>not support iODBC ?
<br><br>Many thanks.<br><br>Julian.<br><br><br>_______________________________________________<br>Asterisk-Dev mailing list<br><a href="mailto:Asterisk-Dev@lists.digium.com">Asterisk-Dev@lists.digium.com</a><br><a href="http://lists.digium.com/mailman/listinfo/asterisk-dev">
http://lists.digium.com/mailman/listinfo/asterisk-dev</a><br>To UNSUBSCRIBE or update options visit:<br> <a href="http://lists.digium.com/mailman/listinfo/asterisk-dev">http://lists.digium.com/mailman/listinfo/asterisk-dev
</a><br></blockquote></div><br>