[asterisk-users] ODBC Voicemail storage

[Andraž]

No, I didn't.

On Wed, Aug 25, 2010 at 4:20 PM, Tilghman Lesher <tlesher at digium.com> wrote:

>  On Wednesday 25 August 2010 07:27:58 Andraž wrote:
> > I have a strange problem. I'm using Asterisk 1.4.xx with ODBC storage
> > (FreeTDS -> Mssql 2008 database). Everything it's working fine, but
> > sometimes I receive this error and Asterisk crashes.
> >
> > [Aug 25 13:25:13] WARNING[14032] app_voicemail.c: SQL Prepare
> > failed![SELECT COUNT(*) FROM pbx_VoiceMail WHERE dir =
> '/var/spool/asterisk
> > /voicemail/default/7002/INBOX']
> > [Aug 25 13:25:13] WARNING[14032] res_odbc.c: SQL Prepare failed.
> > Attempting a reconnect...
> > [Aug 25 13:25:13] NOTICE[14032] res_odbc.c: Connecting sqlserver
> > [Aug 25 13:25:13] NOTICE[14032] res_odbc.c: res_odbc: Connected to
> > sqlserver [kupalaodbc]
> > Regards Andraž
>
> Did you enable pooling in res_odbc.conf?  It is mandatory when connecting
> to
> SQL Server.
>
> --
> Tilghman Lesher
> Digium, Inc. | Senior Software Developer
> twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
> Check us out at: www.digium.com & www.asterisk.org
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>               http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100825/fde0a84e/attachment.htm