Home > IT Answers > Oracle > Oracle 10g Forms Builder cannot access/connect database
PXE
25 pts.
 Oracle 10g Forms Builder cannot access/connect database
Oracle, Oracle 10g, Oracle 10g Express, Oracle Form Builder, Windows XP SP2
Form Builder cannot connect to database. Table field linked but cannot fetch or update data to database. Server OS : Fedora 14: Oracle 10g Express Edition Client OS : Windows XP SP2: Oracle Client and Developer Canu guys help me plz...

Software/Hardware used:
Server OS : Fedora 14: Oracle 10g Express Edition Client OS : Windows XP SP2: Oracle Client and Developer
ASKED: March 12, 2011  4:33 AM
UPDATED: March 20, 2011  6:01 AM
RELATED QUESTIONS
Answer Wiki:
U may modify FEDORA_HOME/server/config/fedora.fcfg file and ensure that the datastore entry for Oracle points to the right host and database. The fedora.fcfg file that comes with the distribution uses a database on the local host called fedora20. When u start fedora, be sure to use the parameter "oracle", as in fedora-start oracle. While the server is running, it writes logs to FEDORA_HOME/server/logs. These are timestamped files, written in a simple XML format. It is best to use these logs to get more extensive information about what the server is doing or to diagnose problems. As Carlosdl written the more details help to resolve ur Q properly. If possible supply the exact error with error no and see the Log file and note the what errors r there !
Last Wiki Answer Submitted:  March 15, 2011  11:42 am  by  Subhendu Sen   22,035 pts.
All Answer Wiki Contributors:  Subhendu Sen   22,035 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Please clarify your question, and provide more details.

If you cannot connect to the database, of course you will not be able to fetch or update data.

Can you connect to the database ?
What errors are you getting ?
What troubleshooting steps have you taken so far ?

carlosdl
 63,535 pts.
 

Thnks for the intrest guys..

I’m a Network admin in an institution (RHCE). i have very less oracle knowledge but its my duty to configure Oracle Server in Fedora 14.

My needs..

Server OS: Fedora 14…. oracle-xe-univ……rpm installed with all dependancies
web ui access x.x.x.x:8080/apex

Client OS : Windows XP… oracle client installed for students..
All students uses user/user/xe as username/password/hoststring in SQL Plus..

My problems..
Table can be created and values are added in SQL Command line mode
But in VB6 and Oracle Form builder the data in the table is not displayed or updated..
ODBC setting are ok.. Test Connection returns Success…
I can’t figure out the problem as i hv no knowledge regarding oracle..

It will be helpfull if can give me a tutorial of configuring.. i can reinstall everything from first no problem…

thnks in advance guys…

Thnks to Carlosdl.. i referred ur explanations for many existing queries…. all fine…

PXE
 25 pts.
 

Hi PXE.

You don’t need ODBC to connect from Forms Builder. Look for a file called “TNSNAMES.ORA” in your Developer installation.

If you installed database client software and forms builder, there will be 2 instances of this file, and since you are able to connect and execute commands from SQL*Plus, one of your tnsnames files is correct, and that is most likely the one from the database client installation.

You should be able to copy it to the appropriate path in your developer installation, which should make Forms builder able to connect.

I would recommend fixing the Forms Builder connection first. When that is done, you can deal with the VB6 part.

Feel free to add more information/details or ask any question you may have.

carlosdl
 63,535 pts.
 

Thank u very much Carlosdl..

Both Form Builder and VB6 are working fine now….. no probs

Thank u guys…

PXE
 25 pts.