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:23] – [More FreeTDS settings] 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 30: Line 30:
 Trace      = Yes Trace      = Yes
 Trace File = /tmp/sql.log 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> </code>
  
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