RE: Crystal Reports and the IdiotManager(TM)

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Mon, 10 May 2004 13:19:37 -0500
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E9393A@qtiexch2.qgraph.com>

(2nd try -- e-mail hosing up again)

I don't think it's necessarily the tool, but the ODBC driver. Case in = point: Our users can create ad hoc MS Access (The Access of Evil) = queries and reports against our ERP system (don't bother arguing). One = particular report ran in "a few minutes", but after an MDAC "upgrade" = was taking hours. After a little snooping using Quest's Spotlight tool, = I saw that the new improved query was FTSing each table, probably to do = the joining in the Access "database" itself. I've also seen this when a = user moved from WinNoT to WinTuke, even though the version of MS Orifice = didn't change.

In our case, there have been two possible solutions. Since our Oracle = tables are generally linked in Access (as opposed to a make table = query), I've had the user drop all Oracle tables and relink them. If = that doesn't work, the DB must be manually recreated. If there's = another way, no one else seems to know what it is.

GL!

I'm Rich Jesse, and I approve of this message.

Rich Jesse                        System/Database Administrator
rich.jesse_at_quadtechworld.com      QuadTech, Sussex, WI USA

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> Sent: Friday, May 07, 2004 10:23 PM
> To: oracle-l_at_freelists.org
> Subject: RE: Crystal Reports and the IdiotManager(TM)

>=20
>=20

> The problem with this tool and similar tools, is that they decide =3D
> sometimes to read the data and join it by itself (the tool does the =
=3D
> join) to some other data that is hosted by the tool or to some other =
=3D
> data that was read from Oracle in a previous step. What I do,=20
> is simply =3D
> creating an Oracle table to host the intermediate results, so=20
> that they =3D
> can get it done using the Oracle server.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon May 10 2004 - 13:29:26 CDT