From: Neulinger, N. <nn...@ms...> - 2008-12-18 17:13:46
|
Added to SVN. -- Nathan ------------------------------------------------------------ Nathan Neulinger nn...@ms... Missouri S&T Information Technology (573) 341-6679 System Administrator - Principal KD0DMH > -----Original Message----- > From: Alexander 'Leo' Bergolth [mailto:le...@st...] > Sent: Thursday, December 18, 2008 11:10 AM > To: Michael Mraka; Alexander 'Leo' Bergolth; tora- > de...@li... > Subject: Re: [Tora-develop] Tora 2.0.0 cmake patch and Oracle (TNS) > problem > > On 11/18/2008 07:54 PM, Alexander 'Leo' Bergolth wrote: > >> % Besides, I'm experiencing a problem when trying to use > tnsnames.ora > >> % aliases with the new version: > >> % > >> % Before the first Oracle connection had been established, only > "Oracle > >> % (Instant Client)" is available in the "Connection provider" > select-box. > >> % "Oracle (TNS)" only appears after at least one connection has been > >> % established using "Oracle (Instant Client)". > >> > >> I also use tnsnames.ora services and do not experience such > behavior. Could > >> you provide more details or even reproducible case? > > > > Hmm - strange. > > Without further debugging I can only tell you that after starting > tora, > > the "Connection provider" select box contains only "Oracle (Instant > > client)" (and maybe "MySQL"). "Oracle (TNS)" is missing. > > After a first Oracle connection is established, the "New connection" > > dialog now shows an additional entry "Oracle (TNS)". > > This behavior is always reproduceable on all of my boxes. > > > > I'll do further investigations tomorrow, if that information doesn't > > give you the clue... > > The Problem is that tora checks, if the environment variable > ORACLE_HOME > is set before offering the 'Oracle (TNS)' connection provider: > > -------------------- 8< -------------------- > toNewConnection::toNewConnection( > [...] > if (s == "Oracle") > { > Provider->addItem(ORACLE_INSTANT); > if (getenv("ORACLE_HOME")) > Provider->addItem(ORACLE_TNS); > -------------------- 8< -------------------- > > For Oracle-Instantclient installations, ORACLE_HOME does not have to be > set: > > http://www.oracle.com/technology/tech/oci/instantclient/index.html > -------------------- 8< -------------------- > Oracle Database Instant Client > > Instant Client allows you to run your applications without installing > the standard Oracle client or having an ORACLE_HOME. > -------------------- 8< -------------------- > > I've added a patch that removes the getenv check. > Connecting with TNS works fine for me now. > > Cheers, > --leo > -- > e-mail ::: Leo.Bergolth (at) wu-wien.ac.at > fax ::: +43-1-31336-906050 > location ::: Computer Center | Vienna University of Economics | Austria |