Re: How do I use 2 DB at once?

In article <4p7jjj$s5c@powatana.jcpenney.com>, jschumac@uns-dv1 (Joel Schumacher) says: > >I'm using Online 7.x with 6.x tools. > >Database AAA exists on machine alpha. Database BBB exists on machine beta. > >My application runs on machine alpha and has database AAA open. It needs >to get data from database BBB on machine beta, without closing the database. > >The DBPATH lets me open either database from alpha. But, when I try to do >a statement in the form "SELECT * FROM bbb:anytable", I get the following >errors: > 329: Database not found or no system permission. > 111: ISAM error: no record found.> >If I change it to the form " SELECT * FROM bbb@beta_engine_name:anytable", >it works just fine. > Have you tried setting up a synonym in database AAA for the table in database BBB ?