Re: Connection to ORACLE: Need some explanations

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On 21 Jun 2006 11:35:37 -0700, tommaso.gastaldi@xxxxxxxxxxx wrote:

¤ Hi Paul.
¤
¤ The Oracle client is installed because it has been installed on purpose
¤ for the connection and I have seen it being installed by the
¤ administrator.
¤
¤ Note that the msdaora does not behave like if it were a full client,
¤ infact it does *NOT* work at all if the Oracle Client is not installed.
¤ It just appears to be as a layer of software which talks with the
¤ Oracle client (which is installed).
¤
¤ I dont' really get what the connection string containing msdaora does
¤ different with respect to the other one.

Maybe I wasn't clear. They are different drivers. MSDAORA is from Microsoft and the other one, which
isn't working for you, is from Oracle. When you use a DSN-less connection string you specify which
provider (or driver) to use.

I would recommend installing (or reinstalling) the Oracle provider (not the client software) because
it doesn't appear to be installed (or installed properly).


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages

  • Re: Vista Installations
    ... ¤ I finally got a Vista machine, and have been testing my installs on it. ... Registry on ... installing to the normal Program Files folder. ...
    (microsoft.public.vb.general.discussion)
  • Re: If you connect to Oracle through .NET please help!
    ... ¤ provider for Oracle. ... Are you saying that I can access Oracle without installing any Oracle ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Vista Installations
    ... ¤ I finally got a Vista machine, and have been testing my installs on it. ... installing to the normal Program Files folder. ... I then set Run as Admin for the /app/, ...
    (microsoft.public.vb.general.discussion)
  • Re: ASP.NET IMPERSONATION AND ORACLE 8.1.7
    ... besides installing oracle:) ... ¤ but i'm always getting a ora 01017 invalid username/password. ... Assuming Oracle is installed on a machine other than your web server you will need to enable ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: OracleClient
    ... ¤ Hello, ... I installed of course Oracle Client version on my computer. ... You won't be able to avoid installing the Oracle client w/o using a third-party solution. ...
    (microsoft.public.dotnet.framework.adonet)