Linking two separate databases

[rewob65]

Hi I am trying to link two databases one in MS SLQ and one in pervasive. I have found where I have a common key say:-
A100 A200 in both databases, however one is a string of 20 and the other of 8. Is there anyway to return the data from both ie at the most basic have a report:-

SQL Pervasive
A100 A100
A200 A200


Thanks

David

 

[synapsevampire]

If you have CR 9 or above, select Add Command under the SQL Server database connection and create a command object as the erver datasource and cast the datatype to the same size if that's the issue.

select field1, field2, cast(field3 as varchar(8)) as field3 from table

Now you should be able to join without issue.

-k

 

[rewob65]

Hi

Yes I have Crystal 9, but I am struggling with your syntax. The two fields I want to link are:-


IASE__I4Contract_Hea.ACCTCustomer_account

and

CONTACT2.UINVCODE

The respective databases are called "Wwear" and "Goldmine"

The Wwear is on pervasive while Goldmine is on Sqlserver

Can you show me how I should put it in the command?


Thanks