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.