Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Opening a PDF from Oracle Forms 6

Posted on 2004-08-08
5
1,242 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.

808 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