aboutsummaryrefslogtreecommitdiffstats
path: root/trunk/configs/res_odbc.conf.sample
diff options
context:
space:
mode:
Diffstat (limited to 'trunk/configs/res_odbc.conf.sample')
-rw-r--r--trunk/configs/res_odbc.conf.sample48
1 files changed, 48 insertions, 0 deletions
diff --git a/trunk/configs/res_odbc.conf.sample b/trunk/configs/res_odbc.conf.sample
new file mode 100644
index 000000000..2fd9aa702
--- /dev/null
+++ b/trunk/configs/res_odbc.conf.sample
@@ -0,0 +1,48 @@
+;;; odbc setup file
+
+; ENV is a global set of environmental variables that will get set.
+; 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
+
+; All other sections are arbitrary names for database connections.
+
+[asterisk]
+enabled => no
+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".
+;sanitysql => select 1
+
+
+[mysql2]
+enabled => no
+dsn => MySQL-asterisk
+username => myuser
+password => mypass
+pre-connect => yes
+
+; 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.
+[sqlserver]
+enabled => no
+dsn => mickeysoft
+pooling => yes
+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
+
+
+