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