Asterisk make it. It is in app_voicemail, I'm using voicemail ODBC.<br><br>
<div class="gmail_quote">On Sat, Jun 19, 2010 at 3:35 PM, Zeeshan Zakaria <span dir="ltr"><<a href="mailto:zishanov@gmail.com">zishanov@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<p>Seems to me that the SQL statement is not complete and asterisk is complaining about it. Do you prepare this statement in your dialplan or asterisk makes it automatically?<br></p>
<p>Zeeshan A Zakaria</p>
<p>--<br><a href="http://www.ilovetovoip.com/" target="_blank">www.ilovetovoip.com</a></p>
<p>
<blockquote type="cite">
<div>
<div></div>
<div class="h5">On 2010-06-19 9:10 AM, "Andraž" <<a href="mailto:atletek@gmail.com" target="_blank">atletek@gmail.com</a>> wrote:<br><br>Ok, this issue I resolved, I just changed the TDS version to 7.0. But now I receive different error, I can't insert into database. <br>
<br>[Jun 19 14:30:25] WARNING[6212] app_voicemail.c: SQL Prepare failed![INSERT INTO pbx_VoiceMail (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext) VALUES (?,?, ? , ?,?,?,?,?,?,?)]<br>
[Jun 19 14:30:25] WARNING[6212] res_odbc.c: SQL Prepare failed. Attempting a reconnect...<br>[Jun 19 14:30:25] NOTICE[6212] res_odbc.c: Connecting sqlserver<br>[Jun 19 14:30:25] NOTICE[6212] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] <br>
</div></div>--
<div class="im"><br>_____________________________________________________________________<br>-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com/" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br> <a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></div></blockquote>
<p></p><br>--<br>_____________________________________________________________________<br>-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com/" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br> <a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></p></blockquote></div><br>