Oracle DBA Forum - Как подключиться к БД Oracle с помощью C# .NET

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

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

using System;
using System.Data;
using System.Data.OracleClient;

namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{

string oracleDbConnection = "Data Source=(DESCRIPTION="
+ "(ADDRESS_LIST="
+ "(ADDRESS="
+ "(PROTOCOL=TCP)"
+ "(HOST=192.168.1.9)"
+ "(PORT=1521)"
+ ")"
+ ")"
+ "(CONNECT_DATA="
+ "(SERVER=DEDICATED)"
+ "(SERVICE_NAME=ORCL)"
+ ")"
+ ");"
+ "User Id=system;Password=master;";

OracleConnection connnection = new OracleConnection(oracleDbConnection);

try
{
connnection.Open();

Console.WriteLine("OK!");

}

catch (OracleException ex)
{
if (connnection.State != ConnectionState.Open)
{
Console.WriteLine("Failed");

}

Console.WriteLine(ex.Message);

}

finally
{

connnection.Close();
connnection.Dispose();

}

Console.ReadKey();

}

}
}

Для подключения к БД Oracle с правами sysdba или sysoper, необходимо установить дополнительные библиотеки odp.net

После установки библиотек, PL/SQL Developer перестал подключаться к базам данных. Помогло копирование всех файлов *.dll из каталога client_1 в каталог client_1\bin

Книги по теме (легко найти в интернете):

Oracle Database 10g Development with Visual Studio 2005 and the Oracle Data Provider for .NET
http://www.exforsys.com/reviews/book...de-review.html

Pro ODP.NET for Oracle Database 11g
http://apress.com/book/view/9781430228202

================================================== ===========



using System;

using System.Data;





//Namespace for ODP.Net classes



using Oracle.DataAccess.Client;



//Namespace for ODP.Net Types



using Oracle.DataAccess.Types;









namespace ConsoleApplication1

{



    public class dbConnection 

    

    {



        public Boolean getDBConnection()

        {



            try

            {



                //Connection Information



                string oracleDbConnection = "Data Source=(DESCRIPTION="

                                                                           + "(ADDRESS_LIST="

                                                                                   + "(ADDRESS="

                                                                                   + "(PROTOCOL=TCP)"

                                                                                   + "(HOST=10.32.11.95)"

                                                                                   + "(PORT=1521)"

                                                                                   + ")"

                                                                           + ")"

                                                                           + "(CONNECT_DATA="

                                                                                   + "(SERVER=DEDICATED)"

                                                                                   + "(SERVICE_NAME=test)"

                                                                           + ")"

                                                                    + ");"

                           + "User Id=sys;Password=master;DBA Privilege=SYSDBA;";







                //Connection to datasource, using connection parameters given above



                OracleConnection conn = new OracleConnection(oracleDbConnection);







                //Open database connection



                conn.Open();



                return true;



            }



            // Catch exception when error in connecting to database occurs



            catch (Exception ex)

            {



                //Display error message



                Console.WriteLine(ex);                                

                return false;



            }



        }

           

    }









    class Program

    {

        static void Main(string[] args)

        {



            dbConnection conne = new dbConnection();





            if (conne.getDBConnection())

            {

                Console.WriteLine("OK");



            }



            else 

            {



                Console.WriteLine("НЕТ");

            }

            



            Console.ReadKey();



        }



    }

}