连接Oracle时出错,请帮忙看看.

[myaspcool]

我在asp.net中用下面代码访问Oracle数据库时出现如下错误:
Server Error in '/NewNet' Application.
--------------------------------------------------------------------------------

Unable to load DLL (oci.dll).
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.DllNotFoundException: Unable to load DLL (oci.dll).

Source Error:


Line 111: OracleConnection conn=new OracleConnection();
Line 112: conn.ConnectionString = "user id=Tim;data source=timdb;password=aspcool;";
Line 113: conn.Open();
Line 114: string sSql = "select * from THREADS";
Line 115: OracleCommand comm=new OracleCommand(sSql,conn);


Source File: g:\wwwroot\newnet\login.aspx.cs Line: 113

Stack Trace:


[DllNotFoundException: Unable to load DLL (oci.dll).]
System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction)
System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction)
System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact)
System.Data.OracleClient.OracleConnection.Open()
NewNet.Login.btnLogin_Click(Object sender, EventArgs e) in g:\wwwroot\newnet\login.aspx.cs:113
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()


我在winform中用同样得代码时正确得,但是在asp.net中却不行,我想可能是asp.net得访问权限不够,请大虾指点解决方法,不甚感激.代码如下:

OracleConnection conn=new OracleConnection();
conn.ConnectionString = "user id=Tim;data source=timdb;password=aspcool;";
conn.Open();
string sSql = "select * from THREADS";
OracleCommand comm=new OracleCommand(sSql,conn);

OracleDataReader reader=comm.ExecuteReader();
Response.Write(reader.GetInt32(0));
conn.Close();
Response.End();

[老譚山菜]

gz!

[darein]

你的连接参数有问题，Oracle数据库的连接方法有以下几种情况：
Oracle
ODBC

New version:
"Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;"


Old version:
"Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;"


OLEDB, OleDbConnection (.NET)

Standard security:
"Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"
This one's from Microsoft, the following are from Oracle
Standard Security:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;"


Trusted Connection:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"


OracleConnection (.NET)


Standard:
"Data Source=Oracle8i;Integrated Security=yes";
This one works only with Oracle 8i release 3 or later
Declare the OracleConnection:

C#:
using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "my connectionstring";
oOracleConn.Open();

VB.NET:
Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "my connectionstring"
oOracleConn.Open()


Data Shape


MS Data Shape:
"Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Data Source=orac;user id=username;password=mypw"

[jeffio]

利用c#: using System.Data.OracleClient;
using System.Data.OleDb;

string oracleconnstring="Data Source=..;User Id=..;Password=..";
OracleConnection conn=new OracleConnection(oracleconnstring);
string sql="select * from THREADS"
OracleDataAdapter oradap=new OracleDataAdapter(sql,conn);
DataSet ds=new DataSet();
oradap.Fill(ds,"表名");
conn.Close();
利用vb类似，就是你需要把名称空间导入！