DbiSetup

From Support Wiki

How do I setup my DBI server for DataServer?

1. First you must edit the odbcdmn.ini file to make the information consistent with both Dataserver and the Data Source Name that you will use. The sample odbcdmn.ini that I am putting below uses the Data Source Name 'blizzard'. Simply change the file where you see blizzard to the data source name that you wish to use. Also note where it says <PATH TO UNIFY RELEASE> as you will need to substitute the base path of the UNIFY directory...not the UNIFY/lib or UNIFY/bin.

DBPATH should be set to your database path. Sample odbcdmn.ini file:

   [ODBC Data Sources]
   blizzard=DBIntegrator(This line is optional)
   [blizzard]
   Driver=<PATH TO UNIFY RELEASE>/bin/libdsodbc.so
   Description=A test DB
   Database=/home/db/file.db
   [DBIntegrator]
   ;odbcdmn must reside in <InstallDirectory>/bin
   ; to enable Control Center to start odbcdmn.
   InstallDirectory=<PATH TO UNIFY RELEASE>
   MgrPort=1583
   LogEvent=1
   LogMask=3
   Organization=Unify Corporation
   BindAllAddresses=1
   MgrInitProto=
   MgrSecondProto=
   ViewMask=251
   [DBIntegrator Trace]
   ManagerTrace=0
   MgrTrace=0
   LnaTrace=0
   ServerTrace=0 

2. Make sure that you have UNIFY set to the UNIFY/lib directory and LD_LIBRARY_PATH set to the UNIFY/bin directory in your environment. If using AIX or HP instead of setting LD_LIBRARY_PATH use the appropriate variable name (SHLIB_PATH for HP and LIBPATH for AIX)

3. Type the following command to run odbcdmn in the background:

$UNIFY/../bin/odbcdmn &

4. Check and make sure that the odbcdmn is running.

ps -ef | grep odbcdmn

How do I setup my DBI server for DataServer/ELS?

1. First you must edit the odbcdmn.ini file to make the information consistent with both ELS and the Data Source Name that you will use. The sample odbcdmn.ini that I am putting below uses the Data Source Name 'blizzard'. Simply change the file where you see blizzard to the data source name that you wish to use.

Also note where it says <PATH TO UNIFY RELEASE> as you will need to substitute the base path of the UNIFY directory...not the UNIFY/lib or UNIFY/bin.

DBQ should be set to your database path.

Be sure you're your Driver= line ends with libelsodbc.so and not libdsodbc.so

The last change you will have to make to this file is setting SHMID to some numeric value.

Sample odbcdmn.ini file:

   [ODBC Data Sources]
   blizzard=DBIntegrator (This line is optional)
   [blizzard]
   Driver=<PATH TO UNIFY RELEASE>/bin/libelsodbc.so
   Description=A test DB
   DBQ=/home/db
   DBNAME=file.db
   SHMID=xxx
   [DBIntegrator]
   ;odbcdmn must reside in /bin
   ; to enable Control Center to start odbcdmn.
   InstallDirectory=<PATH TO UNIFY RELEASE>
   MgrPort=1583
   LogEvent=1
   LogMask=3
   Organization=Unify Corporation
   BindAllAddresses=1
   MgrInitProto=
   MgrSecondProto=
   ViewMask=251
   [DBIntegrator Trace]
   ManagerTrace=0
   MgrTrace=0
   LnaTrace=0
   ServerTrace=0

2. Make sure that you have UNIFY set to the UNIFY/lib directory and LD_LIBRARY_PATH set to the UNIFY/bin directory in your environment. If using AIX or HP instead of setting LD_LIBRARY_PATH use the appropriate variable name (SHLIB_PATH for HP and LIBPATH for AIX)

3. Type the following command to run odbcdmn in the background:

$UNIFY/../bin/odbcdmn &

4. Check and make sure that the odbcdmn is running. ps -ef | grep odbcdmn

How do I setup the ODBC client side of DBI?

You must make a DSN entry on the client machine that matches what you included in the odbcdmn.ini file:

1. Under the Control Panel on your client machine you should have an ODBC Data Sources icon. Double click it to bring up a set of information. On Windows 2000/XP it will be in the Administrative Tools folder in the Control Panel

2. Click on the System or File DSN section (Either one should work) and press the add button.

3. Choose the Unify Driver from the list (This is assuming you have already loaded the client driver on the system). Then enter your information about the data source you wish to connect to.

4. Data Source Name should be exactly the same as the one you specified in the odbcdmn.ini file. (In the server setup examples it is \'blizzard\') Address is the ip address or hostname of your SERVER machine that the odbcdmn is running on. The default port number is 1583.

5. Save this entry.