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
