diff options
| author | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2008-02-01 18:08:44 +0000 |
|---|---|---|
| committer | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2008-02-01 18:08:44 +0000 |
| commit | e2d7ac6e3fa527b2d40d7804612487dc46558e9c (patch) | |
| tree | 2ccb475482ad86dff2adf1b72f138f101287f9a0 /configs/res_odbc.conf.sample | |
| parent | dadc6549d2812a91a7d561e9fb0995824c802a99 (diff) | |
Clarify the pooling functionality by changing the config file keyword
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@101824 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'configs/res_odbc.conf.sample')
| -rw-r--r-- | configs/res_odbc.conf.sample | 13 |
1 files changed, 8 insertions, 5 deletions
diff --git a/configs/res_odbc.conf.sample b/configs/res_odbc.conf.sample index 097849dd7..c40b47e3e 100644 --- a/configs/res_odbc.conf.sample +++ b/configs/res_odbc.conf.sample @@ -4,8 +4,9 @@ ; Note that all environmental variables can be seen by all connections, ; so you can't have different values for different connections. [ENV] -INFORMIXSERVER => my_special_database -INFORMIXDIR => /opt/informix +;INFORMIXSERVER => my_special_database +;INFORMIXDIR => /opt/informix +;ORACLE_HOME => /home/oracle ; All other sections are arbitrary names for database connections. @@ -15,6 +16,7 @@ dsn => asterisk ;username => myuser ;password => mypass pre-connect => yes +; ; What should we execute to ensure that our connection is still alive? The ; statement should return a non-zero value in the first field of its first ; record. The default is "select 1". @@ -34,17 +36,18 @@ pre-connect => yes ;idlecheck => 3600 ; Certain servers, such as MS SQL Server and Sybase use the TDS protocol, which -; limits the number of active queries per connection to 1. By setting up pools -; of connections, Asterisk can be made to work with these servers. +; limits the number of active queries per connection to 1. By telling res_odbc +; not to share connections, Asterisk can be made to work with these servers. [sqlserver] enabled => no dsn => mickeysoft -pooling => yes +share_connections => no limit => 5 username => oscar password => thegrouch pre-connect => yes sanitysql => select count(*) from systables +; ; Many databases have a default of '\' to escape special characters. MS SQL ; Server does not. backslash_is_escape => no |