Crystal ODBC Connection Error

Yahoo Archive
1
Hello Chris:

If you have not yet set up your ODBC drivers, there are 2 Answerbooks
on the Epicor EpicWeb site to get you started.

Here is the link to Answerbooks:
https://epicweb.epicor.com/Support/MyEPICweb/Pages/SearchAnswerbooks.a
spx

This Yahoo site breaks links, so you may need to paste the entire
link into Word in order to patch it before pasting it into your
browser address bar.

You need AnswerBook # 1266BRK "ODBC Instructions for setting up
Progress ODBC connection - V8.03.4xx".

And you may want AnswerBook # 5947MPS "CR Bypass the login ID and
prompt for a Crystal Report using an ODBC connection."

After your ODBC connection is set up, then open up Crystal Reports.
Create a New Blank Report.
Create New Connection.
ODBC.
Select the DataSource name of your Vantage 8 Progress database.
Type the password (sysprogress).
Click on Mfgsys.
Click the + next to Pub.
Begin selecting tables.
When you are finished selecting tables, press OK.
Re-do the links in Crystal Database Expert because they will probably
be wrong.
Click OK.

Keep in mind that there are many performance and security reasons to
avoid using ODBC for your Crystal/Vantage reports. If your ODBC
reports use few and small tables, performance may not be a problem
for you; but there will still be additional security concerns that
will be more difficult to deal with. You will need to apply
additional security over and above the security already applied in
Vantage.

Hope this helps.

Lynn




--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...>
wrote:
>
> Hi,
>
> How do you connect to ODBC from Crystal. I can connect to an xml
but I cant connect using an ODBC string as I dont know how to.
>
> I need to connect a Crystal report to our Vantage Progress DB, but
there isnt a xml file available and never will be.
>
> Thanks,
>
>
>
>
> ________________________________
> From: adam.whipp <adam.whipp@...>
> To: vantage@yahoogroups.com
> Sent: Wednesday, November 19, 2008 6:25:00 PM
> Subject: [Vantage] Crystal ODBC Connection Error
>
>
> I occasionally receive the following error from Crystal when
developing
> reports through ODBC:
>
> Failed to retrieve data from the database.
> Details: HY00:[DataDirect] [ODBC Progress OpenEdge Wire Protocol
Driver]
> [OPENEDGE]SQL engine Statement Mgr statement cache overflowed. 15
> statements currently in use (chst free_lru cache). (9799) [Database
> Vendor Code: -210048 ]
>
> Has anyone seen this before? It seems to happen after I "refresh"
> several times. I have to exit Crystal and come back in, and then it
is
> fine for a while again. It's almost like Crystal isn't letting go
of
> each query, and eventually some buffer gets full. Thanks in advance
> for any help.
>
> Adam Whipp
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
I occasionally receive the following error from Crystal when developing
reports through ODBC:

Failed to retrieve data from the database.
Details: HY00:[DataDirect][ODBC Progress OpenEdge Wire Protocol Driver]
[OPENEDGE]SQL engine Statement Mgr statement cache overflowed. 15
statements currently in use (chst free_lru cache). (9799) [Database
Vendor Code: -210048 ]

Has anyone seen this before? It seems to happen after I "refresh"
several times. I have to exit Crystal and come back in, and then it is
fine for a while again. It's almost like Crystal isn't letting go of
each query, and eventually some buffer gets full. Thanks in advance
for any help.

Adam Whipp
3
Hi,

How do you connect to ODBC from Crystal. I can connect to an xml but I cant connect using an ODBC string as I dont know how to.

I need to connect a Crystal report to our Vantage Progress DB, but there isnt a xml file available and never will be.

Thanks,




________________________________
From: adam.whipp <adam.whipp@...>
To: vantage@yahoogroups.com
Sent: Wednesday, November 19, 2008 6:25:00 PM
Subject: [Vantage] Crystal ODBC Connection Error


I occasionally receive the following error from Crystal when developing
reports through ODBC:

Failed to retrieve data from the database.
Details: HY00:[DataDirect] [ODBC Progress OpenEdge Wire Protocol Driver]
[OPENEDGE]SQL engine Statement Mgr statement cache overflowed. 15
statements currently in use (chst free_lru cache). (9799) [Database
Vendor Code: -210048 ]

Has anyone seen this before? It seems to happen after I "refresh"
several times. I have to exit Crystal and come back in, and then it is
fine for a while again. It's almost like Crystal isn't letting go of
each query, and eventually some buffer gets full. Thanks in advance
for any help.

Adam Whipp






[Non-text portions of this message have been removed]
4
Most of our Sales Reports access the data using ODBC - saves the
Sales people actually logging on/using Vantage.

We had huge problems using ODBC directly with Progress at the start -
v8.00.8##. It seemed as though Progress or the ODBC driver couldn't
handle the level of data and grouping we were putting through it.

We finally decided to use a DTS to copy the Vantage data from
Progress into MS-SQL every night and run our reports off that.
Haven't had any problems since. I don't remember the actual error we
were getting, but that could be your problem.


Though, to more directly answer you query, I have found when
modifying Vantage layouts - invoices, statements, etc. - that Crystal
does NOT release XML file data. I have to close the document and re-
open if I want to change the XML file that I'm previewing. I don't
get errors, just the wrong data.

HTH,

Nigel.



--- In vantage@yahoogroups.com, "adam.whipp" <adam.whipp@...> wrote:
>
> I occasionally receive the following error from Crystal when
developing
> reports through ODBC:
>
> Failed to retrieve data from the database.
> Details: HY00:[DataDirect][ODBC Progress OpenEdge Wire Protocol
Driver]
> [OPENEDGE]SQL engine Statement Mgr statement cache overflowed. 15
> statements currently in use (chst free_lru cache). (9799) [Database
> Vendor Code: -210048 ]
>
> Has anyone seen this before? It seems to happen after I "refresh"
> several times. I have to exit Crystal and come back in, and then
it is
> fine for a while again. It's almost like Crystal isn't letting go
of
> each query, and eventually some buffer gets full. Thanks in
advance
> for any help.
>
> Adam Whipp
>
5
You may need to check your ODBC configuration in the Progress Explorer
set up for ODBC. You may be able to get some help from Technical
Services about the number of servers, etc that should be set.



We had an issue when we first went to Vantage 8.0 with multiple
connections to ODBC at the same time and had to change some
configuration settings on the ODBC setup to make sure we were allowing
sufficient number of connections.



Jerry Rodden

Asst. Manager - MIS

Cardington Yutaka Technologies Inc.

575 West Main Street

Cardington, OH 43315

Phone: 419-864-8777 ext. 6209

Fax: 419-864-7771

Email jrodden@...





[Non-text portions of this message have been removed]