改用oledb也出现错误Dim conn As New OleDb.OleDbConnection conn.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=ywserver;User Id=psa;PassWord=yw;" conn.Open() Dim strSQL As String = "select * from s_user" Dim oraAdap As New OracleDataAdapter(strSQL, oracleConn) oraAdap.Fill(Ds, "s_user") DG1.DataSource = Ds.Tables("s_user").DefaultView DG1.DataBind() 异常详细信息: System.Data.OleDb.OleDbException: 没有可用的错误信息: REGDB_E_CLASSNOTREG(0x80040154)。源错误: 行 60: Dim conn As New OleDb.OleDbConnection 行 61: conn.ConnectionString = strConn 行 62: conn.Open() 行 63: Dim strSQL As String = "select * from s_user;" 行 64: 源文件: D:\program\connOracle\connOracle.aspx.vb 行: 62
到Oracle公司网站下载.NET Framework Data Provider for Oracle
conn.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=ywserver;User Id=psa;PassWord=yw;"
conn.Open()
Dim strSQL As String = "select * from s_user" Dim oraAdap As New OracleDataAdapter(strSQL, oracleConn) oraAdap.Fill(Ds, "s_user")
DG1.DataSource = Ds.Tables("s_user").DefaultView
DG1.DataBind()
异常详细信息: System.Data.OleDb.OleDbException: 没有可用的错误信息: REGDB_E_CLASSNOTREG(0x80040154)。源错误:
行 60: Dim conn As New OleDb.OleDbConnection
行 61: conn.ConnectionString = strConn
行 62: conn.Open()
行 63: Dim strSQL As String = "select * from s_user;"
行 64:
源文件: D:\program\connOracle\connOracle.aspx.vb 行: 62
若Windows2000下,选择oracle目录在目录安全上给asp.net用户附权或如上试试!
oracleConn = New OracleConnection(strConn)
Dim strSQL As String = "select * from s_user" Dim oraAdap As New OracleDataAdapter(strSQL, oracleConn) oraAdap.Fill(Ds, "s_user")
DG1.DataSource = Ds.Tables("s_user").DefaultView
DG1.DataBind()提示错误信息:
异常详细信息: System.ArgumentNullException: 值不能为空。参数名: dataSet源错误:
行 65: Dim oraAdap As New OracleDataAdapter(strSQL, oracleConn)
行 66:
行 67: oraAdap.Fill(Ds, "s_user")
行 68: DG1.DataSource = Ds.Tables("s_user").DefaultView
行 69: DG1.DataBind()
源文件: D:\program\connOracle\connOracle.aspx.vb 行: 67
應該是Oracle數據庫客戶端沒有裝好,客戶端最好裝英文版。
你的Oracle是不是才装的啊,装了以后重起没有?没有的话赶紧重起吧.