I'm using the Crystal Reports ODBC driver. I was able to get it working by editing the crystal reports sql query and removng the reference to a catalog. ie
was:
SELECT
EMP1."ENAME", EMP1."JOB", EMP1."MGR"
FROM
"SYSTEM"."EMP"."POLITE" EMP1
to:
SELECT
EMP1."ENAME", EMP1."JOB", EMP1."MGR"
FROM
"SYSTEM"."EMP" EMP1
Nat