SqlConnection.Open throws error when trying to connect to Oracle server

Question

I am trying to connect to Oracle database on my local machine. I have Visual Studio 2013 and Oracle Express 11g.

Here's my c# code:

    String str =
        "Data Source=localhost;" +
        "Initial Catalog=XE;" +
        "User Id=system;" +
        "Password=12345;";
        SqlConnection conn = new SqlConnection(str);
        conn.Open();

However it throws an exception:

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Additional information: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL

Does anybody know what's going wrong?

SqlConnection is the SQL Server specific provider - it doesn't work with Oracle ... — marc_s
– marc_s, Commented Jul 28, 2015 at 16:09

Christian Phillips · Accepted Answer · 2015-07-28 16:13:12Z

1

Check your provider, as I commented above....

Taken from Oracle Web Site...

string oradb = "Data Source=(DESCRIPTION="
             + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)(PORT=1521)))"
             + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));"
             + "User Id=***;Password=***;";

OracleConnection conn = new OracleConnection(); 
conn.ConnectionString = oradb;
conn.Open();

You may want to look at ConnectionStrings.com to help with which suits you best.

answered Jul 28, 2015 at 16:13

Christian Phillips

18.8k8 gold badges55 silver badges85 bronze badges

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

Comments

Chris Dunaway · Accepted Answer · 2015-07-28 16:09:22Z

0

The problem is that you're trying to use the classes in the System.Data.SqlClient namespace with Oracle. SqlClient is only for Sql Server. You need to use either an Oracle .Net provider or the classes in the System.Data.OleDb namespace.

answered Jul 28, 2015 at 16:09

Chris Dunaway

11.2k4 gold badges40 silver badges52 bronze badges

Collectives™ on Stack Overflow

SqlConnection.Open throws error when trying to connect to Oracle server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related