try to give ASPNET account execute privileges to your Oracle home folder
解决方案 »
- Web.Config 1.1 与 2.0的继承问题
- Calendar1 选择日期时期时,总是出现看不到的现象。
- 非常简单的问题
- dataset查询后如何绑定到datagrid的问题(帮顶有分)
- asp.net如何从数据库中读取数据生成自定义的XML文件!高分请教?
- [提问]web控件开发:属性是一个类,在设计器中如何显示展开的子属性??
- Asp.net+Sql Server ,如何实现在页面上自动生成图表
- 快吞学了,为什么我安装的VS。NET不能运行?100分求元
- 真的是很简单的问题
- IIS 7除了默认页其余ASPX页面报404,HTML页面正常
- 关于读取文件的路径问题?
- ****高分,不够再加: ASP.NET中如何调用excel?
如果是第一次装,要重新启动window系统,不然提示oca.dll问题实在不行直接装 vs.net 2003 就没问题了。
<%@ Import Namespace="System.Data.OleDb" %>
<script language="c#" runat="server"> protected OleDbConnection myConn;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
myConn = new OleDbConnection("Provider=MSDAORA.1;User ID=fivecity;password=fivecity;Data Source=fivecity_www.25city.com;Persist Security Info=False");
BindGrid();
} ICollection CreateDataSource()
{
string Sql = "select * from FC_EQANSWER";
OleDbCommand myCmd = new OleDbCommand(Sql,myConn);
myCmd.CommandType = CommandType.Text;
myConn.Open(); OleDbDataAdapter myda;
DataSet ds = new DataSet();
myda = new OleDbDataAdapter();
myda.SelectCommand = myCmd;
myda.Fill(ds,"1");
myConn.Close();
return ds.Tables["1"].DefaultView;
} void BindGrid()
{
//将DataView绑定到DataGrid上去
DBGrid.DataSource = CreateDataSource();
DBGrid.DataBind();
}
</script>
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()
用OleDbDataAdapter和OleDbConnection可以解决这个问题,不管你有没有装Oracle 8i的客户端
问题应该出在这里