Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspx thread: .NET Managed Provider for Oracle


Message #1 by "Malathi" <senthil.malathi@a...> on Sun, 16 Mar 2003 11:10:35 +0400
I have the following code for Oracle connection using .NET Managed Provider
for Oracle from MS.

The same piece of code works fine when tested frm VB .NET but fails with a
msg

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

in asp .net

I've included system.data.oracleclient namespace in the page & Oracle 8i
client is used.


Any suggestions?



    Sub OraTest()
           Try
                Dim Conn As New OracleConnection("data source 
srv;uid=user;pwd=pass")
                Conn.Open()
                'MsgBox(Conn.State.ToString)
                Conn.Close()
                Conn.Dispose()
           Catch ex As Exception
                Response.Write(ex.ToString)
           End Try
     End Sub

Regards,
S.Malathi, IT Project Analyst
ADNOC Distribution
P.O. 4188, Abu Dhabi
Tel : 6959480 (D)
Mob : 050 5316055
Fax : 6742265



DISCLAIMER:
-------------------------------------------------------------------------------------------------------------
 Please note that our domain name is changed from adnoc-fod.co.ae to adnoc-dist.co.ae
 Hence change your email addresses accordingly to reflect these changes.
 This communication may contain confidential information.  If you are not the intended recipient 
 please inform us immediately.
 For complete disclaimer note please visit our website at:
 http://www.adnoc-dist.co.ae/emaildisclaimer.htm
                                                                                                                             
 Adnoc Distribution-Tel:02-6771300;Fax:02-6722322;
 Email:webmaster@a...;Website:http://www.adnoc-dist.co.ae

Message #2 by "Christopher Reed" <CReed@m...> on Mon, 17 Mar 2003 08:11:31 -0600
Try putting the OracleClient DLL in the BIN directory for your
application.  There was some problems with the ODBC provider where this
would make it work.

Hope this helps!

Christopher Reed
Application Analyst
Web Development Coordinator
Information Technology
"...efficient operations and utilization of
                technology and communications..."
City of Lubbock
creed@m...
"The oxen are slow, but the earth is patient."

>>> senthil.malathi@a... 1:10:35 AM 3/16/2003 >>>
I have the following code for Oracle connection using .NET Managed
Provider
for Oracle from MS.

The same piece of code works fine when tested frm VB .NET but fails
with a
msg

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

in asp .net

I've included system.data.oracleclient namespace in the page & Oracle
8i
client is used.


Any suggestions?



    Sub OraTest()
           Try
                Dim Conn As New OracleConnection("data source 
srv;uid=user;pwd=pass")
                Conn.Open()
                'MsgBox(Conn.State.ToString)
                Conn.Close()
                Conn.Dispose()
           Catch ex As Exception
                Response.Write(ex.ToString)
           End Try
     End Sub

Regards,
S.Malathi, IT Project Analyst
ADNOC Distribution
P.O. 4188, Abu Dhabi
Tel : 6959480 (D)
Mob : 050 5316055
Fax : 6742265
Message #3 by "Malathi" <senthil.malathi@a...> on Mon, 24 Mar 2003 15:12:39 +0400
[aspx] Re: .NET Managed Provider for OracleI just created a sample aspx page
to test the connection & copied System.Data.OracleClient.dll in the same
path as the aspx page. The same err again.
BTW vb .net exe runs in any fldr without any other support file.

Do I need to change the system path/register the dll?

I'm stuck now. Any ideas?


 -----Original Message-----
From: Christopher Reed [mailto:CReed@m...]
Sent: Monday, March 17, 2003 6:12 PM
To: ASP.NET
Subject: [aspx] Re: .NET Managed Provider for Oracle


  Try putting the OracleClient DLL in the BIN directory for your
  application.  There was some problems with the ODBC provider where this
  would make it work.

  Hope this helps!

  Christopher Reed
  Application Analyst
  Web Development Coordinator
  Information Technology
  "...efficient operations and utilization of
                  technology and communications..."
  City of Lubbock
  creed@m...
  "The oxen are slow, but the earth is patient."

  >>> senthil.malathi@a... 1:10:35 AM 3/16/2003 >>>
  I have the following code for Oracle connection using .NET Managed
  Provider
  for Oracle from MS.

  The same piece of code works fine when tested frm VB .NET but fails
  with a
  msg

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

  in asp .net

  I've included system.data.oracleclient namespace in the page & Oracle
  8i
  client is used.



  Any suggestions?




      Sub OraTest()
             Try
                  Dim Conn As New OracleConnection("data source 
  srv;uid=user;pwd=pass")
                  Conn.Open()
                  'MsgBox(Conn.State.ToString)
                  Conn.Close()
                  Conn.Dispose()
             Catch ex As Exception
                  Response.Write(ex.ToString)
             End Try
       End Sub

  Regards,
  S.Malathi, IT Project Analyst
  ADNOC Distribution
  P.O. 4188, Abu Dhabi
  Tel : 6959480 (D)
  Mob : 050 5316055
  Fax : 6742265



DISCLAIMER:
-------------------------------------------------------------------------------------------------------------
 Please note that our domain name is changed from adnoc-fod.co.ae to adnoc-dist.co.ae
 Hence change your email addresses accordingly to reflect these changes.
 This communication may contain confidential information.  If you are not the intended recipient 
 please inform us immediately.
 For complete disclaimer note please visit our website at:
 http://www.adnoc-dist.co.ae/emaildisclaimer.htm
                                                                                                                             
 Adnoc Distribution-Tel:02-6771300;Fax:02-6722322;
 Email:webmaster@a...;Website:http://www.adnoc-dist.co.ae

Message #4 by "Armando G Zuniga" <a_zuniga@w...> on Mon, 24 Mar 2003 06:40:29 -0600
-----Original Message-----
From: Malathi [mailto:senthil.malathi@a...]
Sent: Monday, March 24, 2003 5:13 AM
To: ASP.NET
Subject: [aspx] Re: .NET Managed Provider for Oracle


[aspx] Re: .NET Managed Provider for OracleI just created a sample aspx page
to test the connection & copied System.Data.OracleClient.dll in the same
path as the aspx page. The same err again.
BTW vb .net exe runs in any fldr without any other support file.

Do I need to change the system path/register the dll?

I'm stuck now. Any ideas?


 -----Original Message-----
From: Christopher Reed [mailto:CReed@m...]
Sent: Monday, March 17, 2003 6:12 PM
To: ASP.NET
Subject: [aspx] Re: .NET Managed Provider for Oracle


  Try putting the OracleClient DLL in the BIN directory for your
  application.  There was some problems with the ODBC provider where this
  would make it work.

  Hope this helps!

  Christopher Reed
  Application Analyst
  Web Development Coordinator
  Information Technology
  "...efficient operations and utilization of
                  technology and communications..."
  City of Lubbock
  creed@m...
  "The oxen are slow, but the earth is patient."

  >>> senthil.malathi@a... 1:10:35 AM 3/16/2003 >>>
  I have the following code for Oracle connection using .NET Managed
  Provider
  for Oracle from MS.

  The same piece of code works fine when tested frm VB .NET but fails
  with a
  msg

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

  in asp .net

  I've included system.data.oracleclient namespace in the page & Oracle
  8i
  client is used.



  Any suggestions?




      Sub OraTest()
             Try
                  Dim Conn As New OracleConnection("data source 
  srv;uid=user;pwd=pass")
                  Conn.Open()
                  'MsgBox(Conn.State.ToString)
                  Conn.Close()
                  Conn.Dispose()
             Catch ex As Exception
                  Response.Write(ex.ToString)
             End Try
       End Sub

  Regards,
  S.Malathi, IT Project Analyst
  ADNOC Distribution
  P.O. 4188, Abu Dhabi
  Tel : 6959480 (D)
  Mob : 050 5316055
  Fax : 6742265



DISCLAIMER:
----------------------------------------------------------------------------
---------------------------------
 Please note that our domain name is changed from adnoc-fod.co.ae to
adnoc-dist.co.ae
 Hence change your email addresses accordingly to reflect these changes.
 This communication may contain confidential information.  If you are not
the intended recipient
 please inform us immediately.
 For complete disclaimer note please visit our website at:
 http://www.adnoc-dist.co.ae/emaildisclaimer.htm

 Adnoc Distribution-Tel:02-6771300;Fax:02-6722322;
 Email:webmaster@a...;Website:http://www.adnoc-dist.co.ae



Message #5 by "Malathi" <senthil.malathi@a...> on Tue, 25 Mar 2003 08:24:04 +0400
[aspx] Re: .NET Managed Provider for OracleHi Armando,
I don't see any response in your reply.
  -----Original Message-----
  From: Armando G Zuniga [mailto:a_zuniga@w...]
  Sent: Monday, March 24, 2003 4:40 PM
  To: ASP.NET
  Subject: [aspx] Re: .NET Managed Provider for Oracle


  -----Original Message-----
  From: Malathi [mailto:senthil.malathi@a...]
  Sent: Monday, March 24, 2003 5:13 AM
  To: ASP.NET
  Subject: [aspx] Re: .NET Managed Provider for Oracle



  [aspx] Re: .NET Managed Provider for OracleI just created a sample aspx
page
  to test the connection & copied System.Data.OracleClient.dll in the same
  path as the aspx page. The same err again.
  BTW vb .net exe runs in any fldr without any other support file.

  Do I need to change the system path/register the dll?

  I'm stuck now. Any ideas?



   -----Original Message-----
  From: Christopher Reed [mailto:CReed@m...]
  Sent: Monday, March 17, 2003 6:12 PM
  To: ASP.NET
  Subject: [aspx] Re: .NET Managed Provider for Oracle



    Try putting the OracleClient DLL in the BIN directory for your
    application.  There was some problems with the ODBC provider where this
    would make it work.

    Hope this helps!

    Christopher Reed
    Application Analyst
    Web Development Coordinator
    Information Technology
    "...efficient operations and utilization of
                    technology and communications..."
    City of Lubbock
    creed@m...
    "The oxen are slow, but the earth is patient."

    >>> senthil.malathi@a... 1:10:35 AM 3/16/2003 >>>
    I have the following code for Oracle connection using .NET Managed
    Provider
    for Oracle from MS.

    The same piece of code works fine when tested frm VB .NET but fails
    with a
    msg

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

    in asp .net

    I've included system.data.oracleclient namespace in the page & Oracle
    8i
    client is used.




    Any suggestions?





        Sub OraTest()
               Try
                    Dim Conn As New OracleConnection("data source 
    srv;uid=user;pwd=pass")
                    Conn.Open()
                    'MsgBox(Conn.State.ToString)
                    Conn.Close()
                    Conn.Dispose()
               Catch ex As Exception
                    Response.Write(ex.ToString)
               End Try
         End Sub

    Regards,
    S.Malathi, IT Project Analyst
    ADNOC Distribution
    P.O. 4188, Abu Dhabi
    Tel : 6959480 (D)
    Mob : 050 5316055
    Fax : 6742265




  DISCLAIMER:
  --------------------------------------------------------------------------
--
  ---------------------------------
   Please note that our domain name is changed from adnoc-fod.co.ae to
  adnoc-dist.co.ae
   Hence change your email addresses accordingly to reflect these changes.
   This communication may contain confidential information.  If you are not
  the intended recipient
   please inform us immediately.
   For complete disclaimer note please visit our website at:
   http://www.adnoc-dist.co.ae/emaildisclaimer.htm

   Adnoc Distribution-Tel:02-6771300;Fax:02-6722322;
   Email:webmaster@a...;Website:http://www.adnoc-dist.co.ae








DISCLAIMER:
-------------------------------------------------------------------------------------------------------------
 Please note that our domain name is changed from adnoc-fod.co.ae to adnoc-dist.co.ae
 Hence change your email addresses accordingly to reflect these changes.
 This communication may contain confidential information.  If you are not the intended recipient 
 please inform us immediately.
 For complete disclaimer note please visit our website at:
 http://www.adnoc-dist.co.ae/emaildisclaimer.htm
                                                                                                                             
 Adnoc Distribution-Tel:02-6771300;Fax:02-6722322;
 Email:webmaster@a...;Website:http://www.adnoc-dist.co.ae


  Return to Index