Oracle DB connection with c# failed

Question

I've installed Oracle DB on another pc(A) and trying to establish the connection from my pc(B). Now when I'm trying to debug the application I get this error- "[DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection."

    public void InsertionTest()

    {            
        string cmdText = @"Insert into O_TEST_TABLE (ID,Name,MOBILE) Values (4, 'rD','798984');";
        string ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["HR"].ConnectionString;

        using (OleDbConnection con = new OleDbConnection(ConnectionString))// "Provider=SQLOLEDB; DATA SOURCE=172.16.1.220:1521/orcl;PASSWORD=hr;PERSIST SECURITY INFO=True;USER ID=hr"))
        using (OleDbCommand cmd = new OleDbCommand(cmdText, con))
        {
            con.Open();

            int rowsUpdated = cmd.ExecuteNonQuery();
            if (rowsUpdated == 0)
            {
                Console.WriteLine("Failed!!!");
            }
            else
            {
                Console.WriteLine("Success.");
            }
        }           
    }

In my web config file, the connection string is-

<connectionStrings>
    <add name="HR" connectionString="Provider=SQLOLEDB;Initial Catalog=HR;DATA SOURCE=172.16.1.13:1521/orcl;PASSWORD=hr;PERSIST SECURITY INFO=True;USER ID=hr; OLEDB.NET=True " /> 
</connectionStrings>

It looks like you are trying to use an MS SQL Server connection string to connect to the Oracle database. Did you look at the examples on connectionstrings.com? — Ron Beyer
– Ron Beyer, Commented Feb 13, 2018 at 5:23

G_S · Accepted Answer · 2018-02-13 05:27:29Z

1

I feel provider should be Provider=OraOLEDB.Oracle

answered Feb 13, 2018 at 5:27

G_S

7,1302 gold badges27 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Oracle DB connection with c# failed

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related