Re: Oracle client not found ...- vb.net

From: Val Mazur (group51a_at_hotmail.com)
Date: 05/28/04 

Date: Thu, 27 May 2004 22:08:52 -0400

Hi,

Actually error message says that you need to install Client Tools for
Oracle. I believe clients tools come as a separate installation for Oracle 

-- 
Val Mazur
Microsoft MVP
"HankC" <clarkc@missouri.edu> wrote in message 
news:b26b9e2f.0405271053.10c067e7@posting.google.com...
> SQL*Plus works fine from te command line.
>
> Running code inside the vb.net app gives the long message at the
> bottom.
>
> Here is the code in question:
>
>        ado_ora_con = CreateObject("ADODB.Connection")
>        ado_ora_con.Provider = "MSDAORA"
>        ado_ora_con.ConnectionString = "Data
> Source=umdw.umsystem.edu;User
> ID=email_directory;Password=************"
>
>
>        ado_ora_con.Open()
>            If ado_ora_con.State <> 1 Then
>                 MsgBox("Authentication to Oracle Failed")
>                Exit Function
>             End If
>
>
>
> Thanks,
> HankC
>
> error 
> message===============================================================
> 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.
> Description: An unhandled exception occurred during the execution of
> the current web request. Please review the stack trace for more
> information about the error and where it originated in the code.
>
> Exception Details: System.Runtime.InteropServices.COMException: 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.
>
> Source Error:
>
> An unhandled exception was generated during the execution of the
> current web request. Information regarding the origin and location of
> the exception can be identified using the exception stack trace below.
>
> Stack Trace:
>
>
> [COMException (0x80004005): 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.]
> 
> Microsoft.VisualBasic.CompilerServices.LateBinding.InternalLateCall(Object
> o, Type objType, String name, Object[] args, String[] paramnames,
> Boolean[] CopyBack, Boolean IgnoreReturn) +789
>   Microsoft.VisualBasic.CompilerServices.LateBinding.LateCall(Object
> o, Type objType, String name, Object[] args, String[] paramnames,
> Boolean[] CopyBack) +23
>   vanity.oracle.is_student(String site, String id) in
> c:\inetpub\wwwroot\inetpub\wwwroot\projects\vanity\oracle.vb:154
>   vanity.WebForm1.Button1_Click(Object sender, EventArgs e) in
> c:\inetpub\wwwroot\inetpub\wwwroot\projects\vanity\vanity.aspx.vb:135
>   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
> 
> System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
> eventArgument) +57
>   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument) +18
>   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
> +33
>   System.Web.UI.Page.ProcessRequestMain() +1277
>
>
>
>
> --------------------------------------------------------------------------------
> Version Information: Microsoft .NET Framework Version:1.1.4322.573;
> ASP.NET Version:1.1.4322.573