ODBC driver problem - I think..

[kingz2000]

Hi,

I have crystal report X connected to some oracle linked tables in Access for reports. The reason is to change the customer_IDs and dates of the queries which I am making reports of. Now, since I installed Oracle Design on my computer, the connection of Crystal reports to Access is now a hell of a lot slower!! The weird thing is, when I try these queries from ms Access it works as fast as always.Now I am wondering how the crystal report is connected to access. Isn't through ODBC ?? Does it have anything to do with my tnsnames file??
Thanks for any help.

 

[Turkbear]

Hi,
Impossible to tell for sure
Since you already had an Oracle client installed when you installed Designer did you make sure it used a different Oracle Home?
If so, then you may have 2 tnsnames.ora files and need to set an environment variable called TNS_ADMIN to 'point' to the directory containing the tnsnames.ora file you want to use.

Since you have an Oracle client, why are you using Access linked Oracle tables and not the tables themselves? Much faster ( especially with a Native SqlNet connection).



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

 

[kingz2000]

I'm using Access to change the queries dedicated to the crystal reports dynamically using an Access front-end little program.

You know a better idea?

In my registry I do have tns_admin with a directory leading to a tnsmaes.ora file already. Do I need to change anything here??

 

[Turkbear]

Hi,
It depends on where in the registry tree it is located..If under the 'main' Oracle entry and not one of the HOME0, HOME1 ones it should work the same as using an environmental variable.( If you do have 2 homes and 2 tnsnames.ora files just keep them identical for good measure.) - It is unlikely, however, that this is why things got slow..

As to using Access vs directly building the reports against the Oracle data, you are the only judge of how practical that is..CR reports can 'write their own query' based on what table, fields, etc you include and what criteria you use for selection..Or you can revise your Access query to meet Oracle syntax needs and use it as a Command Object to build your report on.




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

 

[kingz2000]

HOME2 and HOME3 have the same path, ie same tnsnames.ora. .I don't have a HOME1 and in HOME0.

I didn't know CR reports could write or change their queires..How??

 

[Turkbear]

Hi,
When you create or modify a Crystal report, mostly what you are doing ( aside for layout and formatting options) is telling Crystal's parser what it needs to know for it to create a Sql Query to be sent to your datasource..
Try this: create a new report and just add a few fields from some table, add a simple record selection formula and then, using the Database..Show Sql option, you can see the query CR thinks is the one to use.

By the way,if you have HOME2 and HOME3 ( but no 0 or 1),it appears that 2 previous installs of an Oracle client ( or other Oracle product) have been incorrectly uninstalled - this can cause problems in some cases...








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