querying two databases

[er123]

I am trying to create an SQL command within Crystal Reports for two Progress databases. Is it possible to query two databases in Progress SQL? I keep getting error messages. I am using Progress 10.1 if that matters. Thanks.

 

[Casper]

yes, it is possible provided the databases are on the same machine.
You have to use the -mdbq parameter in the dsn and configure the connection at the server.
Look at KB P119452 for detailed information: http://progress.atgnow.com/esprogress/Group.jsp?bgroup=progress&id=P119452


Regards,

Casper