ODBC MANAGER MAC ADD DRIVER DRIVER

The interface for setting up a DNS-less connection is BI tools specific, and it should generate a Jethro ODBC connection string. Jethro recommends using a DSN connection if possible, but some tools requires DSN-less connection string only. Some BI applications allow setting up a DSN-less connection.

Click on 'OK' to save the new DSN connection.

As for the empty 'values' in the table above, edit them according to your connection details:.

ODBC MANAGER MAC ADD DRIVER DRIVER

Driver - under , add =JethroODBCDriver ( see the example below).UID & PWD - The Default username & password is jethro.DATABASE -The name of the Jethro instance on the server.SERVER - A list of host:port pairs, separated by semi-colons (or alternativaly - commas).To connect to multipleJethro servers, by using the driver client-side load balancing feature, specify: PORT - The port to which JethroServer listens, on the machine running JethroServer (The default port is 9111, but the actual port number can be verified on the jethro server machine, by viewing the configuration file $JETHRO_HOME/instances/services.ini).

SERVER- Host name or IP address of the machine that runs JethroServer.

To connect to a singleJethro server, specify:

ManuallyĬreate/Edit the ODBC.ini file, (located at /Library/ODBC/odbc.ini for system DSN) and add the following configs into the file: To create a DSN, either use ODBC Manager, or edit the appropriate odbc.ini file manually. To setup a DSN based connection to a Jethro instance on Mac, create a user/system DSN with the instance connection details, depending on the type of DSN you create:

Odbc manager mac add driver