Differences

This shows you the differences between two versions of the page.

--- general:linux:unixodbc [2021/12/16 13:23] – [More FreeTDS settings] sunkan
+++ general:linux:unixodbc [2022/04/11 08:05] (current) – sunkan
@@ Line 12: / Line 12: @@
 <code>
 root@web:~# odbcinst -i -s -l -r << EOF
-> [DSNName]
+[DSNName]
 Driver          = FreeTDS
 Description     = Describe connection
@@ Line 30: / Line 30: @@
 Trace      = Yes
 Trace File = /tmp/sql.log
+</code>
+Or by setting DumpFile in /etc/odbc.ini
+<code>
+[THE_DSN_NAME]
+...
+DumpFile=/tmp/sqldump.log
+</code>
+===== Connection pooling =====
+Connection pooling can be turned on by adding Pooling=Yes and CPTimeout > 0 in /etc/odbcinst.ini
+<code>
+[ODBC]
+...
+Pooling    = Yes
+[FreeTDS]
+...
+CPTimeout=120
 </code>