Driver prerrequisites

rlagares · Post by **rlagares** » Thu 25 Aug 2011 12:26

Hello,

I am just starting to work with this driver(with C#), but I have a doubt.

If I wanted to connect using tnsnames services in the connection string I asume that I will need to install Oracle Client to can use tnsnames.ora(please tell me if I am wrong). But the question is, if I use Direct connection in teh connection string would I need to install Oracle client(or any other Oracle component like ODP or something like this) to work with the driver or is not necessary?

Thank you in advance

StanislavK · Post by **StanislavK** » Fri 26 Aug 2011 13:00

You should be able to specify the server description explicitly in the connection string, e.g.

Code: Select all

User Id = Scott; Password = tiger; Server = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host)(PORT = 1521)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = service_name)));

Feel free to contact us if you encounter any problems with this.