Kbase 16722: Intersolv ODBC V2.5: Remote OIB + Remote DB in client-server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Intersolv ODBC V2.5: Remote OIB + Remote DB in client-server
This is a Datasource sample for an Intersolv V2.5 ODBC driver
configuration with a remote TCP OID/OIB running in client-server 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 TCP -S prosv01
You also need to start a Progress OIB or a Progress OID on the same
machine. The OIB can be started by using the following command on your
remote machine:
prooibrk -SV -S prosv02
If you have any problem to start the OID or the OIB, see the 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 -S prosv01 -N TCP -H host-machine
-SV -S prosv02 -N TCP -m2
2. Connection Path:
---------------
Intersolv ODBC Driver
|
+-> Remote OID from the Progress product installed
|
+-> Progress Database Server
|
+-> Progress Database
3. Basic settings for the driver:
-----------------------------
Data source Name: ROID RMU Progress
Description: Remote OID + Remote database in client-server
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: Via Server
Protocol: TCP
Service Name: prosv01
Host Name: host-machine
Database Path:
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 OID/OIB is running.
- 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.
- The service used to connect to a remote server is 'prosv01'. It is
defined in the services files stored on the machine where the databa
database is located, and on the machine where the OID/OIB is running
(if those two machines are different).
- The host machine where the remote database is located is named
'host-machine' and has been defined in the host file stored on the
PC where TCP/IP is installed. The host machine can be an other
machine than the one where the OID/OIB is running.
Sebastien HAEFELE
(5 mar 1997)
Progress Software Technical Support Note # 16722