Ver 7-Problems connecting tables from databases on more than one serve

[modglin]

We have several different programs running, each on a different server. I have been having problems when going through the ODBC in connecting one table on server 1 with a table from server 2. I know part of my problem was that the fields where different lengths. I have worked on that problem. I do not have the message at this time, however, it was something about not being able to find one of the ODBC tables.

 

[dcm]

modglin: Be aware that if you are creating a join between tables on different servers you can only use 1 field to join between each table. If you need to create multi-column joins you need to look at using a subreport David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Crystal Decisions Enterprise Partner