Skip to Content
Former Member
Apr 21, 2008 at 03:23 PM

Linking tables from 2 different databases


Post Author: hokiegirl

CA Forum: Crystal Reports

I am trying to create a Crystal Report and pull data from an Oracle database and a Sybase database. One of the key fields I need to link on is defined dfferently on both. The Oracle DB field is defined as 'String(60)' and on the Sybase the field I want to link with is defined as 'number'. When I try and grab and link between the two in the Database Expert link section, I get an error: data types are not compatible". Does anyone have a way around this I can use? This is a link that I must have.