[Freeswitch-users] ODBC and MSSQL

[Peter Hinman]

  We've got a MSSQL server that I was hoping to put to use as an ODBC 
data source for FS.  I can connect via ODBS to the database from the FS 
box and run queries using tsql.

FS also appears to be able to connect to the database, as it creates 
several tables when it starts up.  After successfully creating tables, 
it appears to run a test query, receives an error from which it 
concludes that transactions are not supported and then disables ODBC.

Is MSSQL expected to work with ODBC and FS?
It does successfully create tables. Does this mean that FS disabling 
ODBC is a bug that should be reported in jira?
Is there something I should be setting in the config other than
<param name="core-db-dsn" value="DSN:USERID:PASSWORD" />

Thanks,
Peter


Log snippet below:

2010-10-05 15:37:33.169737 [INFO] switch_core_sqldb.c:1275 Opening DB
2010-10-05 15:37:33.234702 [ERR] switch_odbc.c:427 ERR: [begin;delete 
from channels where hostname='';delete from channels where 
hostname='';commit;]
[STATE: 42000 CODE 102 ERROR: [FreeTDS][SQL Server]Incorrect syntax near 
';'.
]
2010-10-05 15:37:33.234775 [ERR] switch_core_sqldb.c:404 SQL ERR [STATE: 
42000 CODE 8180 ERROR: [FreeTDS][SQL Server]Statement(s) could not be 
prepared.
]
begin;delete from channels where hostname='';delete from channels where 
hostname='';commit;
2010-10-05 15:37:33.234796 [ERR] switch_core_sqldb.c:1326 Transactions 
not supported on your DB, disabling ODBC
2010-10-05 15:37:33.235916 [INFO] switch_core_sqldb.c:1275 Opening DB

Thanks,
Peter