3 Replies Latest reply: Nov 28, 2012 1:19 AM by 976641 RSS

    Oracle.DataAccess.dll is visible at design time but not at debug runtime.

    447586
      Friday this was working but today it isn't and I have no idea why.
      In Visual Studio 2010 I have a web application with Master page (VB.Net). I have a reference to the ODP that points to this dll: C:\app\oracle\product\11.2.0\client_2\ODP.NET\bin\4\Oracle.DataAccess.dll.
      Intellisense finds this just fine and pops up the various layers as I type. When I compile it kicks no errors. When I run in debug I get this error message:

      Server Error in '/' Application.
      --------------------------------------------------------------------------------

      Compilation Error
      Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

      Compiler Error Message: BC30002: Type 'OracleConnection' is not defined.

      Source Error:

      Line 4:      Implements IDisposable
      Line 5:      Public IsDisposed As Boolean = False
      Line 6:      Dim cn As OracleConnection
      Line 7:      Dim cnAdmin As OracleConnection
      Line 8:      Dim da As OracleDataAdapter

      Source File: C:\inetpub\wwwroot\AccountManager2011\AccountManager2011\App_Code\OracleDataAccess.vb Line: 6

      Compiler Warning Messages:
      Warning: BC40056: Namespace or type specified in the Imports 'Oracle.DataAccess.Client' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.
      Source Error:

      C:\inetpub\wwwroot\AccountManager2011\AccountManager2011\App_Code\OracleDataAccess.vb

      Line 1: Imports Oracle.DataAccess.Client
      Line 2: Imports Oracle.DataAccess.Types
      Line 3: Public Class OracleDataAccess

      Warning: BC40056: Namespace or type specified in the Imports 'Oracle.DataAccess.Types' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.
      Source Error:

      C:\inetpub\wwwroot\AccountManager2011\AccountManager2011\App_Code\OracleDataAccess.vb

      Line 1: Imports Oracle.DataAccess.Client
      Line 2: Imports Oracle.DataAccess.Types
      Line 3: Public Class OracleDataAccess
      Line 4:      Implements IDisposable

      Show Detailed Compiler Output:

      C:\Program Files\Common Files\Microsoft Shared\DevServer\10.0> "c:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\vbc.exe" /t:library /utf8output /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Microsoft.CSharp\v4.0_4.0.0.0__b03f5f7f11d50a3a\Microsoft.CSharp.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Web.ApplicationServices\v4.0_4.0.0.0__31bf3856ad364e35\System.Web.ApplicationServices.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Activities\v4.0_4.0.0.0__31bf3856ad364e35\System.Activities.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Web\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Web.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel.Activation\v4.0_4.0.0.0__31bf3856ad364e35\System.ServiceModel.Activation.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel.Web\v4.0_4.0.0.0__31bf3856ad364e35\System.ServiceModel.Web.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.WorkflowServices\v4.0_4.0.0.0__31bf3856ad364e35\System.WorkflowServices.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel\v4.0_4.0.0.0__b77a5c561934e089\System.ServiceModel.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Data.DataSetExtensions\v4.0_4.0.0.0__b77a5c561934e089\System.Data.DataSetExtensions.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.IdentityModel\v4.0_4.0.0.0__b77a5c561934e089\System.IdentityModel.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.ComponentModel.DataAnnotations\v4.0_4.0.0.0__31bf3856ad364e35\System.ComponentModel.DataAnnotations.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Web.Services\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Web.DynamicData\v4.0_4.0.0.0__31bf3856ad364e35\System.Web.DynamicData.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Web.Extensions\v4.0_4.0.0.0__31bf3856ad364e35\System.Web.Extensions.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xml.Linq\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.Linq.dll" /R:"c:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\76f49d87\bc1d7e32\assembly\dl3\9c20bfc2\2afe9671_5024cc01\AccountManager2011.DLL" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel.Activities\v4.0_4.0.0.0__31bf3856ad364e35\System.ServiceModel.Activities.dll" /R:"C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll" /out:"c:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\76f49d87\bc1d7e32\App_Code.oq3mmird.dll" /D:DEBUG=1 /debug+ /nowarn:41008 /define:_MYTYPE=\"Web\" /imports:Microsoft.VisualBasic,System,System.Collections,System.Collections.Generic,System.Collections.Specialized,System.ComponentModel.DataAnnotations,System.Configuration,System.Linq,System.Text,System.Text.RegularExpressions,System.Web,System.Web.Caching,System.Web.DynamicData,System.Web.SessionState,System.Web.Security,System.Web.Profile,System.Web.UI,System.Web.UI.WebControls,System.Web.UI.WebControls.WebParts,System.Web.UI.HtmlControls,System.Xml.Linq /warnaserror- /optionInfer+ "c:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\76f49d87\bc1d7e32\App_Code.oq3mmird.0.vb" "c:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\76f49d87\bc1d7e32\App_Code.oq3mmird.1.vb" "c:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\76f49d87\bc1d7e32\App_Code.oq3mmird.2.vb" "c:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\76f49d87\bc1d7e32\App_Code.oq3mmird.3.vb"

      C:\inetpub\wwwroot\AccountManager2011\AccountManager2011\App_Code\OracleDataAccess.vb(1) : warning BC40056: Namespace or type specified in the Imports 'Oracle.DataAccess.Client' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.

      Imports Oracle.DataAccess.Client
      ~~~~~~~~~~~~~~~~~~~~~~~~
      C:\inetpub\wwwroot\AccountManager2011\AccountManager2011\App_Code\OracleDataAccess.vb(2) : warning BC40056: Namespace or type specified in the Imports 'Oracle.DataAccess.Types' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.

      Imports Oracle.DataAccess.Types
      ~~~~~~~~~~~~~~~~~~~~~~~
      C:\inetpub\wwwroot\AccountManager2011\AccountManager2011\App_Code\OracleDataAccess.vb(6) : error BC30002: Type 'OracleConnection' is not defined.

      Dim cn As OracleConnection
      ~~~~~~~~~~~~~~~~
      C:\inetpub\wwwroot\AccountManager2011\AccountManager2011\App_Code\OracleDataAccess.vb(7) : error BC30002: Type 'OracleConnection' is not defined.

      Dim cnAdmin As OracleConnection
      ~~~~~~~~~~~~~~~~
      C:\inetpub\wwwroot\AccountManager2011\AccountManager2011\App_Code\OracleDataAccess.vb(8) : error BC30002: Type 'OracleDataAdapter' is not defined.

      Dim da As OracleDataAdapter
      ~~~~~~~~~~~~~~~~~
      C:\inetpub\wwwroot\AccountManager2011\AccountManager2011\App_Code\OracleDataAccess.vb(9) : error BC30002: Type 'OracleDataAdapter' is not defined.

      Dim da2 As OracleDataAdapter
      ~~~~~~~~~~~~~~~~~
      C:\inetpub\wwwroot\AccountManager2011\AccountManager2011\App_Code\OracleDataAccess.vb(20) : error BC30002: Type 'OracleConnection' is not defined.

      cn = New OracleConnection("Data Source=" & HttpContext.Current.Application("sDatabase") & "; User Id=fooaccess;Password=foo2;Pooling=True;")
      ~~~~~~~~~~~~~~~~
      C:\inetpub\wwwroot\AccountManager2011\AccountManager2011\App_Code\OracleDataAccess.vb(25) : error BC30002: Type 'OracleDataAdapter' is not defined.

      Dim da As New OracleDataAdapter(sSQL, cn)
      ~~~~~~~~~~~~~~~~~
      C:\inetpub\wwwroot\AccountManager2011\AccountManager2011\App_Code\OracleDataAccess.vb(26) : error BC30002: Type 'DataTable' is not defined.

      Dim dt As New DataTable
      ~~~~~~~~~
      Show Complete Compilation Source:

      Line 1: Imports Oracle.DataAccess.Client
      Line 2: Imports Oracle.DataAccess.Types
      Line 3: Public Class OracleDataAccess
      Line 4:      Implements IDisposable
      Line 5:      Public IsDisposed As Boolean = False
      Line 6:      Dim cn As OracleConnection
      Line 7:      Dim cnAdmin As OracleConnection
      Line 8:      Dim da As OracleDataAdapter
      Line 9:      Dim da2 As OracleDataAdapter
      Line 10:
      Line 11:      Sub New()
      Line 12:           Select Case UCase(HttpContext.Current.Request.ServerVariables("SERVER_NAME"))     'Web Server name
      Line 13:                Case "LOCALHOST"     ' Local machine or crash box
      Line 14:                     ' sDatabase is a global variable because on each machine this can be shared across all instances
      Line 15:                     HttpContext.Current.Application("sDatabase") = "Oradev"
      Line 16:                Case "foo"     ' Production Server
      Line 17:                     HttpContext.Current.Application("sDatabase") = "Ofoo"     
      Line 18:                     '
      Line 19:           End Select
      Line 20:           cn = New OracleConnection("Data Source=" & HttpContext.Current.Application("sDatabase") & "; User Id=foo;Password=foo2;Pooling=True;")
      Line 21:           cnAdmin = New OracleConnection("Data Source=" & HttpContext.Current.Application("sDatabase") & "; User Id=fooupdate;Password=footoo;Pooling=True;")
      Line 22:      End Sub
      Line 23:      Function ValidUser(ByVal sUserID As String, ByVal sPassword As String) As Boolean
      Line 24:           Dim sSQL As String = "SELECT * FROM foo.foo_users WHERE Upper(user_name) = Upper('" & sUserID & "') AND user_password = '" & sPassword & "' "
      Line 25:           Dim da As New OracleDataAdapter(sSQL, cn)
      Line 26:           Dim dt As New DataTable
      Line 27:           da.Fill(dt)
      Line 28:           da.Dispose()
      Line 29:           cn.Close()
      Line 30:           If dt.Rows.Count > 0 Then
      Line 31:                Return False
      Line 32:           Else
      Line 33:                Return True
      Line 34:           End If
      Line 35:      End Function
      Line 36:      Function LogUser(ByVal sUserID As String, ByVal sPassword As String) As Boolean
      Line 37:           Dim sSQL As String = "INSERT INTO foo.login_log (user_name, user_password, login_time, login_success) VALUES ('" & sUserID & "', '" & sPassword & "', to_date('" & Now() & "', 'MM/DD/YYYY HH:MI:SS AM'), 'Yes')"
      Line 38:           Try
      Line 39:                Dim cmd As New OracleCommand(sSQL, cn)
      Line 40:                cn.Open()
      Line 41:                cmd.ExecuteNonQuery()
      Line 42:                cn.Close()
      Line 43:                cmd.Dispose()
      Line 44:                Return True
      Line 45:           Catch ex As Exception
      Line 46:                Return False
      Line 47:           End Try
      Line 48:      End Function
      Line 49:      Function GetAllUsersEdit() As Boolean
      Line 50:           Dim sSQL As String = "Select * FROM foo.foo_users ORDER BY user_name"
      Line 51:           Dim da As New OracleDataAdapter(sSQL, cnAdmin)
      Line 52:           Dim dt As New DataTable
      Line 53:           da.Fill(dt)
      Line 54:           da.Dispose()
      Line 55:           cnAdmin.Close()
      Line 56:           Return True
      Line 57:      End Function
      Line 58:      Function InsertUser(ByVal User_Name As String, ByVal Password As String) As Boolean
      Line 59:           Dim sSQL As String = "Insert INTO foo.foo_users (user_name, Password) values ( '" & User_Name & "','" & Password & "')"
      Line 60:           Try
      Line 61:                Dim cmd As New OracleCommand(sSQL, cnAdmin)
      Line 62:                cnAdmin.Open()
      Line 63:                cmd.ExecuteNonQuery()
      Line 64:                cnAdmin.Close()
      Line 65:                cmd.Dispose()
      Line 66:           Catch ex As Exception
      Line 67:                Return False
      Line 68:           End Try
      Line 69:           Return True
      Line 70:
      Line 71:      End Function
      Line 72:      Function DeleteUser(ByVal User_Name As String) As Boolean
      Line 73:           Dim sSQL As String = "delete from foo.foo_users Where user_name = '" & User_Name & "'"
      Line 74:           Try
      Line 75:                Dim cmd As New OracleCommand(sSQL, cnAdmin)
      Line 76:                cnAdmin.Open()
      Line 77:                cmd.ExecuteNonQuery()
      Line 78:                cnAdmin.Close()
      Line 79:                cmd.Dispose()
      Line 80:           Catch ex As Exception
      Line 81:                Return False
      Line 82:           End Try
      Line 83:           Return True
      Line 84:      End Function
      Line 85:      Function UpdateEditedUsers(ByVal User_Name As String, ByVal OldUserName As String, ByVal Password As String) As Boolean
      Line 86:           Dim sSQL As String = "Update foo.foo_users set User_Name = '" & User_Name & "', Password = '" & Password & "' WHERE User_Name = '" & OldUserName & "'"
      Line 87:           Try
      Line 88:                Dim cmd As New OracleCommand(sSQL, cnAdmin)
      Line 89:                cnAdmin.Open()
      Line 90:                cmd.ExecuteNonQuery()
      Line 91:                cnAdmin.Close()
      Line 92:                cmd.Dispose()
      Line 93:           Catch ex As Exception
      Line 94:                Return False
      Line 95:           End Try
      Line 96:           Return True
      Line 97:      End Function
      Line 98:      Function CheckAdminUser(ByVal sUserID As String, ByVal sPassword As String) As Boolean
      Line 99:           Dim sSQL As String = "SELECT * FROM foo.foo_access WHERE Upper(access_name) = Upper('" & sUserID & "') AND foo.foo_access.access_complex = 9999"
      Line 100:           Dim da As New OracleDataAdapter(sSQL, cn)
      Line 101:           Dim dt As New DataTable
      Line 102:           da.Fill(dt)
      Line 103:           da.Dispose()
      Line 104:           cn.Close()
      Line 105:           If dt.Rows.Count > 0 Then
      Line 106:                Return True
      Line 107:           Else
      Line 108:                Return False
      Line 109:           End If
      Line 110:      End Function
      Line 111:      Function GetUserComplexes(ByVal sUserID As String) As DataTable
      Line 112:           Dim sSQL As String = "SELECT * FROM foo.foo_access, pmi.pmi_complex WHERE Upper(access_name) = Upper('" & sUserID & "') AND foo.foo_complex.group_number = foo.foo_access.access_complex ORDER BY foo.foo_complex.complex_name"
      Line 113:           Dim da As New OracleDataAdapter(sSQL, cn)
      Line 114:           Dim dt As New DataTable
      Line 115:           da.Fill(dt)
      Line 116:           da.Dispose()
      Line 117:           cn.Close()
      Line 118:           Return dt
      Line 119:      End Function
      Line 120:      Function GetAllComplexes() As DataTable
      Line 121:           Dim sSQL As String = "SELECT * FROM foo.foo_complex ORDER BY foo.foo_complex.complex_name"
      Line 122:           Dim da As New OracleDataAdapter(sSQL, cn)
      Line 123:           Dim dt As New DataTable
      Line 124:           da.Fill(dt)
      Line 125:           da.Dispose()
      Line 126:           cn.Close()
      Line 127:           Return dt
      Line 128:      End Function
      Line 129:      Function GetAllComplexesEdit() As DataTable
      Line 130:           Dim dt As New DataTable
      Line 131:           Dim sSQL As String = "SELECT * FROM foo.foo_complex ORDER BY foo.foo_complex.complex_name"
      Line 132:           da2 = New OracleDataAdapter(sSQL, cnAdmin)
      Line 133:           Dim ocb As New Oracle.DataAccess.Client.OracleCommandBuilder(da)
      Line 134:           da2.Fill(dt)
      Line 135:           Return dt
      Line 136:      End Function
      Line 137:      Function DeleteComplex(ByVal Complex_Name As String) As Boolean
      Line 138:           Dim sSQL As String = "delete from foo.foo_Complex Where Complex_Name = '" & Complex_Name & "'"
      Line 139:           Try
      Line 140:                Dim cmd As New OracleCommand(sSQL, cnAdmin)
      Line 141:                cnAdmin.Open()
      Line 142:                cmd.ExecuteNonQuery()
      Line 143:                cnAdmin.Close()
      Line 144:                cmd.Dispose()
      Line 145:           Catch ex As Exception
      Line 146:                Return False
      Line 147:           End Try
      Line 148:           Return True
      Line 149:      End Function
      Line 150:      Function UpdateEditedComplexes(ByVal Complex_Name As String, ByVal Group_Number As Integer) As Boolean
      Line 151:           Dim sSQL As String = "Update foo.foo_complex set Complex_Name = '" & Complex_Name & "' Where Group_Number = " & Group_Number
      Line 152:           Try
      Line 153:                Dim cmd As New OracleCommand(sSQL, cnAdmin)
      Line 154:                cnAdmin.Open()
      Line 155:                cmd.ExecuteNonQuery()
      Line 156:                cnAdmin.Close()
      Line 157:                cmd.Dispose()
      Line 158:           Catch ex As Exception
      Line 159:                Return False
      Line 160:           End Try
      Line 161:           Return True
      Line 162:      End Function
      Line 163:      Function InsertComplex(ByVal Complex As String) As Boolean
      Line 164:           Dim sSQL As String = "insert into foo.foo_complex (Complex_Name) Values ('" & Complex & "')"
      Line 165:           Try
      Line 166:                Dim cmd As New OracleCommand(sSQL, cnAdmin)
      Line 167:                cnAdmin.Open()
      Line 168:                cmd.ExecuteNonQuery()
      Line 169:                cnAdmin.Close()
      Line 170:                cmd.Dispose()
      Line 171:           Catch ex As Exception
      Line 172:                Return False
      Line 173:           End Try
      Line 174:           Return True
      Line 175:      End Function
      Line 176:      Function GetAccountList(ByVal iComplex As Integer, ByVal sSortBy As String) As DataTable
      Line 177:           Dim sSQL As String = "SELECT * FROM foo.foo WHERE GROUP_NUMBER = " & iComplex
      Line 178:           If sSortBy <> "" Then
      Line 179:                sSQL = sSQL & " ORDER BY " & sSortBy & ", Service_address"
      Line 180:           Else
      Line 181:                sSQL = sSQL & " ORDER BY Service_Address"
      Line 182:           End If
      Line 183:           Dim da As New OracleDataAdapter(sSQL, cn)
      Line 184:           Dim dt As New DataTable
      Line 185:           da.Fill(dt)
      Line 186:           da.Dispose()
      Line 187:           cn.Close()
      Line 188:           Return dt
      Line 189:      End Function
      Line 190:      Function GetTimeStamp() As String
      Line 191:           Dim sSQL As String = "Select Time_Updated from Update_Time"
      Line 192:           Dim da As New OracleDataAdapter(sSQL, cn)
      Line 193:           Dim dt As New DataTable
      Line 194:           da.Fill(dt)
      Line 195:           da.Dispose()
      Line 196:           cn.Close()
      Line 197:           Return dt.Rows(0).Item(0)
      Line 198:      End Function
      Line 199:      Function VerifyMeterAccess(ByVal iMeterNumber As Integer, ByVal sName As String) As Boolean
      Line 200:           Dim sSQL As String = "Select Access_Name from foo.foo, foo.foo_ACCESS where meter_number = " & iMeterNumber & " and foo.foo.group_number = foo.foo_access.access_complex and foo.foo_access.ACCESS_NAME = '" & sName & "'"
      Line 201:           Dim da As New OracleDataAdapter(sSQL, cn)
      Line 202:           Dim dt As New DataTable
      Line 203:           da.Fill(dt)
      Line 204:           da.Dispose()
      Line 205:           cn.Close()
      Line 206:           If dt.Rows.Count > 0 Then
      Line 207:                Return True
      Line 208:           Else
      Line 209:                Return False
      Line 210:           End If
      Line 211:      End Function
      Line 212:      Function GetMeterInfo(ByVal iMeterNumber As Integer) As DataTable
      Line 213:           Dim sSQL As String = "SELECT * FROM foo.foo, foo.foo_complex WHERE METER_NUMBER = '" & iMeterNumber & "' and foo.foo_complex.Group_Number = foo.foo.Group_Number"
      Line 214:           Dim da As New OracleDataAdapter(sSQL, cn)
      Line 215:           Dim dt As New DataTable
      Line 216:           da.Fill(dt)
      Line 217:           da.Dispose()
      Line 218:           cn.Close()
      Line 219:           Return dt
      Line 220:      End Function
      Line 242: End Class

      Server Error in '/' Application.
      --------------------------------------------------------------------------------

      Compilation Error
      Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

      Compiler Error Message: BC30002: Type 'OracleConnection' is not defined.

      Source Error:

      Line 4:      Implements IDisposable
      Line 5:      Public IsDisposed As Boolean = False
      Line 6:      Dim cn As OracleConnection
      Line 7:      Dim cnAdmin As OracleConnection
      Line 8:      Dim da As OracleDataAdapter

      Source File: C:\inetpub\wwwroot\AccountManager2011\AccountManager2011\App_Code\OracleDataAccess.vb Line: 6

      Compiler Warning Messages:
      Warning: BC40056: Namespace or type specified in the Imports 'Oracle.DataAccess.Client' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.
      Source Error:

      C:\inetpub\wwwroot\AccountManager2011\AccountManager2011\App_Code\OracleDataAccess.vb

      Line 1: Imports Oracle.DataAccess.Client
      Line 2: Imports Oracle.DataAccess.Types
      Line 3: Public Class OracleDataAccess

      Warning: BC40056: Namespace or type specified in the Imports 'Oracle.DataAccess.Types' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.
      Source Error:

      C:\inetpub\wwwroot\AccountManager2011\AccountManager2011\App_Code\OracleDataAccess.vb

      Line 1: Imports Oracle.DataAccess.Client
      Line 2: Imports Oracle.DataAccess.Types
      Line 3: Public Class OracleDataAccess
      Line 4:      Implements IDisposable

      Any ideas on how to fix this?