Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #12732

Re: Connection for Oracle 10g

Path csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From "Wolfgang Riedmann" <wriedmann@gmail.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Connection for Oracle 10g
Date Mon, 16 Dec 2019 15:04:46 +0100
Lines 29
Message-ID <h5ph7vF9mgbU1@mid.individual.net> (permalink)
References <f060c055-e1f3-47b2-ba47-567cb759f934@googlegroups.com>
Mime-Version 1.0
Content-Type text/plain; charset=utf-8
X-Trace individual.net EErLEbV5x2ICDrRqMXeiHAd5for3DD6ihnRUCY18u49RXeUic=
Cancel-Lock sha1:lkqC7EULYRNMvTD8l4WdicWsasQ=
User-Agent XanaNews/1.18.1.6
Xref csiph.com comp.lang.clipper.visual-objects:12732

Show key headers only | View raw


Hello,

> Hi, Anyone knows the connection string to connect to an Oracle 10g
> database ? And the dll involved.

you need to install the Oracle Client.

Personally I'm using VO2Ado for the connection, and these connection
strings:

if lUseTNS
  cConnectString := "Provider=OraOLEDB.Oracle;Data Source=" + ;
    cTNSName + ";User Id=" + cUser + ";Password=" + cPassword + ";"
else
  cConnectString := "Provider=OraOLEDB.Oracle;" + ;
  "Data Source=(DESCRIPTION=(CID=GTU_APP)" + ;
  "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)" + ;
  "(HOST=" + cServer + ")(PORT=" + NTrim( nPort ) + ;
  ")))(CONNECT_DATA=(SID=" + cDB + ;
  ")(SERVER=DEDICATED)));User Id=" + cUser + ;
  ";Password=" + cPassword + ";"
endif


Wolfgang


-- 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

Connection for Oracle 10g nhidris1957@gmail.com - 2019-12-15 23:51 -0800
  Re: Connection for Oracle 10g Sherlock <sherlock@sherlock.com.au> - 2019-12-16 04:00 -0800
  Re: Connection for Oracle 10g "Wolfgang Riedmann" <wriedmann@gmail.com> - 2019-12-16 15:04 +0100

csiph-web