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. ] =