[RBG7-L] - Re: Multiple Databases in One Directory

[Emmitt Dove]

To expand on Gunnar's reply, and assuming that you are in an EEP, you will 
have to use SCONNECT/SATTACH to accomplish what you wish.

Before you can use these commands you must establish a system DSN for the 
datasource.  Once the datasource is established, try working through the 
menus once (Utilities/Connect SQL Datasource) to show yourself that you can 
establish such a connection.  Then, for instance, if you set up a system 
DSN for concomp you could:

        SCONNECT concomp IDENTIFIED BY NONE
        SATTACH contact USING custid
Then the contact table would be available from within your database.  Note 
that if you have STATICDB on, the SATTACH will be temporary.

Hi All,
I am back to work after a long trip around the
country and needing help already.
It old version I was able to use CONN <otherdb>
from within my program.  Now in 7.1, I am getting
the following error message:
Illegal command in Entry/Exit Procedure.
Two databases reside in the same directory.
The main database is almost always in use.
However sometimes the user needs to look into
the secondary database for archived data.
I think using SATTACH or SCONNECT would be better
than disconnecting from the main database in some cases,
but I am not getting these commands to work.
However, there are cases where I need to be connected to
the secondary database only, such as to load in a new form.
How do I now get into that secondary database from within
my codelocked application?
Thanks for help.
Sharon Lima
Emmitt Dove
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT  06611
(203) 673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]