Bernie,
You will need quite a bit more information to have a complete answer.
For instance, most databases have ODBC drivers that can easily be installed and will allow a direct connection to Rbase following ODBC / SQL standards. This is a function of the third party database driver, not Rbase.
However.... there are a number of third party applications that intentionally lock out all other developers but thier own. This is handled through the access control of the ODBC driver. For example, MAS90 uses a Performix database but they do not publish any ODBC drivers other than a "Read Only". So therefore you cannot do any data manipulation / updating only read access. So you must find
out what driver is available for this application.
So here is a brief recap of what needs to be done:
1: Obtain the ODBC driver for the Progress database.
2: Install a System ODBC datasource on your PC. If you
are using a Server based system, you will need to create a
server datasource as well with the driver.
3:In Rbase either use the Utility menu or the SConnect/Sattach
commands to connect to the ODBC datasource and tables.
I usually find the SConnect/Sattach commands give you the ability
to optimize your connection.
4: Depending on the capabilities of the ODBC driver, you should
now have access to the foreign database, (if not only read access),
as just another table in your Rbase table listing.
Then, the security features of the foreign database will take precedent.
For example, if a table has security on it that does not allow certain
users to access it, then this will still be in place. So you need to consider
this as well. Every ODBC driver has different options and capabilities.
Some will accept the default Windows user/password, others have settings
for buffers etc. while others are more simplistic and have no options at all.
The above is pretty simplistic, but feel free to contact me if I can be
of further assistance.
-Bob
-------------- Original message --------------
> Can we odbc to a Progress database.
> If so, what has to be done on the Progress side?
>
> Bernie Lis
>
