If I use MySQL with the same fields it's working fine. I think that is something wrong with FreeTDS drivers.
On Sun, Jun 20, 2010 at 7:13 PM, Tilghman Lesher <[email protected]> wrote: > 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 >
-- _____________________________________________________________________ -- 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
