<div dir="ltr">Hi all <div><br></div><div>asterisk 1.8.23</div><div><br></div><div>I have <span class="" style>odbc</span> all setup to <span class="" style>mysql</span> but cant figure out why the <span class="" style>dialplan</span> wont write to the <span class="" style>odbc</span> function</div>
<div><br></div><div><span class="" style>fubc</span>_<span class="" style>odbc</span>.<span class="" style>conf</span></div><div><br></div><div><div>[DEVICES]</div><div><span class="" style>dsn</span>=device-<span class="" style>conn</span>                ;<span class="" style>dsn</span> in res_<span class="" style>odbc</span> not <span class="" style>odbc</span>.<span class="" style>ini</span></div>
<div><span class="" style>readsql</span>=SELECT call.<span class="" style>callNum</span>, call.city, devices.<span class="" style>callId</span>, <a href="http://devices.id">devices.id</a> FROM call INNER JOIN devices ON <a href="http://call.id">call.id</a> = devices.<span class="" style>callId</span> WHERE <span class="" style>deviceNumber</span> = '${<span class="" style>SQL</span>_<span class="" style>ESC</span>(${ARG1})}'</div>
<div><br></div><div><span class="" style>writesql</span>=insert into voted (<span class="" style>callId</span>,<span class="" style>callNum</span>,city,<span class="" style>deviceId</span>,<span class="" style>SerialNum</span>,<span class="" style>serverResponse</span>) values (${VAL1},"${VAL2}",${VAL3},${VAL4},${VAL5},"${VAL6}"</div>
</div><div><br></div><div><br></div><div>extension.<span class="" style>conf</span></div><div><br></div><div>the relevant line</div><div><br></div><div><div><br></div><div>same => n,set(<span class="" style>ODBC</span>_DEVICES()=${<span class="" style>callid</span>},${call},1,${<span class="" style>deviceid</span>},${<span class="" style>num</span>},${<span class="" style>serverupdate</span>})</div>
</div><div><br></div><div><br></div><div>when sending the values from the <span class="" style>cli</span> using <span class="" style>odbc</span> write it works <span class="" style>ok</span> </div><div>reading from the <span class="" style>dialplan</span>  works <span class="" style>ok</span></div>
<div>i tried sending plain values without variables</div><div><br></div><div>but from the <span class="" style>dialplan</span> gives me a error " cant write to function <span class="" style>ODBC</span>_DEVICES"</div>
<div><br></div><div>happy to hear any ideas</div><div><br></div><div><br></div></div>