Linking tables from 2 different databases

[Former Member]

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.

Thanks

[Former Member]

Post Author: amr_foci

CA Forum: Crystal Reports

there is something called heterogeneous services in oracle which allow you to make a DB link form oracle to any other databases, like Sybase, SQL Server, ,,,,etc,

or you can go to business views in Business objects,

good luck

[Former Member]

Post Author: Bas Wijne

CA Forum: Crystal Reports

Why dont you create a table in one of the databases that matches the type of the other one?(ie. create a 'String(60)' table in Sybase populated with the date from the Sybase 'number data')Should do the trick