I have two databases (each with a table that I need to join together.) One is a SQLServer db and the other is an Oracle db. In the first case, the employee number is an integer and in the second the employee number is a string. When I link the two tables together based upon the emp# field, I receive an error. How can I work around this problem?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DATA TYPES ARE NOT COMPATIBLE 1
- Thread starter Salthead
- Start date
-
1
- #2
synapsevampire
Programmer
Either databse can link to the other directly (not using Crystal), or you can use a subreport for one table and create a formula which converts either the numeric or the character to the other and link on those, or you can use MS Access and LINK (not import) the tables into Access, join the fields and create an Access query for use by Crystal.
-k
-k
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question