-=Zappa.CX=- Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== unixODBC ======
===== FreeTDS =====
Install tdsodbc, unixodbc, odbcinst

Install driver to /etc/odbcinst.ini
<code>
# odbcinst -i -d -f /usr/share/tdsodbc/odbcinst.ini
odbcinst: Driver installed. Usage count increased to 1. 
    Target directory is /etc
</code>

<code>
root@web:~# odbcinst -i -s -l -r << EOF
[DSNName]
Driver          = FreeTDS
Description     = Describe connection
Server          = hostname_of_server
Database        = Database_Name
Port            = 1433
TDS_Version     = 7.3
ClientCharset   = UTF-8
EOF
odbcinst: Sections and Entries from stdin have been added to ODBC.INI
</code>

===== Tracing =====
A trace log can be created by adding this to /etc/odbcinst.ini
<code>
[ODBC]
Trace      = Yes
Trace File = /tmp/sql.log
</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]]