Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #12732
| 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
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