general:linux:unixodbc
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
general:linux:unixodbc [2021/12/16 12:22] – created sunkan | general:linux:unixodbc [2022/04/11 08:05] (current) – sunkan | ||
---|---|---|---|
Line 9: | Line 9: | ||
Target directory is /etc | Target directory is /etc | ||
</ | </ | ||
+ | |||
+ | < | ||
+ | root@web:~# odbcinst -i -s -l -r << EOF | ||
+ | [DSNName] | ||
+ | Driver | ||
+ | Description | ||
+ | Server | ||
+ | Database | ||
+ | Port = 1433 | ||
+ | TDS_Version | ||
+ | ClientCharset | ||
+ | EOF | ||
+ | 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.1639657369.txt.gz · Last modified: 2021/12/16 12:22 by sunkan