[Freeswitch-users] odbc on windows

[Jan Berger]

Send me the SQL statement. SQL is SQL, but well - Microsoft have never given
a crap about standards.

-----Original Message-----
From: freeswitch-users-bounces at lists.freeswitch.org
[mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Michael
Jerris
Sent: 14. juni 2010 04:20
To: freeswitch-users at lists.freeswitch.org
Subject: Re: [Freeswitch-users] odbc on windows

This appears to be not an issue with odbc on windows, but the sql statements
we create from the core  db not being compatible somehow with ms sql server.
Shouldn't BEGIN syntax for transactions be fine for mssql ?

Mike

On Jun 6, 2010, at 5:41 AM, babak yakhchali wrote:

> Hi
> I configured my sofia profile internal to use odbc. it connects and
creates tables but after that I get lots of errors like bellow
> these are just a few of them:
> 
> 2010-06-06 14:09:04.000000 [ERR] switch_odbc.c:427 ERR: [BEGIN]
> [STATE: 42000 CODE 102 ERROR: [Microsoft][ODBC SQL Server Driver][SQL
Server]Inc
> orrect syntax near 'BEGIN'.
> ]
> 2010-06-06 14:09:04.000000 [ERR] switch_core_sqldb.c:404 SQL ERR [STATE:
42000 C
> ODE 8180 ERROR: [Microsoft][ODBC SQL Server Driver][SQL
Server]Statement(s) coul
> d not be prepared.
> ]
=
_______________________________________________
FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org