Page 1 of 1
Direct Connect w/ tnsnames.ora
Posted: Thu 13 Jan 2011 23:07
by jjonas
Howdy,
Just downloaded a trial and skimmed through the docs, but couldn't find a way to connect directly (Direct=True) to Oracle AND specify a tnsnames.ora file in which to find the other connect information.
Is there a way to do this? Something like:
Home=C:\oracle\product\11gR2\client_32;
Direct=true;
Server=devods.world;
User Id=dispatch;
Password=***;
Pass Parameters By Name=true;
Thanks.
Jason
Posted: Fri 14 Jan 2011 15:30
by StanislavK
In the Direct mode, Oracle client software is not used to connect to the Oracle server. Therefore, tnsnames.ora entries cannot be used in the connection string. Instead, the host and SID of the Oracle server should be specified:
Code: Select all
Direct=true;
Server=[DNS name or IP of the machine where the Oracle server resides];
SID=[the SID parameter from the 'devods.world' entry in tnsnames.ora];
User Id=dispatch;
Password=***;
Pass Parameters By Name=true;
Please tell us if this helps.
Posted: Fri 14 Jan 2011 17:52
by jjonas
It certainly answers the question.
Just because we choose to take advantage of connecting directly, that shouldn't preclude dotConnect from taking advantage of a tnsnames.ora file that may be on the system for other purposes/applications. Granted, the information doesn't change often, but when it does there are now at least two places to make updates rather than one.
No worries. We can certainly work around it. Thanks for the reply.
Jason
Posted: Mon 17 Jan 2011 13:55
by StanislavK
Thank you for your suggestion, we will consider implementing the possibility of using tnsnames.ora entries in the Direct connection mode. We will inform you about the results here.
Posted: Mon 17 Jan 2011 21:09
by jjonas
Thanks, Stanislav. Excellent customer service - even if it doesn't happen.
Jason
Posted: Thu 18 Aug 2011 10:24
by delarou
Just to note that we are also interested in this feature to take the tnsnames.ora file into account in direct mode!
Is there any update about this?
Thanks,
Christoph
Posted: Fri 19 Aug 2011 10:29
by Shalex
Thank you for your suggestion. We will implement this feature as soon as possible. This functionality is not available at the moment.
Re: Direct Connect w/ tnsnames.ora
Posted: Tue 28 Aug 2012 15:43
by delarou
Is this feature already implemented?
Re: Direct Connect w/ tnsnames.ora
Posted: Fri 31 Aug 2012 12:31
by Pinturiccio
The feature of using tnsnames.ora entries in the Direct connection mode is not implemented yet. We are investigating the possibility to implement this feature, but we can't tell any timeframe at the moment.
Re: Direct Connect w/ tnsnames.ora
Posted: Thu 28 Nov 2013 12:49
by delarou
What is the status for this feature?
Re: Direct Connect w/ tnsnames.ora
Posted: Fri 29 Nov 2013 13:44
by Pinturiccio
We are investigating the possibility to implement using tnsnames.ora entries in the Direct connection mode, but we can't tell any timeframe at the moment.
Re: Direct Connect w/ tnsnames.ora
Posted: Mon 06 Oct 2014 11:06
by delarou
I keep trying
Any timeframe for implementing this feature?
Re: Direct Connect w/ tnsnames.ora
Posted: Wed 08 Oct 2014 13:56
by Pinturiccio
Unfortunately this feature still isn't on our to do list, and no timeframe is available.