Connecting a SQL ODBC to an Oracle ODBC in Crystal XI
I have 2 datasources. The main DSN is a File DSN and connects as PK1_RO. It is an ODBC for Oracle. The second DSN connects to a SQL ODBC that I created as a System DSN as PICKPRO.
I connect table1 (IM) of type Oracle to table 2 (Map) of type SQL on a part number. They do not have the same name (Oracle's field is IM_KEY and and SQL's field is ITEM_NUM).
The report contains the PK1_RO.dbo.IM.IM_Key and runs. When I add the PICKPRO.dbo.Map_ITEM_NUM field to the Details are (or any field from the MAP table) Crystal blows up and gives me a CRE EXE fatal error.
They are both ODBC's so they should connect. What am I doing wrong?