No, I didn't.<br><br>
<div class="gmail_quote">On Wed, Aug 25, 2010 at 4:20 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>
<div></div>
<div class="h5">On Wednesday 25 August 2010 07:27:58 Andraž wrote:<br>> I have a strange problem. I'm using Asterisk 1.4.xx with ODBC storage<br>> (FreeTDS -> Mssql 2008 database). Everything it's working fine, but<br>
> sometimes I receive this error and Asterisk crashes.<br>><br>> [Aug 25 13:25:13] WARNING[14032] app_voicemail.c: SQL Prepare<br>> failed![SELECT COUNT(*) FROM pbx_VoiceMail WHERE dir = '/var/spool/asterisk<br>
> /voicemail/default/7002/INBOX']<br>> [Aug 25 13:25:13] WARNING[14032] res_odbc.c: SQL Prepare failed.<br>> Attempting a reconnect...<br>> [Aug 25 13:25:13] NOTICE[14032] res_odbc.c: Connecting sqlserver<br>
> [Aug 25 13:25:13] NOTICE[14032] res_odbc.c: res_odbc: Connected to<br>> sqlserver [kupalaodbc]<br>> Regards Andraž<br><br></div></div>Did you enable pooling in res_odbc.conf? It is mandatory when connecting to<br>
SQL Server.<br><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>-- 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></blockquote>
</div><br>