Solved

Opening a PDF from Oracle Forms 6

Posted on 2004-08-08
5
1,241 Views
Last Modified: 2008-02-01
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
Comment
Question by:sis5
5 Comments
 
LVL 5

Accepted Solution

by:
gmyers earned 125 total points
ID: 11749154
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
 
LVL 35

Assisted Solution

by:Mark Geerlings
Mark Geerlings earned 125 total points
ID: 11751086
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question