Driver prerrequisites

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 2
Joined: Thu 25 Aug 2011 11:40

Driver prerrequisites

Post by rlagares » Thu 25 Aug 2011 12:26


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

Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

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.

Post Reply