Differences

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

--- general:linux:unixodbc [2021/12/16 12:32] – [FreeTDS] sunkan
+++ general:linux:unixodbc [2022/04/11 08:02] – sunkan
@@ Line 12: / Line 12: @@
 <code>
 root@web:~# odbcinst -i -s -l -r << EOF
-> [DSNName]
+[DSNName]
-Driver          = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
+Driver          = FreeTDS
 Description     = Describe connection
-Trace           = No
 Server          = hostname_of_server
 Database        = Database_Name
@@ Line 24: / Line 23: @@
 odbcinst: Sections and Entries from stdin have been added to ODBC.INI
 </code>
+===== Tracing =====
+A trace log can be created by adding this to /etc/odbcinst.ini
+<code>
+[ODBC]
+Trace      = Yes
+Trace File = /tmp/sql.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>
+===== More FreeTDS settings =====
+[[http://www.freetds.org/userguide/OdbcConnAttr.html|Connection attributes]]
+[[https://www.freetds.org/userguide/ChoosingTdsProtocol.html|TDS Version]]