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

Easysoft ODBC-Oracle Driver

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

Article :	00751
Last Reviewed :	19th July 2005
Revision :	1

When Crystal Reports performs joins it adds "{oj 'sql syntax' }" to the syntax e.g.

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

The problem with this was that the Easysoft Oracle Driver did not ignore or 'strip' this from the syntax thus causing the error. This was fixed in Easysoft ODBC-Oracle Driver V1.3.

Applies To

Products
- Easysoft ODBC-Oracle Driver

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

Easysoft ODBC-Oracle Driver

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

Applies To

Knowledge Base Feedback