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
Last revisionBoth sides next revision
general:linux:unixodbc [2021/12/16 13:02] – [FreeTDS] sunkangeneral:linux:unixodbc [2022/04/11 08:02] 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>
  
 +===== 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.txt · Last modified: 2022/04/11 08:05 by sunkan

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