Crystal Reports Set Locations Data Explorer shows "no items found"

[oraclesql77]

3/29/06. I am the reports writer for the OCSC. I have 100 reports I have to have done by 5 pm 3/31/06, all based on 2 new reports with 2 new stored procedures. I have to use Set Location to connect the reports with the stored procedures, but it will not show me the tables and procedures for any of my DSNs.

I have tried to search the Business Objects knowledge base, Google and Yahoo for solutions, but I just get the basic information for setting location, which, as you can see below, won't work. Rebooting my pc and the server doesn't help. Converting the database driver doesn't help. Adjusting the DSNs hasn't helped. I have checked to make sure the DSNs match on my pc and on the server. The existing reports appear on our web site and run fine on the web and in Crystal on my pc. I can convert database drivers on existing reports without stored procedures fine. I can also use Verify Databse fine. The DSNs can connect to the databases when tested. I can log into both our databases through Oracle SQL*Plus and Toad, so I don't believe it is the TNSNAMES.ora, though I've tried several variations already just in case. So why won't the DSNs work when I need to set location? What else do I need to test?

I have had this problem since 3/6/06 right after we moved to a new building and changed our IP addresses of our servers. We've straightened out all our connectivity problems except for this one. When I pull up a report and need to set the location to a different stored procedure, I try to use Set Location as I had done many times before. However, now I only get "no items found" under teh DSN in Data Explorer instead of the list of tables and procedures. This is true for all my DSNs.

My options are set to see tables and procedures.

My DSNs are set with 'Procedure Returns Results'.

PLEEEASE HELP ME! We use CR8 and Oracle 8i, which are both no longer under technical support by their creators.

 

[synapsevampire]

It could be a permissioning problem, or you could have a mask set in the data explorer options preventing them from showing.

It sounds like you are using ODBC, which is a bad idea anyway as it's slower, change the connectivity to Oracle native (listed as Oracle under the data sources).

What happens when you do a Verify Database?

-k

 

[oraclesql77]

Thanks for your reply, synapsevampire! I appreciate the feedback.

Since I am trying to log as the database owner, I don't believe it is a permissions problem.

I've never heard of a mask on data explorer - I'll check that out. As stated above, the File-Options have both tables and stored procedures checked, which is all I need for now, but I can't even get that.

Yes, we have ODBC for now. We'll upgrade to native when we upgrade to CR XI in the near future. Well, maybe I'll give it another whirl.

Verify database and convert database driver run fine on existing reports. My problem is primarily with connecting new stored procedures and tables to existing or new reports.

 

[synapsevampire]

In the same options screen, there's a mask that can entered for filtering the data, one for something like server, the other for tables I think.

Otherwise I'm not sure why you wouldn't see them, however be careful which connectivity you use. You are NOT supposed to use the Oracle supplied ODBC drivfer (though it *can* work) as it will cause strange results, and in some cases, bad data.

Use either the native connectivity, or the Crystal supplied ODBC driver, that may be part of your issue as well.

-k

 

[oraclesql77]

I checked the options: there are no table or owner masks.

The DSNs I created use the CR Oracle8 driver, which I believe is the Crystal supplied driver. We're goind to try the native driver on a copy of a report (just in case).

Thanks again!

 

[synapsevampire]

Yeah, that's the Crystal driver.

I can't think of why they might not show up, you might try another tool such as MC Access, and use the Oracle supplied ODBC driver to LINK to the database and see if you can see any objects.

-k