Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Wolfgang Riedmann" 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: References: 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 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 --