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. ] thanx all
I've only used it from javascript (spidermonkey), and there it works as expected. But I didn't try to use odbc for the core db (yet). /Peter Från: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] För babak yakhchali Skickat: den 8 juni 2010 09:08 Till: freeswitch-users@lists.freeswitch.org Ämne: Re: [Freeswitch-users] odbc on windows no one used ODBC on windows? !DSPAM:4c0dee0732931407819578!
You are not the only one with this question, I hope I will get the chance to make a few tests next week. On 8 June 2010 08:08, babak yakhchali <babak.freeswitch@gmail.com> wrote:
no one used ODBC on windows? _______________________________________________ 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
-- Frank Church ======================= http://devblog.brahmancreations.com
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. ] =
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
I believe that Transact-SQL requires BEGIN TRANSACTION and COMMIT TRANSACTION http://msdn.microsoft.com/en-us/library/ms188929(v=SQL.105).aspx -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/odbc-on-windows-tp5145042p5177... Sent from the freeswitch-users mailing list archive at Nabble.com.
can someone make sure there is a bug in jira about this issue. Mike On Jun 14, 2010, at 9:48 AM, Jeff Lenk wrote:
I believe that Transact-SQL requires BEGIN TRANSACTION and COMMIT TRANSACTION
http://msdn.microsoft.com/en-us/library/ms188929(v=SQL.105).aspx
Done- http://jira.freeswitch.org/browse/FSCORE-623 -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/odbc-on-windows-tp5145042p5179... Sent from the freeswitch-users mailing list archive at Nabble.com.
participants (6)
-
babak yakhchali
-
Frank Church
-
Jan Berger
-
Jeff Lenk
-
Michael Jerris
-
Peter Olsson