Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #12730 > unrolled thread
| Started by | nhidris1957@gmail.com |
|---|---|
| First post | 2019-12-15 23:51 -0800 |
| Last post | 2019-12-16 15:04 +0100 |
| Articles | 3 — 3 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | nhidris1957@gmail.com |
|---|---|
| Date | 2019-12-15 23:51 -0800 |
| Subject | Connection 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]
| From | Sherlock <sherlock@sherlock.com.au> |
|---|---|
| Date | 2019-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2019-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