Home » Developer & Programmer » Forms » How to connect 10g db with 10g forms & report? (oracle 10g,form 10g,report 10g)
How to connect 10g db with 10g forms & report? [message #329288] Tue, 24 June 2008 23:07 Go to next message
mm_kanish05
Messages: 487
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
Re: How to connect 10g db with 10g forms & report? [message #329305 is a reply to message #329288] Wed, 25 June 2008 00:19 Go to previous messageGo to next message
Frank
Messages: 7880
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.
Re: How to connect 10g db with 10g forms & report? [message #329306 is a reply to message #329288] Wed, 25 June 2008 00:25 Go to previous messageGo to next message
mm_kanish05
Messages: 487
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
Re: How to connect 10g db with 10g forms & report? [message #329312 is a reply to message #329306] Wed, 25 June 2008 01:02 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Check the tnsnames.ora in the ORACLE_HOME for your database.
Re: How to connect 10g db with 10g forms & report? [message #329323 is a reply to message #329288] Wed, 25 June 2008 01:38 Go to previous messageGo to next message
mm_kanish05
Messages: 487
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
Re: How to connect 10g db with 10g forms & report? [message #329328 is a reply to message #329323] Wed, 25 June 2008 02:11 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Reread my comment.
I really really hope you are able to figure out what to do next..
Re: How to connect 10g db with 10g forms & report? [message #329333 is a reply to message #329288] Wed, 25 June 2008 02:38 Go to previous message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Thank Frank

I got it.

kanish
Previous Topic: Master/detail tables, restricting adding in detail table
Next Topic: How to achieve data saving while tab change.
Goto Forum:
  


Current Time: Wed Dec 07 08:33:42 CST 2016

Total time taken to generate the page: 0.11358 seconds