Oracle 10g Forms Builder cannot access/connect database

25 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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 !

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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 ?
    68,405 pointsBadges:
    report
  • PXE
    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...
    25 pointsBadges:
    report
  • carlosdl
    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.
    68,405 pointsBadges:
    report
  • PXE
    Thank u very much Carlosdl.. Both Form Builder and VB6 are working fine now..... no probs Thank u guys...
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following