oracle connection String with C# using oledb

Question

Im developing an application in C# that connects to Oracle 10g.

When I use ODP. Net and this

Connection String "Data Source=Angelo-HP/XE;User ID=MAPFRE;Password=123456" I can connect and perform any action with the database,

but when I use OleDbConnection (System.Data.OleDb) with this

connection String: "Provider=OraOLEDB.Oracle;OLEDB.NET=true;PLSQLRSet=true;User ID=mapfre;password=123456;Data Source=XE" I got this error:

ORA-12154: TNS:could not resolve the connect identifier specified

When I try use Open() method from OleDbConnection.

I think is not oracle configuration because I can connect from ODP and sqldeveloper client.

Any idea?

Thanks,

Do you have the tns names setup correctly on your oracle client? %oraclehome%\network\admin — RLS
– RLS, Commented Oct 6, 2012 at 2:51
Your DataSource value is different in both connection string examples. — rs.
– rs., Commented Oct 6, 2012 at 2:56

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

Try the connection strings at the link below:

CommunityBot

11 silver badge

answered Oct 6, 2012 at 3:19

Jace

1,54910 silver badges21 bronze badges

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

Comments

Kumar · Accepted Answer · 2015-10-14 16:43:34Z

0

This issue may occur if you have multiple versions of oracle on your computer.

try these steps

go to network folder of oracle and open tnsnames.ora
search for the your DB name (XE in this case)
this will have your data source information (EX : (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(Host = xx.xx.xx.xx)(Port = xxxx)))(CONNECT_DATA =(SERVICE_NAME = XP))))
use this in Data source field of your connection string . (EX: Data Source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(Host = xx.xx.xx.xx)(Port = xxxx)))(CONNECT_DATA =(SERVICE_NAME = XP)));")

also, make sure your solution was built in anyCPU mode and make sure in App Pool enable 32 bit is true

answered Oct 14, 2015 at 16:43

Kumar

581 silver badge8 bronze badges