[asterisk-users] Voicemail ODBC

[Andraž]

I have Asterisk 1.4.32 and I would like save all VoiceMail to MSSQL 2008
database. I configured ODBC, but I receive this errors.
    [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: Connecting sqlserver
    [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: res_odbc: Connected to
sqlserver [kupalaodbc]
    [Jun 18 14:00:37] WARNING[19914] app_voicemail.c: SQL Prepare
failed![SELECT COUNT(*) FROM pbx_VoiceMail WHERE dir =
'/var/spool/asterisk/voicemail/default/390/INBOX']
    [Jun 18 14:00:37] WARNING[19914] res_odbc.c: SQL Prepare failed.
Attempting a reconnect...
    [Jun 18 14:00:37] WARNING[19914] res_odbc.c: Unable to deallocate
database handle? 0 errno=0 [unixODBC][Driver Manager]Function sequence error

I have configured in voicemail.conf
    [general]
    format=wav49
    odbcstorage=sqlserver
    odbctable=pbx_VoiceMail
odbc.ini
    [kupalaodbc]
    Description     = ODBC connection
    Driver          = ms-sql
    Servername      = ms-sql
    UID             = TestDatabaseDemo
    database        = TestDatabaseDemo
    Port            = 1364

odbcinst.ini
    [ms-sql]
    Description     = TDS connection
    Driver          = /usr/lib/odbc/libtdsodbc.so
    Setup           = /usr/lib/odbc/libtdsS.so
    UsageCount      = 1
    FileUsage       = 1
freetds.conf
    [ms-sql]
            host = 192.168.1.10
            port = 1364
            tds version = 8.0
            dump file = /var/log/freetds.log

I reloaded module and restarted asterisk also, but with no success.
What can be wrong?

Regards Andraž
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100619/29723e9d/attachment.htm