Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Oracle. How can i make connect to a remote host?

60 views
Skip to first unread message

Andrey Chumak

unread,
May 15, 2002, 8:05:51 PM5/15/02
to
Need sample connect string for connect to remote Oracle database.


Igor Belitsky

unread,
May 16, 2002, 10:03:43 AM5/16/02
to

"Andrey Chumak" <aka_...@ua.fm> wrote:
>Need sample connect string for connect to remote Oracle database.
>
>

To establish connection with remote host you have to define net service name on the local host. You can use Oracle "Net8 Assistant" or you can configure $ORACLE_HOME\NETWORK\ADMIN\tnsnames.ora file manually.

Here is an example of an entry for MYDATABASE database on SERVER_NAME remote host in the tnsnames.ora file:
#------------------------------------------------
MYDATABASE.SERVER_NAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_NAME)(PORT = 1521))
)
(CONNECT_DATA =
(SID = MYDATABASE)
(SERVICE_NAME = MYDATABASE.SERVER_NAME)
)
)
#------------------------------------------------

Following entry to the dbxconnections.ini will do the rest:

[Oracle]
BlobSize=-1
DataBase=MYDATABASE.SERVER_NAME
DriverName=Oracle
ErrorResourceFile=
LocaleCode=0000
Password=password
Oracle TransIsolation=ReadCommited
User_Name=user


0 new messages