Differences

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

--- general:linux:unixodbc [2021/12/16 12:22] – created sunkan
+++ general:linux:unixodbc [2022/04/11 08:05] (current) – sunkan
@@ Line 9: / Line 9: @@
     Target directory is /etc
 </code>
+<code>
+root@web:~# odbcinst -i -s -l -r << EOF
+[DSNName]
+Driver          = FreeTDS
+Description     = Describe connection
+Server          = hostname_of_server
+Database        = Database_Name
+Port            = 1433
+TDS_Version     = 7.3
+ClientCharset   = UTF-8
+EOF
+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>
+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>
+===== More FreeTDS settings =====
+[[http://www.freetds.org/userguide/OdbcConnAttr.html|Connection attributes]]
+[[https://www.freetds.org/userguide/ChoosingTdsProtocol.html|TDS Version]]