Dear All,

I have a problem where I would like to use the Microsoft Oracle ODBC driver
(version 2.73.726900 that come with Data Access Components 1.5) with Crystal
Reports 6.0.  I have a simple report joining two tables via a single column,
however the Cruystal Reports creates a join that looks like:

SELECT
    table1."column1", table1."column2", table1."column3", table1."column4",
    table2."trans_type"
FROM
    { oj "schema1"."table1" table1 INNER JOIN "schema1"."table2" table2 ON
        table1."column4" = table2."column4"}
ORDER BY
    table1."column1" ASC,
    table1."column2" ASC

While this syntax in theory should work.  Unfortunately the ODBC driver does
not support the INNER JOIN syntax (only the LEFT and RIGHT OUTER JOIN) -
although Crystal thinks it does.  When the Intersolv drivers are used the
join looks like:

SELECT
    table1."column1", table1."column2", table1."column3", table1."column4",
    table2."trans_type"
FROM
   "schema1"."table1" table1, "schema1"."table2"
WHERE
        table1."column4" = table2."column4"
ORDER BY
    table1."column1" ASC,
    table1."column2" ASC

Does anyone have any ideas on the best way to work around this INNER JOIN
problem while keeping the Microsoft drivers for Oracle?  Is this a problem
with Crystal Reports or the Microsoft Oracle ODBC driver?

Also are there any plans for Microsoft to release level 3.0 compliant
drivers for Oracle?

Thanks,

Allan Taunt

Global Information Solutions
Christchurch
New Zealand.

Hi Allan,

This is a known problem to Seagate.  E-mail them at

can forward to you.

The problem deals with how this DLL works with ODBC 3.  It doesn't use
the proper equal join syntax and this new DLL should fix it.

As a side note, I keep hearing about Microsoft's Oracle driver and would
like to try it.  If you know where I can find it, I'd be very much
appreciate it.

--
Sincerely,
Brian Dong

Please remove nospam from the address to reply.

Allan-

Oracle used the plus operator "(+)" for outer joins, rather than SQL
Servers star "*", but it works the opposite way.  For example, T1.C *= T2.C
is equal to T1.2 = T2.C (+).

Craig Buchanan
Certified Crystal Reports Consulting
+1 (612) 649-4947