<HTML>
<HEAD>
<TITLE>Re: [Asterisk-Dev] what do I need to implement odbc</TITLE>
</HEAD>
<BODY>
<FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>This is true.. Also did you try it with isql?<BR>
<BR>
/b<BR>
<BR>
<BR>
On 9/19/05 1:29 PM, "Mark Aiken" <aiken.mark@gmail.com> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>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>
On 9/19/05, <B>Julian Lyndon-Smith</B> <asterisk@dotr.com> wrote:<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>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>
Asterisk-Dev@lists.digium.com<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> <a href="http://lists.digium.com/mailman/listinfo/asterisk-dev"><http://lists.digium.com/mailman/listinfo/asterisk-dev></a> <BR>
<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'><BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></SPAN></FONT><FONT SIZE="2"><FONT FACE="Courier New"><SPAN STYLE='font-size:10.0px'>_______________________________________________<BR>
Asterisk-Dev mailing list<BR>
Asterisk-Dev@lists.digium.com<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>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Courier New"><SPAN STYLE='font-size:10.0px'><BR>
</SPAN></FONT></FONT>
</BODY>
</HTML>