请问在ASP.NET里面怎样链接Oracle的数据库？

[p_zyh]

我直接用OledbConnection进行链接
结果发生Access Denied的错误
请问应该怎样处理？
谢谢！

[Hackson]

Oracle OLE DB 的 VB.NET 程序:
Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String = _
"Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User ID=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()

[p_zyh]

我是这样写的，但是就是链接不上
我试了一下，写成winform的程序就没有问题
在asp下就是Access Denied
是不是有什么设置要改啊？

[活靶子哥哥]

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

namespace Application ////命名空间
{
/// <summary>
/// DataSystem 的摘要说明。
/// </summary>
public class DataSystem
{
private String connstr;
private OracleConnection conn=new OracleConnection();

public DataSystem() //构造函数，里面有链接字符串
{
connstr="Data Source="";User ID="";Password="";Integrated Security=no;";
}

public DataSystem(String connstr) //构造函数2
{
this.connstr=connstr;
}

public String ConnStr
{
set{this.connstr=value;}
}

/// <summary>
/// 执行存储过程，返回DataSet
/// 参数procedure为存储过程名
/// </summary>
/// <param name="procedure">存储过程名称</param>
/// <returns>DataSet对象</returns>
public DataSet executeProcedure(String procedure) //这就是一个方法拉
{
return execute(procedure,0);
}

public DataSet executeSql(String sql) //执行查询的方法
{
return execute(sql,1);
}

/// <summary>
/// 执行Sql语句或者存储过程，
/// 当参数type为0时为存储过程，为1时为直接运行Sql语句
/// 返回DataSet
/// </summary>
/// <param name="procedure">存储过程名</param>
/// <param name="type">类型</param>
/// <returns></returns>
private DataSet execute(String procedure,int type)
{
DataSet ds=new DataSet();
OracleConnection conn=new OracleConnection();
try
{
//建立连接
conn.ConnectionString=connstr;
conn.Open();//打开连接

OracleDataAdapter comm=new OracleDataAdapter();
comm.SelectCommand=new OracleCommand();
//设置参数
comm.SelectCommand.Connection=conn;
comm.SelectCommand.CommandText=procedure;
if (type==0)
comm.SelectCommand.CommandType=CommandType.StoredProcedure;
comm.Fill(ds);//将结果加入dataSet对象
}
catch(Exception ex)
{Console.Write(ex.ToString());}
finally
{
conn.Close();//连接关闭
}
return ds;
}
}

}

[jiezhi]

注意用戶的權限。

[孟子E章]

http://www.csdn.net/Develop/read_article.asp?id=16437

[standy]

账号，密码，Server Address

[zhoumins]

Dim SqlStr As String = "Select * From tablename"
Dim ConnStr As String = "provider=MSDAORA.1;Password=tiger;UserID=scott;Data Source=bnt"
Dim Da As New OleDbDataAdapter(SqlStr, ConnStr)
Dim Ds As New DataSet()
Da.Fill(Ds,"mytablename")

[BugBuilder]

OLE DB CONNETION 是万能的

Oracle是专用的　就和ＳＱＬ一样　这些东东效率较高

[likika]

拿这段代码测试一下：
<%@ Page Language="vb" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

sub Page_Load(obj as object, e as eventargs)
dim MyConnString as string
dim strSel as string
Dim MyConn As OleDbConnection
dim MyCmd As OleDbCommand
dim MyReader As OleDbDataReader

'连接语句
MyConnString = "Provider=MSDAORA;data source = engei; User ID=dev; Password=dev;"
strSel = "select * from staff_info"

MyConn = new OleDbConnection(MyConnString)
MyCmd = New OleDbCommand(strSel, MyConn)

MyConn.Open()
MyReader = MyCmd.ExecuteReader()

if not MyReader is nothing then
DataGrid1.DataSource = MyReader
DataGrid1.DataBind()
MyReader.Close
end if
end sub