general:linux:unixodbc
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
general:linux:unixodbc [2021/12/16 13:01] – [FreeTDS] sunkan | general:linux:unixodbc [2022/04/11 08:05] (current) – sunkan | ||
---|---|---|---|
Line 12: | Line 12: | ||
< | < | ||
root@web:~# odbcinst -i -s -l -r << EOF | root@web:~# odbcinst -i -s -l -r << EOF | ||
- | > [DSNName] | + | [DSNName] |
Driver | Driver | ||
Description | Description | ||
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 | ||
</ | </ | ||
+ | |||
+ | ===== Tracing ===== | ||
+ | A trace log can be created by adding this to / | ||
+ | < | ||
+ | [ODBC] | ||
+ | Trace = Yes | ||
+ | Trace File = / | ||
+ | </ | ||
+ | |||
+ | Or by setting DumpFile in / | ||
+ | < | ||
+ | [THE_DSN_NAME] | ||
+ | ... | ||
+ | DumpFile=/ | ||
+ | </ | ||
+ | |||
+ | ===== Connection pooling ===== | ||
+ | Connection pooling can be turned on by adding Pooling=Yes and CPTimeout > 0 in / | ||
+ | < | ||
+ | [ODBC] | ||
+ | ... | ||
+ | Pooling | ||
+ | |||
+ | [FreeTDS] | ||
+ | ... | ||
+ | CPTimeout=120 | ||
+ | </ | ||
+ | |||
+ | ===== More FreeTDS settings ===== | ||
+ | [[http:// | ||
+ | |||
+ | [[https:// |
general/linux/unixodbc.1639659693.txt.gz · Last modified: 2021/12/16 13:01 by sunkan