CODEWITHSUNDEEP
asp.netdatabaseoracle-database
Abdullah Qudeer
Abdullah Qudeer

Reputation: 989

Connect to oracle 9i database in c# from remote desktop

How can I get data from oracle 9i database in c# from remote desktop in asp.net application?

The asp.net application will be deployed on one server and Oracle Database on another.

How can I communicate both servers to get data from Oracle Database.

I tried this

string oradb = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=StaticIPAddressOfOracelServers)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=serviceName)));User Id=Administrator;Password=pass;";
OracleConnection conn = new OracleConnection(oradb);
conn.Open();

and I get this exception:

ORA-03111: Break received on communication channel

Upvotes: 2

Views: 1328

Answers (1)

wfang2002
wfang2002

Reputation: 11

ODP.NET, Managed Driver supports connecting to Oracle DB server 10.2 or higher. It does not support 9i as stated in this post.

Upvotes: 1

Related Questions