Memo Field in CE10 causes Query Engine Error 2

[mgpeters]

Any time I attempt to use a memo field in a report that runs on CE10, it fails with a "Query Engine Error". I've stripped down my report to eliminate everything but the memo field and 1 string field. No grouping, no formulas, no selection formula. It runs fine from Crystal Reports 10. I'm connecting via ODBC to an Oracle database.

Why is this happening and more importantly, how can I fix it?

Thanks,
Mark

 

[Turkbear]

HI,
Switch to the Oracle Server ( the native one) connection, not ODBC - At the very least, use Crystal's ODBC not Oracle's , but the native connection is the way to go..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

There are different methods for connecting to Oracle via ODBC, keep in mind that drivers are key to Oracle connectivity. If you are using ODBC to begin with, that's a bad idea, use the Native connectivity (listed as Oracle Server), but if you insist upon slowing the report by using Oracle, then use the Crystal supplied Oracle ODBC driver, not Oracles or anyone elses, it causes various errors.

-k

 

[Turkbear]

HI,
One further note, Oracle does not have Memo fields ; depending on version, they are LONG, LONG RAW, CLOB, BLOB, etc..) -

Not just nitpicking, precision in describing an issue helps in getting good advice..

Basic Info Needed:
Version of Crystal being used
Operating System
Database used and its version
Connectivity Type








To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[mgpeters]

Thanks Turkbear & synapsevampire. Currently I'm using the Cyrstal ODBC driver for Oracle. I'll try the direct connection and see if that resolves the problem.

Turkbear - Thanks for the guidance in posting a question. This was my first. Here is the info you requested...

Version of Crystal being used - 10
Operating System - NT
Database used and its version - Oracle
Connectivity Type - CR Oracle ODBC Driver 4.20

 

[mgpeters]

Opps, didn't include Oracle version number is prev post.

Oracle 10g

 

[mgpeters]

Changed to direct Oracle connection & it works great!

Thanks!

 

[Turkbear]

Hi,
That can be important ( especially with Oracle, since they love incremental patches..so it your 10g just 10g or 10g R2?)

Check out synapse's excellent FAQ about what to include with posted questions:
faq149-3762





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[mgpeters]

Not sure about what patch we are on. I'll have to find that out.

Thank you both very much for you help in answering this question and advice on best practices for posting questions.

 

[synapsevampire]

Don't worry about the patch, the issue was connectivity, and you should have recognized an improvement in performance as well.

-k

 

[fancyface]

I am having the same sort of problem. Where do I go to change to the direct connection?

 

[synapsevampire]

Use the menu Database->Set Location.

This assumes that you're using ODBC to Oracle.

-k

 

[fancyface]

I am using ODBC but the comment was to change to direct Oracle connection. I don't see it in my data sources. All I have is my ODBC.

 

[synapsevampire]

It's listed as Oracle Server.

Depends on whether it was installed, and also that the Oracle client was installed PRIOR to Crystal, and you should post your software version and Oracle client version.

-k

 

[mgpeters]

Go to Create New Connection - Oracle Server. You'll be prompted for service name, user id & pw. For service name use the "Server Name" from your ODBC connection and the same id & pw. I recommend adding it to your favorite connections then.

I've seen numerous benefits since switching to direct connect including:
- Memo fields work in CE
- Tremendous speed improvement
- No need for ODBC driver

Good luck

 

[fancyface]

Thankyou mgpeters. I'll give it a try.

 

[fancyface]

MGPeters, I don't have the Oracle Connection available....

 

[mgpeters]

See synapsevampire's note above about the need for the Oracle client to be installed before Crystal. You may want to consider uninstalling Crystal, making sure the Oracle client is properly installed and then re-installing Crystal