Re: Connection to ORACLE: Need some explanations

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.

-tom

Paul Clement ha scritto:

On 21 Jun 2006 09:09:58 -0700, tommaso.gastaldi@xxxxxxxxxxx wrote:

¤ The PC's are for students. There is a copy of the oracle client
¤ installed on each pc.
¤ Clearly there is also a remote machine (SERVER) which has Oracle
¤ server.
¤
¤ Right! Oracle OLEDB Provider is a separate install and it is the one to
¤ which the message is referring to. The msg say thta the OleDb provider
¤ is not registered on the current machine. But actually it is. In fact
¤ we can get connected by using msdaora.
¤

But those are two different OLEDB providers, each from a different vendor.. The MSDAORA OleDb
provider is from Microsoft and is usually already installed. The OraOLEDB..Oracle OleDb provider is
from Oracle and is not installed unless someone explicitly installed it.

Try checking the bin subfolder in your Oracle client installation folder. There should be a file
called OraOLEDB.dll in addition to some other OraOLEDB files. If these files are not present then
this provider needs to be installed.


Paul
~~~~
Microsoft MVP (Visual Basic)

.

Relevant Pages

  • Re: Connection to ORACLE: Need some explanations
    ... ¤ Ok I think I see now what you mean. ... of the Oracle Client does not install by default the OleDb provider. ... If I remember correctly the client software and the OLEDB provider are separate installs on the CD. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection to ORACLE: Need some explanations
    ... ¤ ... There is a copy of the oracle client ... Oracle OLEDB Provider is a separate install and it is the one to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection to ORACLE: Need some explanations
    ... ¤ ... There is a copy of the oracle client ... Oracle OLEDB Provider is a separate install and it is the one to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: in query expression MSysAccounts.name. ERROR
    ... "You might want to go ahead and try re-registering your DAO360.dll file. ... To register this file, ... > the Oracle install. ... I have not re-installed the Oracle Client. ...
    (microsoft.public.access.security)
  • Re: Oracle Client?
    ... ODAC will install the necessary Oracle client side components. ... ¤ ... You need to install the Oracle client software. ...
    (microsoft.public.dotnet.framework.adonet)