Kbase 19230: How to connect into multiple remote Databases via SQL89 ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/11/1999 |
|
Title :How to connect into multiple remote Databases via SQL89 ODBC
KnowledgeBase number: 19230
Modified Date: 03/11/99
This document applies to: Merant 3.50-32 BIT PROGRESS
Version and Release Number: Progress 8 32 BITS
INTRODUCTION:
============
ODBC client is able to connect into a multiple remote Databases if :
1. All Databases are located on a unique Directory (on the same machine)
2. The OIB (Open Interface Broker) has been started on the machine where all Databases are located.
PROCEDURAL APPROACH:
====================
- Start all Databases on the server (i.e : proserve db1, proserve db2, proserve db3)
- Start the OIB/OID on the same machine as the Databases
(i.e on NT : OIBRKR32 -SV -S <oib-service>
- On the client machine, from ODBC Administrator, configure the Datasource on specifying the following :
General
Data Source Name : Mytest
Description : Mydescription
Database Name : db1
UserID : userid (if necessary)
OIB/OID Options
Protocol : TCP
Service name : oib_service_name
Host Name : hostname of the Database
Database options
Database Access Mode : Direct
Protocol :
Service name :
Host Name :
Database Path : Full Path of Database
Database Operating system: Select the Operating system of the Database
Advanced
Database list : db2.db db3.db (SPACE as separator)
Apply all changes and try the connection
REFERENCES TO WRITTEN DOCUMENTATION:
====================================
System Administration Reference
KB 17775, 16723
jmr (03/11/99)