Kbase 16721: Intersolv ODBC V2.5: Remote OIB + Remote DB in self-service
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Intersolv ODBC V2.5: Remote OIB + Remote DB in self-service
This is a Datasource sample for an Intersolv V2.5 ODBC driver
configuration with a remote TCP OID/OIB running in self-service mode
against a progress remote database under UNIX.
1. Pre-requisite:
-------------
You first need to start your server on your Remote Machine. This can
be done by using the following command on your remote machine:
proserve -db sports
(-N and -S are not needed because the OID will access directly the
database as a self-service client)
You need as well to start a Progress OIB on the same machine or a
Progress OID. The OIB can be started with the following command on you
your remote machine: prooibrk -SV -S prosv02
prooibrk -SV -S prosv02
If you have any problem to start the OID or the OIB, see the related
Kbase. (How to start an OID/OIB under UNIX)
Note: It is easier to establish an ODBC connection with an OID started
manually. To start the OID manually, use the following command:
prooidrv -db sports -SV -S prosv02 -N TCP -m2
2. Connection Path:
---------------
Intersolv ODBC Driver
|
+-> Remote OID from the Progress product installed
|
+-> Progress Database in self service mode
3. Basic settings for the driver:
-----------------------------
Data source Name: RSSOID RMU Progress
Description: Remote OID + Remote database in self-service
Database Name: sports
User ID: (if you need one!)
OID/OIB Connection Options:
OID/OIB Location: Remote
Protocol: TCP
Service Name: prosv02
Host Name: host-machine
Database Connection Options:
Database Access Mode: Direct
Protocol:
Service Name:
Host Name:
Database Path: /usr1/tse/sha/81A/
Database Operating System: UNIX
4. Notes on this configuration:
---------------------------
- The service used to connect to a remote OID/OIB is 'prosv02'. It is
defined in the services files stored on the PC and on the remote
machine where the database is located.
- The host machine where the remote OID/OIB is running is named
'host-machine' and has been defined in the host file stored on the
PC where TCP/IP is installed.
- At the end of the Database Path, don't forget the '/'
Sebastien HAEFELE
(5 mar 1997)
Progress Software Technical Support Note # 16721