No Client

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
jop
Posts: 8
Joined: Thu 11 Nov 2004 21:12

No Client

Post by jop » Mon 31 Jan 2005 22:21

How to configure an DbSettings.ini file to load at app start with the Oracle Net option in TCRSQLConnection?
I get an Error:
"Windows Socket error: Inavlid address in context (10049), on API connect."
than pressing F9 another:
EOraError: NET: "Invalid Host"

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Tue 01 Feb 2005 10:21

You must specify DataBase parameter as the following. You must enter ::, where
is taken from SERVICE_NAME parameter in tnsnames.ora.
For example DataBase='server:1521:orcl920'

Code: Select all

ORA920 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl920)
      (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES=100)
(DELAY=1))
    )
  )

Guest

Re: No Client

Post by Guest » Fri 10 Jun 2005 13:14

Testing...
jop wrote:How to configure an DbSettings.ini file to load at app start with the Oracle Net option in TCRSQLConnection?
I get an Error:
"Windows Socket error: Inavlid address in context (10049), on API connect."
than pressing F9 another:
EOraError: NET: "Invalid Host"

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Fri 10 Jun 2005 13:35

Possibly you write the wrong value to DataBase parameter of TSQLConnection. Please ReadMe.html about "DataBase" for "Oracle Net (Core Lab)" connection

Post Reply