Query Engine Error: '220:Out of range'

Posted on 2004-09-23
Last Modified: 2008-01-16
I'm getting this error when I try refreshing all reports that connect to an Oracle db via Remedy ODBC.
We are on Crystal Reports 9 Advanced.
Question by:brooksmato
LVL 13

Accepted Solution

vidru earned 250 total points
ID: 12140168
LVL 100

Expert Comment

ID: 12142328

Author Comment

ID: 12155613
Dave, thanks for the quick response. This fixed the problem.
Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

LVL 13

Expert Comment

ID: 12155777
Great, glad to help.


Expert Comment

ID: 12413069
Can anyone point me where to find version of the crdb_odbc.dll?  I've contacted Crystal to no avail, installed from two different Crystal 9 distributions, 8.5, and the archived hot fixes and service packs.  Closest I've gotten is which doesn't solve the problem installing 10 has created.


<email address removed by mlmcc PE>
LVL 100

Expert Comment

ID: 12417786
Please ask your own questions.  

Also email contact is against EE rules.

As a start to your question.
Unistall CR10
Install your CR9 (original disks)
Install the service packs until you get the desired version.


Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
C# Crystal Reports 15 89
Crystal Reports Server, Unable to remove users 8 43
Help with a Crystal Report Formula 8 46
Summarizing a percent by a grouped category 14 25
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
In a recent question ( here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question