[asterisk-users] Voicemail ODBC

[Tilghman Lesher]

On Saturday 19 June 2010 08:35:47 Zeeshan Zakaria wrote:
> On 2010-06-19 9:10 AM, "Andraž" <atletek at gmail.com> wrote:
>
> Ok, this issue I resolved, I just changed the TDS version to 7.0. But now I
> receive different error, I can't insert into database.
>
> [Jun 19 14:30:25] WARNING[6212] app_voicemail.c: SQL Prepare failed![INSERT
> INTO pbx_VoiceMail
> (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailb
>oxuser,mailboxcontext) VALUES (?,?, ? , ?,?,?,?,?,?,?)]
> [Jun 19 14:30:25] WARNING[6212] res_odbc.c: SQL Prepare failed.  Attempting
> a reconnect...
> [Jun 19 14:30:25] NOTICE[6212] res_odbc.c: Connecting sqlserver
> [Jun 19 14:30:25] NOTICE[6212] res_odbc.c: res_odbc: Connected to sqlserver
> [kupalaodbc]
>
> Seems to me that the SQL statement is not complete and asterisk is
> complaining about it. Do you prepare this statement in your dialplan or
> asterisk makes it automatically?

What, specifically, do you think is not complete about this prepare statement?

The only error that I can guess at is that the table "pbx_VoiceMail" does not
have all of the columns listed in the statement.

-- 
Tilghman Lesher
Digium, Inc. | Senior Software Developer
twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
Check us out at: www.digium.com & www.asterisk.org