Home » RDBMS Server » Networking and Gateways » Re: Borland Database Engine Connection
Re: Borland Database Engine Connection [message #66332] Tue, 09 April 2002 04:22
Marco Rodrigues - Brazil
Messages: 2
Registered: April 2002
Junior Member
Hi.
I had this error.
I have two programs here. One in forms (newer), and other in (older) delphi.
When i used the tnsnames configured for the new i got this error.
The new program used ".world"

TNSNAMES.ORA:

# FORMS PROGRAM.
MV2000.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 128.127.1.135)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)

#DELPHI
DB_ORACLE.world #<- THIS WAS THE PROBLEM. IT DOESNT WORK WITHOUT THE ".WORLD" =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = NANCI_NT)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)

I HAD TO PUT THE ".WORLD" CAUSE THE NEW "SQLNET.ORA" THE FORMS PROGRAM NEEDED, HAD THIS PARAMETER:
names.default_domain = world

PLEASE, SEND ME FEEDBACK IF THIS SOLVES YOUR PROBLEM!
Previous Topic: Oracle 9i to oracle 8.1.6, connectivity..
Next Topic: Re: ORA-01861: literal does not match format string
Goto Forum:
  


Current Time: Thu Apr 18 07:21:38 CDT 2024