[asterisk-users] ODBC Voicemail storage

[Tilghman Lesher]

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