Send me the SQL statement. SQL is SQL, but well - Microsoft have never given a crap about standards. -----Original Message----- From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Michael Jerris Sent: 14. juni 2010 04:20 To: freeswitch-users@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org