asp.net 如何连接oracle数据库？

[wwyf]

asp.net 如何连接oracle数据库？
请问：
为什么我在.net中编写xxx.aspx时，输入如 <form 时代码专家
没有任何提示？如action 之类？？？
又如win2000,oracle8 我连接数据库时
代码：
<%@ page Language=VBScript debug=true %>
<%@ import namespace="system.data" %>
<%@ import namespace="system.data.oledb" %>
<script runat=server>
sub page_load(byval sender as object ,byval e as eventargs)
dim dbconn as oledbconnection
dim dbsql as new oledbcommand
dbconn=new oledbconnection("Provider=MSDAORA.1;Password=good;User ID=ff;Data Source=fly")
dbsql.commandtext="select * from users"
dbsql.connection=dbconn
dbsql.connection.open
dbsql.executenonquery()
end sub
</script>
/////////////////////////////
则出现错误提示：
Oracle client and networking components were not found.
These components are supplied by Oracle Corporation
and are part of the Oracle Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed.
如何处理？？
谢谢！！！

[edobnet]

装一下Oracle客户端试试

[tclzbz]

问题解决了吗？

[wayneliu]

public static int ExecuteNonQuery(string connectionString, CommandType commandType, string commandText)
{
//pass through the call providing null for the set of SqlParameters
return ExecuteNonQuery(connectionString, commandType, commandText, (SqlParameter[])null);
}

public static int ExecuteNonQuery(string connectionString, CommandType commandType, string commandText, params SqlParameter[] commandParameters)
{
//create & open a SqlConnection, and dispose of it after we are done.
using (SqlConnection cn = new SqlConnection(connectionString))
{
cn.Open();

//call the overload that takes a connection in place of the connection string
return ExecuteNonQuery(cn, commandType, commandText, commandParameters);
}
}
public static int ExecuteNonQuery(string connectionString, string spName, params object[] parameterValues)
{
//if we receive parameter values, we need to figure out where they go
if ((parameterValues != null) && (parameterValues.Length > 0))
{
//pull the parameters for this stored procedure from the parameter cache (or discover them & populate the cache)
SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(connectionString, spName);

//assign the provided values to these parameters based on parameter order
AssignParameterValues(commandParameters, parameterValues);

//call the overload that takes an array of SqlParameters
return ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName, commandParameters);
}
//otherwise we can just call the SP without params
else
{
return ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName);
}
}

[panyee]

要访问其它机器的oracle数据库, 要安装oracle客户端, 并配置一个oracle实例

Provider=MSDAORA.1;Password=good;User ID=ff;Data Source=fly"

你的Data Source是fly, 但你要用net 8 config看一下有没有配置了这个实例
没有的话就连不上
oracle不一定提供机器名即实例名的默认实例