Using Multiple Databases

Sybase

To set up a Sybase Gateway to access a remote Sybase Server:

: 1. In addition to the environment variables, INFORMIXDIR and XAPPLRESDIR you have already set, you also need to set the SYBASE environment variable to the directory where you have the Sybase interfaces file.
: 2. Example:

%setenv SYBASE /this/dir

: The interfaces file /this/dir/interfaces may look like this:

   SYBLUE
           query tcp sun-ether hemingway 23000
           master tcp sun-ether hemingway 23000
           console tcp sun-ether hemingway 23001
   CEZANNE
           query tcp ether cezanne 60001
           master tcp ether cezanne 60001
           console tcp ether cezanne 60002

: 3. Restart the ORB. This time you should see both dborbd.syb and dborbd.inf running.
: 4. Restart Sapphire/Web.
: 5. Remove all the database-specific settings from the project option.
: 6. You should be able to see both Informix and Sybase servers in the Database Browser as well as using the data objects from either database for object binding.

The Sybase interfaces file is used to route requests to other servers and to determine the network protocol, physical communications port, and location of a named server. The interfaces file is used by Sapphire to locate and access the Sybase server. As long as the Sybase Server machine and the machine where you are running the Gateway are TCP/IP networked, Sapphire Gateway will talk to your remote Sybase server via interfaces file. In order to have the proper interfaces file on the machine where the ORB will be running, you should always have the Sybase client configuration (Sybase Client Server).

Oracle

If there are multiple Oracle databases that need to be accessed by your tool or client, it is necessary to perform the following to configure them:

: 1. Copy the following file to a directory you want to store resource files in or else modify the one in the global location:

cp $SAPPHIRE/newconfig/app-defaults resource_dir

: 2. Add all of the Oracle databases to this file by following this convention:

OracleDatabase : sid
OracleDatabase : alias
OracleDatabase : @T:hostname:sid
OracleDatabase : @T:ip_address:sid

: 3. In addition to the normal Gateway environment for Oracle, add the following:

C Shell Bourne/Korn Shell

setenv XAPPLRESDIR resource_dir XAPPLRESDIR=resource_dir

export XAPPLRESDIR

C Shell	Bourne/Korn Shell
setenv XAPPLRESDIR resource_dir	XAPPLRESDIR=resource_dir
	export XAPPLRESDIR

: 4. Start the Gateway in the normal fashion.

$SAPPHIRE/bin/dborbd.sh&

[Top] [Prev] [Next] [Bottom] [Contents]

info@bluestone.com