OraFAQ Forum: Forms » How to connect 10g db with 10g forms & report?

Home » Developer & Programmer » Forms » How to connect 10g db with 10g forms & report? (oracle 10g,form 10g,report 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to connect 10g db with 10g forms & report? [message #329288]

Tue, 24 June 2008 23:07

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Hi

In my local pc i have 10g database as well as D2K.
How to configure to connect the database in forms and reports.

please guide me.

Thanks in advance.

Kanish

Report message to a moderator

Re: How to connect 10g db with 10g forms & report? [message #329305 is a reply to message #329288]

Wed, 25 June 2008 00:19

Frank
Messages: 7901
Registered: March 2000

Senior Member

It is no different from connecting to any other database, whether it is on your local machine or on a server in a lan or whatever.
Make sure you have your local db in the tnsnames.ora used by Forms and Reports.

Report message to a moderator

Re: How to connect 10g db with 10g forms & report? [message #329306 is a reply to message #329288]

Wed, 25 June 2008 00:25

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

hi

Thanks

# tnsnames.ora Network Configuration File: E:\DevSuiteHome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = muthukumarasamy)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = PLSExtProc)
    )
  )

This my tns file.

what changes should i want to do. to make connection

kanish

Report message to a moderator

Re: How to connect 10g db with 10g forms & report? [message #329312 is a reply to message #329306]

Wed, 25 June 2008 01:02

Frank
Messages: 7901
Registered: March 2000

Senior Member

Check the tnsnames.ora in the ORACLE_HOME for your database.

Report message to a moderator

Re: How to connect 10g db with 10g forms & report? [message #329323 is a reply to message #329288]

Wed, 25 June 2008 01:38

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

hi frank

below is my database tns file

# tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORA10G =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.9.200.4)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ora10g)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

kanish

Report message to a moderator