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


Groups > comp.lang.clipper.visual-objects > #12730 > unrolled thread

Connection for Oracle 10g

Started bynhidris1957@gmail.com
First post2019-12-15 23:51 -0800
Last post2019-12-16 15:04 +0100
Articles 3 — 3 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#12730 — Connection for Oracle 10g

Fromnhidris1957@gmail.com
Date2019-12-15 23:51 -0800
SubjectConnection for Oracle 10g
Message-ID<f060c055-e1f3-47b2-ba47-567cb759f934@googlegroups.com>
Hi, Anyone knows the connection string to connect to an Oracle 10g database ? And the dll involved.

Thank you.

Nor Hashim Idris

[toc] | [next] | [standalone]


#12731

FromSherlock <sherlock@sherlock.com.au>
Date2019-12-16 04:00 -0800
Message-ID<549507d6-d453-489e-b39e-d626dceb9356@googlegroups.com>
In reply to#12730
Nor Hashim Idris

Try ;  https://www.connectionstrings.com/oracle/

[toc] | [prev] | [next] | [standalone]


#12732

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2019-12-16 15:04 +0100
Message-ID<h5ph7vF9mgbU1@mid.individual.net>
In reply to#12730
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


-- 

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web