Created On:  2008-09-30

Problem:

Under UNIX, you need to manually configure EnterpriseLink to have its Repositories reside in an ODBC Database.

Resolution:

You will need to download and install the 32bit ODBC drivers for the database you are trying to connect to.

After that, you need to edit the env.sh file located in the Elink config directory to add any environment variables that might be needed to be able to load these ODBC drivers.

For example, using the EasySoft MS-SQL ODBC Drivers on AIX, you would need to provide the LIBPATH variable pointing to the lib directories where the EasySoft shared libraries are located:


LIBPATH=/usr/local/easysoft/lib:/usr/local/easysoft/unixODBC/lib
export LIBPATH

Add the appropriate entries in the EnterpriseLink.cfg file located in the Elink config directory.
For example if using the EasySoft MS-SQL ODBC Drivers on AIX:

[ODBC Drivers]
SQL Server = Installed

[ODBC Data Sources]
ELRepository = 0SQL Server

[SQL Server]
Driver  = /usr/local/easysoft/sqlserver/lib/libessqlsrv.a


[ELRepository]
Description = Microsoft SQL Server Repository
Driver  = /usr/local/easysoft/sqlserver/lib/libessqlsrv.a
Setup  = /usr/local/easysoft/sqlserver/lib/libessqlsrvS.a
Threading  = 0
FileUsage  = 1
DontDLClose = 1
UsageCount = 1
User   = <sql server userid>
Password  = <sql server password>
Server  = <sql server name>
Port   = <sql server port number, default 1433>
Database  = <sql server database name>