If I use MySQL with the same fields it's working fine. I think that is something wrong with FreeTDS drivers.<br><br>
<div class="gmail_quote">On Sun, Jun 20, 2010 at 7:13 PM, Tilghman Lesher <span dir="ltr"><<a href="mailto:tlesher@digium.com">tlesher@digium.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div class="im">On Saturday 19 June 2010 08:35:47 Zeeshan Zakaria wrote:<br>> On 2010-06-19 9:10 AM, "Andraž" <<a href="mailto:atletek@gmail.com">atletek@gmail.com</a>> wrote:<br>><br>> Ok, this issue I resolved, I just changed the TDS version to 7.0. But now I<br>
> 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<br>> INTO pbx_VoiceMail<br>> (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailb<br>
>oxuser,mailboxcontext) VALUES (?,?, ? , ?,?,?,?,?,?,?)]<br>> [Jun 19 14:30:25] WARNING[6212] res_odbc.c: SQL Prepare failed. Attempting<br>> 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<br>> [kupalaodbc]<br>><br></div>
<div class="im">> Seems to me that the SQL statement is not complete and asterisk is<br>> complaining about it. Do you prepare this statement in your dialplan or<br>> asterisk makes it automatically?<br><br></div>
What, specifically, do you think is not complete about this prepare statement?<br><br>The only error that I can guess at is that the table "pbx_VoiceMail" does not<br>have all of the columns listed in the statement.<br>
<div class="im"><br>--<br>Tilghman Lesher<br>Digium, Inc. | Senior Software Developer<br>twitter: Corydon76 | IRC: Corydon76-dig (Freenode)<br>Check us out at: <a href="http://www.digium.com/" target="_blank">www.digium.com</a> & <a href="http://www.asterisk.org/" target="_blank">www.asterisk.org</a><br>
<br>--<br>_____________________________________________________________________<br></div>
<div>
<div></div>
<div class="h5">-- 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></div>
</div></blockquote></div><br>