User Tools

Site Tools


general:linux:unixodbc

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
general:linux:unixodbc [2021/12/16 13:01] – [FreeTDS] sunkangeneral:linux:unixodbc [2022/04/11 08:05] (current) sunkan
Line 12: Line 12:
 <code> <code>
 root@web:~# odbcinst -i -s -l -r << EOF root@web:~# odbcinst -i -s -l -r << EOF
-[DSNName]+[DSNName]
 Driver          = FreeTDS Driver          = FreeTDS
 Description     = Describe connection Description     = Describe connection
Line 23: Line 23:
 odbcinst: Sections and Entries from stdin have been added to ODBC.INI odbcinst: Sections and Entries from stdin have been added to ODBC.INI
 </code> </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]]
general/linux/unixodbc.1639659693.txt.gz · Last modified: 2021/12/16 13:01 by sunkan

Donate Powered by PHP Valid HTML5 Valid CSS Run on Debian Driven by DokuWiki