Kbase 16719: Intersolv ODBC V2.5: Local OID + Remote DB in multi-user
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Intersolv ODBC V2.5: Local OID + Remote DB in multi-user
This is a Datasource sample for an Intersolv V2.5 ODBC driver
configuration with a local OID running in multi-user mode against a
progress remote database accessed via a TCP server running 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
(-H is not needed because this is running in the host machine)
2. Connection Path:
---------------
Intersolv ODBC Driver
|
+-> Local OID from the Progress product installed
|
+-> Remote Progress Database Sever
|
+-> Progress Database
3. Basic settings for the driver:
-----------------------------
Data source Name: LOID RMU Progress
Description: Local OID + Remote database in multi-user mode
Database Name: sports
User ID: (if you need one!)
OID/OIB Connection Options:
OID/OIB Location: Local
Protocol: WIPC
Service Name: blah-service
Host Name:
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 named 'blah-service' is only here for syntax checking.
It can be replaced by any string.
- The service used to connect to a remote server is 'prosv01'. 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 database is located is named
'host-machine' and has been defined in the host file stored on the
PC where TCP/IP is installed.
Sebastien HAEFELE
(5 mar 1997)
Progress Software Technical Support Note # 16719