OraFAQ Forum: Precompilers, OCI & OCCI » Can We Connect to remote ORACLE database ?

Home » Developer & Programmer » Precompilers, OCI & OCCI » Can We Connect to remote ORACLE database ?

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

Can We Connect to remote ORACLE database ? [message #116564]

Wed, 20 April 2005 11:31

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

Report message to a moderator

Re: Can We Connect to remote ORACLE database ? [message #117083 is a reply to message #116564]

Sun, 24 April 2005 16:47

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

Report message to a moderator

Previous Topic:	Write into PDF
Next Topic:	How to execute the "select * from tablename" ;

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 17 22:38:47 CST 2024