Asterisk with MS SQL Server ODBC

I’m looking at using Asterisk to create an appointment reminder call system, and I’m looking through the forums here to see what kind of issues one might encounter with MS Sql Server. However, search results are very small, and the only couple of actual MS SQL Server problems listed have no resolution.

I would be using Asterisk to run a SQL query (best case scenario), but if that’s not totally reliable, I would probably be best served creating a flat file from SQL server and picking that up with Asterisk, at least that’s my take on it.

So, question is: Has anybody had any results (good, bad, ugly) using Asterisk with MS SQL ODBC?

i have connected Asterisk to MS SQL Server by ODBC.