Accessing oracle database from c# with odb.net

Question

I'm trying to access Oracle 11g DB. According to connectionstring.com , the connstring should be :

Driver={Oracle in OraClient11g_home1};Dbq=myTNSServiceName;Uid=user;Pwd=passwd;

Anyhow I'm getting an ArgumentException: 'Driver' is not a valid word.

Thank you.

Greetings

R. Bada

tpeczek · Accepted Answer · 2012-11-07 14:40:59Z

3

It looks like you are trying to use connection string which is suitable in case of ODBC drivers for Oracle.

You should look for connection string suitable for ODP.NET in Oracle Data Provider for .NET / ODP.NET section. The best is to use one of the following:

Data Source=TNSServiceName;User Id=user;Password=passwd;

or

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=user;Password=passwd;

The first is suitable when you are using TNS, the second allows you to provide the service definition in connection string.

answered Nov 7, 2012 at 14:40

tpeczek

24.2k3 gold badges78 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user897237 Over a year ago

Thank you for reply. I have no tnsnamesnames file... So I would like to describe the service. But what should I put in MyOracleSID?

tpeczek Over a year ago

@user897237 The service_name may or may not be the ORACLE_SID. It is setup via the init.ora file with the "service_names" parameter. You can check this parameter by: select name, value from v$parameters where name like 'service%. Also remember that in case of second connection string other forms of Oracle Host String are acceptable.

Collectives™ on Stack Overflow

Accessing oracle database from c# with odb.net

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related