Our ODBC Drivers for Sybase and Microsoft SQL Server use the
Most troubleshooting of these drivers can be done through the ordinary ODBC Traces and Driver Debug Logs, but sometimes protocol-level logs are necessary.
TDS protocol logging is enabled by setting the
TDSDUMP environment variable to the name of the file where the log should be written.
Environment variables are set differently on different operating systems.
With Enterprise Edition (Multi-Tier), this may be set in the
[Environment ...] stanza that's active for the connections in question.
It may also be set before starting the Broker (such that it's set for the Broker process, and inherited by all its child Agent processes).
With Lite Edition (Single-Tier), this may be set in the relevant stanza of the
openlink.ini file on Unix-like OS, or for the active login session before launching the ODBC client application on Windows, macOS, or Unix-like OS.
Details vary with different versions of macOS.
As of Lion, these simple Terminal.app commands will do the job, creating the tdsdump.txt file on the ODBC user's Desktop.
launchctl setenv TDSDUMP ~/Desktop/tdsdump.txt
launchctl setenv TDSDUMP /Users/ShortUsername/Desktop/tdsdump.txt
launchctl unsetenv TDSDUMP
Note that any active applications will not notice the change; you have to quit and relaunch.
A reboot or user log out will unset the variables set with these commands, and you'll need to re-set them afterward. Persistent settings (not usually appropriate for TDS logging) can be made through a launchd.plist, as described elsewhere.
On Snow Leopard (10.6) and earlier, this is best done by creating (or editing) a file called environment.plist in a (normally invisible) directory called .MacOSX, in the user's home directory. This method also works on Lion (10.7).
You can execute either of these commands in Terminal.app, to open the file for editing in TextEdit.app --
open -e /Users/ShortUsername/.MacOSX/environment.plist open -e ~/.MacOSX/environment.plist
If the file already exists, just add these two lines to the main <dict> block --
If you're creating a new file, make sure it contains this entire block --
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> <plist version="1.0"> <dict> <key>TDSDUMP</key> <string>~/Desktop/tdsdump.txt</string> </dict> </plist>
Commands vary with your active shell, among other variables, so we cannot provide an exhaustive list.
A couple of examples --
export TDSDUMP=/tmp/freetds.log ## some Unix systems set TDSDUMP=/tmp/freetds.log ; export TDSDUMP ## other Unix systems
You can send the log to any location in the accessible filesystem, local or remote.
This is a simple example --
You can also use the System control panel, Advanced tab, Environment Variables button.
Further details on usage can be found on the FreeTDS Web Site.