On Saturday 19 June 2010 08:35:47 Zeeshan Zakaria wrote: > On 2010-06-19 9:10 AM, "Andraž" <[email protected]> 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 -- _____________________________________________________________________ -- 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
