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:02] – [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 32: Line 32:
 </code> </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.1639659768.txt.gz · Last modified: 2021/12/16 13:02 by sunkan

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