![]() 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. UID & PWD - The Default username & password is jethro.Įxport JETHRO_ODBC_HOME=/opt/jethro/jethroodbcĮxport ODBCINI=$JETHRO_ODBC_HOME/conf/odbc.iniĮxport ODBCINSTINI=$JETHRO_ODBC_HOME/conf/odbcinst.iniĮxport SIMBAINI=$JETHRO_ODBC_HOME/lib/JethroODBC.iniĮxport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$JETHRO_ODBC_HOME/lib.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: The default port is 9111, but the actual port number can be verified on the server by viewing the configuration file $JETHRO_HOME/instances/services.ini. PORT - The port to which JethroServer listens, on the machine running JethroServer.SERVER- Host name or IP address of the machine that runs JethroServer.To connect to a singleJethro server, specify: ![]() Edit the ODBC.ini file, typically located at /opt/jethro/odbc/conf/odbc.ini and update the following parameters within the file:.#ODBCInstLib=libodbcinst.a(libodbcinst.so.1) #ODBCInstLib=libiodbcinst.a(libiodbcinst.so.2) ![]() # - Note that AIX has a different format for specifying its shared libraries. # - Note that the path to your ODBC Driver Manager must be specified in LD_LIBRARY_PATH (LIBPATH for AIX, DYLD_LIBRARY_PATH for Darwin). # - Uncomment the ODBCInstLib corresponding to the Driver Manager being used. # directory the tarball was extracted to.ĮrrorMessagesPath=/opt/jethro/odbc/ErrorMessages/
0 Comments
Leave a Reply. |