If a user has a user DSN with the same name as a system DSN, the user DSN will be used upon connections by that user. System DSNs are available for every user on the system, but can only be added, modified, and removed by a system administrator. User DSNs are stored in a file in the user's home directory, or a subdirectory.
User DSNs are only available to a specific user. USER DATA SOURCES.: /home/odbcuser/.odbc.ini` You can also get this information from the unixODBC Driver Manager documentation.įor example, the following command prints the location of system and user odbc.ini files that contain, respectively, system and user data source names (DSNs): $ odbcinst -jįILE DATA SOURCES.: /etc/ODBCDataSources Information about which odbc.ini file is in use is available from the unixODBC tools odbc_config and odbcinst.
The Linux and macOS ODBC drivers don't know which odbc.ini file is in use, or the path to the odbc.ini file. In this case, you can add Trace=Yes to the section of /home/myappuser/odbcinst.ini. For example: $ ODBCSYSINI=/home/myappuser myapp Provide the instance the location of a private odbcinst.ini, by using the ODBCSYSINI environment variable. To not trace all applications (for example, to avoid disclosing sensitive per-user information), you can trace an individual application instance. Tracing applies to all applications that use the driver in odbcinst.ini. With the preceding settings, every time an application loads the unixODBC Driver Manager, it records all ODBC API calls made, into the output file.Īfter you finish tracing your application, remove Trace=Yes from the odbcinst.ini file to avoid the performance penalty of tracing, and ensure that any unnecessary trace files are removed.
Xojo includes full support for ODBC on Mac OS, so you can quickly create client / server applications that access and update data from your MS SQL Server database. You can also use /dev/stdout or any other device name to send trace output there, instead of to a persistent file. Xojo (formerly REALbasic) is a powerful, easy-to-use tool for creating custom cross-platform applications. Set the values Trace=Yes and TraceFile to the path of the file that will contain the trace output. To trace your application's ODBC behavior, edit the section of the odbcinst.ini file. The unixODBC Driver Manager on macOS and Linux supports tracing of ODBC API call entry and exit of the ODBC Driver for SQL Server.