[asterisk-users] Voicemail ODBC

[Andraž]

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 <tlesher at digium.com> wrote:

> 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
>
> --
> _____________________________________________________________________
>  -- 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100620/1e125550/attachment.htm