Home » Developer & Programmer » Precompilers, OCI & OCCI » Can We Connect to remote ORACLE database ?
Can We Connect to remote ORACLE database ? [message #116564] Wed, 20 April 2005 11:31 Go to next message
wxuf
Messages: 9
Registered: April 2005
Junior Member
Here Remote means another PC on network, such as a server ?

Are there this kind of OCI ?
I can't find them.

wxuf
Re: Can We Connect to remote ORACLE database ? [message #117083 is a reply to message #116564] Sun, 24 April 2005 16:47 Go to previous message
Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...
Senior Member

Hi,

Yes is the answer to your question.

Technically you achieve this, after creating the OCI environment and creating the handles, you the issue the OCIserverAttach function with the TNS names of your database, set the username and password attributes of the OCIsession handle and issues OCISessionBegin to allocate the session and server handles to the service context handle.

The TNS names of your database is in your $ORACLE_HOME/network/admin/tnsnames.ora file, if you don't have an entry you will need to create it.

Read the manuals at http://technet.oracle.com

Kind regards,
Michael Hartley, http://www.openfieldsolutions.co.uk
Previous Topic: Write into PDF
Next Topic: How to execute the "select * from tablename" ;
Goto Forum:
  


Current Time: Mon Aug 03 06:54:03 CDT 2020