Direct Connect w/ tnsnames.ora

[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

[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.

[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

[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.

[jjonas]

Thanks, Stanislav. Excellent customer service - even if it doesn't happen.

Jason

[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

[Shalex]

Thank you for your suggestion. We will implement this feature as soon as possible. This functionality is not available at the moment.

[delarou]

Is this feature already implemented?

[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.

[delarou]

What is the status for this feature?

[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.

[delarou]

I keep trying
Any timeframe for implementing this feature?

[Pinturiccio]

Unfortunately this feature still isn't on our to do list, and no timeframe is available.