The Easysoft ODBC-Oracle Driver version 3.x is our fastest driver ever. Trial it free.

Why do I get error "[HY000] [Easysoft][Oracle]ORA-00911: invalid character at offset xxxx" when running Crystal Reports?

When Crystal Reports does JOINS, it adds { oj sql }; to the SQL statement. For example: 

SELECT RightTable.*, LeftTable.*
{ oj(FROM RightTable INNER JOIN LeftTable ON RightTable.RHS = LeftTable.LHS) }

Some versions of the Easysoft Oracle ODBC driver don't ignore or strip this entry, which causes the error. This was fixed in the Easysoft Oracle ODBC driver version 1.3.