Error in Database connection C# -> OracleDB

Question

I try to connect to an OracleDB from an c# project.

SqlConnection thisConnection = new SqlConnection(
"Server=127.0.0.1:3306;Database=db1;User id=abc;Password=psw;");

While running the code an exeption is thrown:

A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll
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 Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

I tried to connect with an local mysql db either and the same exeption is thrown.
I can connect to the server with the Oracle SQL developer tool.

Where is the Problem ?

OracleDB using SqlConnection ???. You know SqlConnection is for SQL Server — Habib
– Habib, Commented Jul 9, 2014 at 14:23

Community · Accepted Answer · 2017-05-23 10:30:04Z

2

You are using a SqlConnection (SQL Server) to connect to an Oracle database. See this answer on how to connect to an Oracle database:

https://stackoverflow.com/a/12568350/2382032

As Flindeberg points out, here is the NuGet link:

https://www.nuget.org/packages/odp.net.managed/

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered Jul 9, 2014 at 14:24

Eric Scherrer

3,4091 gold badge21 silver badges35 bronze badges

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

4 Comments

flindeberg Over a year ago

Eh, no, that is the unmanaged driver, don't use that one. Since about a year back they have a managed driver (ie .NET).

Eric Scherrer Over a year ago

The answer I link to has a link to the same place as your answer, oracle.com/technetwork/topics/dotnet/index-085163.html. Thanks though, I will update my answer with the nuget link. I wish they had NuGet back in the day when I had to connect to Oracel!

user3820836 Over a year ago

Now I can connect to the server but the login fails. Do I have to surround the pasword with special chars or does it work like this: "User ID=username;Password=asd;....."?

Eric Scherrer Over a year ago

Every example I see here does not surround it with quotes: connectionstrings.com/oracle

Satwik Nadkarny · Accepted Answer · 2014-07-09 14:47:07Z

1

You are using SqlConnection class. This class is used to connect to Microsoft's SQL Server database.

Since the database you're making use of is Oracle's database, you'll need a 'Oracle' specific connection class.

You can make use of OracleDBConnection class though this is not advisable as it has been deprecated.

Instead, you can make use of ODP.NET which is provided & supported by Oracle.

Hope this helps!!!

edited Jul 9, 2014 at 14:47

answered Jul 9, 2014 at 14:24

Satwik Nadkarny

5,1432 gold badges26 silver badges41 bronze badges

3 Comments

Eric Scherrer Over a year ago

Note this method of connecting has been depreciated: msdn.microsoft.com/en-us/library/77d8yct7.aspx

christof13 Over a year ago

System.Data.oracleClient has been deprecated

Satwik Nadkarny Over a year ago

Thanks for pointing that out. I had forgotten it had been deprecated. Have edited my answer accordingly!!!

flindeberg · Accepted Answer · 2014-07-09 14:36:13Z

0

You are using the connector for MS SQL server, don't do that. The only driver you should use for the Oracle Managed ODP.NET driver which you can get at NuGet. Documentation is available here.

Make sure to use the managed driver, and not the unmanaged one.

Example of using it:

var connection = new OracleConnection(str);
using (var command = new OracleCommand(commandStr, connection))
{
   // do stuff with command
}

edited Jul 9, 2014 at 14:36

answered Jul 9, 2014 at 14:29

flindeberg

5,0471 gold badge27 silver badges37 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:26:42Z

0

Try using ODP.Net Driver from NuGet.

Follow the instruction here:
Connect to oracle from c#

edited May 23, 2017 at 12:26

CommunityBot

11 silver badge

answered Mar 10, 2017 at 3:17

Kent Aguilar

5,4081 gold badge36 silver badges21 bronze badges

Collectives™ on Stack Overflow

Error in Database connection C# -> OracleDB

4 Answers 4

4 Comments

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related