[asterisk-users] MSSQL ODBC Connections

Robert McNaught robert.mcnaught at gmail.com
Sat Nov 24 14:48:02 CST 2007


Hi all,

The asterisk book states the following for using ODBC to connect to an
MS database.

‡ The pooling and limit options are quite useful for MS SQL Server and
Sybase databases. These permit you
  to establish multiple connections (up to limit connections) to a
database while ensuring that each connection
  has only one statement executing at once (this is due to a limitation
in the protocol used by these database
  servers).

Does anyone know if it is possible to use the same database and single
ODBC connection to do both CDR recording with cdr_odbc and dialplan
routing based on func_odbc.

I have both res_odbc.conf and cdr_odbc.conf pointing to the same DSN in
odbc.ini

I am starting to think that this limitation in having a single
connection would stop this being possible in asterisk - does anyone know
otherwise?

Thanks

Robert McNaught


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20071124/8ad59369/attachment.htm 


More information about the asterisk-users mailing list