[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1253
  • Last Modified:

Opening a PDF from Oracle Forms 6

Hi all.

I've got this somewhat outdated application made from Oracle Forms 6 and using Oracle DB 8.

I've exported the db to another server (running ORA DB 9.2), and modified tnsnames.ora and sqlnet.ora on the clients to point to this server. The application is able to detect the new server/db and works fine.

However, there's a part of the program that displays a list of PDF files located in a folder on the old server. Double clicking on an item on the list will open the file.

Now, I've copied the files to the new server (exact same folder location), but everytime I click on the list the program looks for the file on the old server.

I've checked the db, and the list of pdf files does not include the files' locations, just their names. So is there a file or setting somewhere that has to be changed?

Thanks in advance.
0
sis5
Asked:
sis5
2 Solutions
 
gmyersCommented:
You may need to look into the form coding.
It is likely that the Form is running a client application to open the PDF and is simply supplying a file location which is using some drive mapping to the original server.
0
 
Mark GeerlingsDatabase AdministratorCommented:
Do you have the *.fmb files for the application and a copy of the Forms6 Designer?  If so, open the *.fmb and look through the program units and triggers for the procedure that opens the PDF files, change that to the new server name, then compile a new *.fmx file.  If you don't have the *.fmb files or Forms Designer, you may be able to set up an alias in your network (possibly in a router) so that requests for the old server name get re-directed to the new server.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now