怎么设置System.Data.OracleClient.OracleConnection的连接字符串（很不好意思，我没有分了）？

[ncowboy]

我的数据库是10g的。

sid＝TSH；uid＝ncowboy；pwd＝1234qwer。服务器在192.168.103.1上。


（我也会碰到没有可用分的一天？！郁闷啊。）

[tonybaobao]

从工具栏里面拖一个OracleConnetion，用向导连接，不就可以得到ConnetionString了嘛

[thinkingforever]

[C#]
public void CreateOracleConnection()
{
string myConnString = "Data Source=Oracle8i;Integrated Security=yes";
OracleConnection myConnection = new OracleConnection(myConnString);
myConnection.Open();
MessageBox.Show("ServerVersion: " + myConnection.ServerVersion
+ "\nDataSource: " + myConnection.DataSource);
myConnection.Close();
}

[hfbw]

public void CreateOracleConnection()
{
string myConnString = "Data Source=Oracle8i;Integrated Security=yes";
OracleConnection myConnection = new OracleConnection(myConnString);
myConnection.Open();
}
哈，msdn文档都不看

[ncowboy]

我用的是oracle odp.net的例子;
using System;
using System.Data;
using System.Text;
using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types;

namespace Sample1
{
/// <summary>
/// Sample 1: Demonstrates how an populate and obtain LOB data
/// from a DataSet.
/// </summary>
class Sample1
{
/// <summary>
/// The main entry point for the application.
/// </summary>
static void Main(string[] args)
{
// Connect
string constr = "User Id=scott;Password=tiger;Data Source=lacl-001";
OracleConnection con = Connect(constr);

// Setup the table & Data
Setup(con);

// Create the OracleCommand
OracleCommand cmd = new OracleCommand("select story from multimedia_tab");
cmd.Connection = con;
cmd.CommandType = CommandType.Text;

// Create the OracleDataAdapter
OracleDataAdapter da = new OracleDataAdapter(cmd);

// Populate a DataSet
DataSet ds = new DataSet();
try
{
da.FillSchema(ds, SchemaType.Source, "Media");

// Populate the DataSet with LOB data
da.Fill(ds, "Media");

// Obtain LOB data from the database and print it out
Console.WriteLine(ds.Tables["Media"].Rows[0]["story"]);
}
catch (Exception e)
{
Console.WriteLine("Error: {0}", e.Message);
}
finally
{
// Dispose OracleCommand object
cmd.Dispose();

// Close and Dispose OracleConnection object
con.Close();
con.Dispose();
}
}

/// <summary>
/// Wrapper for Opening a new Connection
/// </summary>
/// <param name="connectStr"></param>
/// <returns></returns>
public static OracleConnection Connect(string connectStr)
{
OracleConnection con = new OracleConnection(connectStr);
try
{
con.Open();
}
catch (Exception e)
{
Console.WriteLine("Error: {0}", e.Message);
}
return con;
}

/// <summary>
/// Setup the necessary Tables & Test Data
/// </summary>
/// <param name="connectStr"></param>
public static void Setup(OracleConnection con)
{
StringBuilder blr;
OracleCommand cmd = new OracleCommand("", con);

blr = new StringBuilder();
blr.Append("DROP TABLE multimedia_tab");
cmd.CommandText = blr.ToString();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine("Warning: {0}", e.Message);
}

blr = new StringBuilder();
blr.Append("CREATE TABLE multimedia_tab(thekey NUMBER(4) PRIMARY KEY,");
blr.Append("story CLOB, sound BLOB)");
cmd.CommandText = blr.ToString();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine("Error: {0}", e.Message);
}

blr = new StringBuilder();
blr.Append("INSERT INTO multimedia_tab values(");
blr.Append("1,");
blr.Append("'This is a long story. Once upon a time ...',");
blr.Append("'656667686970717273747576777879808182838485')");
cmd.CommandText = blr.ToString();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine("Error: {0}", e.Message);
}
}
}
}

[ncowboy]

C:\Oracle\product\10.1.0\Client_1\ODP.NET\samples\LOB\bin\Debug>Sample1.exe
Error: ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
Warning: 必须为此操作打开连接
Error: 必须为此操作打开连接
Error: 必须为此操作打开连接
Error: ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

C:\Oracle\product\10.1.0\Client_1\ODP.NET\samples\LOB\bin\Debug>


我看了n处文档，都是含糊的写个‘Data Source＝’之类的。我实在搞不懂这个datasource的意思。

[Ganz]

string strConn = "user id=ganzrpt;password=xxx;data source=pxoracle;";

ganzrpt:用户名
xxx:密码
pxoracle:服务名

[ncowboy]

问题解决，data source＝‘服务名_主机地址’的格式。