logo标签列表

连接字符串 - Oracle

c#oracledatabase-connectionconnection-string
3

我需要使用C#连接Oracle服务器，以下是连接字符串所需参数：

服务器名: dbs.cs.hacettepe.edu.tr 端口号: 1521 SID: ORAVT

请问这些参数对应的连接字符串是什么？我尝试了很多方式连接但是一直不成功。顺便提一下，我使用的是ODP.NET。

感谢您的帮助。

http://www.connectionstrings.com/oracle/ - Habib
我尝试了这个，但没有生效。字符串 oraDB = “(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dbs.hacettepe.edu.tr)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORAVT)));User Id=********;Password=*******”; - mekafe
另一个有用的链接：https://www.connectionstrings.com/net-framework-data-provider-for-oracle/ - Phil3992
1个回答
2

web.config

    <configuration>
        <appSettings>
            <add key="connectionString" value="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dbs.cs.hacettepe.edu.tr)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORAVT))); User Id=YOUR_USER_HERE; Password=YOUR_PASS_HERE;"/>
        </appSettings>
    </configuration>

clsConn.cs

    using System;
    using System.Collections.Generic;
    using System.Text;
    using System.Data;
    using System.Data.Common;
    using Oracle.DataAccess.Types;
    using Oracle.DataAccess.Client;
    namespace Data
    {
       public class Data
        {
            public  OracleConnection GetConnection()
            {
                string connection = System.Configuration.ConfigurationManager.AppSettings["connectionString"].ToString();

                return new OracleConnection(connection);
            }


            public DataTable ExecuteCmd()
            {
                OracleConnection cn = new OracleConnection();
                OracleCommand dbCommand = cn.CreateCommand();
                DataTable oDt = new DataTable();

                cn = GetConnection();

                dbCommand.CommandText = "pckClient.spr_Client";
                dbCommand.CommandType = CommandType.StoredProcedure;

                try
                {
                    dbCommand.Connection = cn;

                    dbCommand.Parameters.Add(new OracleParameter("cCursorData", 
                    OracleDbType.RefCursor, ParameterDirection.Output));

                    OracleDataAdapter oDa = new OracleDataAdapter(dbCommand);

                    oDa.Fill(oDt);

                    return oDt;


                }
                catch (Exception ex)
                {
                    if (cn.State == ConnectionState.Open)
                    {
                        cn.Close();
                    }
                    dbCommand.Dispose();
                    cn.Dispose();
                    throw ex;

                }
                finally
                {
                    if (cn.State == ConnectionState.Open)
                    {
                        cn.Close();
                    }
                    dbCommand.Dispose();
                    cn.Dispose();

                }
            }
        }
    }
网页内容由stack overflow 提供, 点击上面的
可以查看英文原文，
原文链接