Re: Connection to ORACLE: Need some explanations

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

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.

-tom

Paul Clement ha scritto:

On 21 Jun 2006 06:34:23 -0700, tommaso.gastaldi@xxxxxxxxxxx wrote:

¤ Hi Paul,
¤
¤ It's a standard VB.NET client application.
¤ It just does the connection and allows sending SQL commands.
¤ SQL plus can connect.
¤
¤ If it's a security issue I am not clear why msdaora is not affected
¤ (??)
¤
¤ Any ideas?

Does the error indicate the Oracle client is not registered or is it referring to the Oracle OLEDB
Provider?

If I remember correctly the Oracle OLEDB Provider is a separate install:

http://www.oracle.com/technology/tech/windows/ole_db/index.html


Paul
~~~~
Microsoft MVP (Visual Basic)

.

Relevant Pages

  • Re: Cant get Oracle OLE DB provider to work from SSIS on a 64-bit environment
    ... The project I'm trying to get running, consists of approx 25 seperate packages where 3-4 of them gets data from different Oracle sources, but I'm not even got to the point where I'm trying to run the whole lot. ... There are two issues in the topic that could be an issue, and that is to switch the whole project to 32-bit mode and then the part that says that the Designer only shows 32-bit versions of the provider. ... What I think I'll try now, it to install the 32-bit version of the Oracle ODAC to see if that makes any difference. ... uninstall ODAC and when I uninstall the regular Oracle Client with the ...
    (microsoft.public.sqlserver.dts)
  • Re: If you connect to Oracle through .NET please help!
    ... ¤ I need to connect to an Oracle database. ... b) Do you need to download and install other Oracle files, ... You need to install and configure the Oracle client software. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Problem connecting to Oracle database
    ... ¤ Hi all... ... to an Oracle 7.3.4 database using MSDAORA provider. ... source and .NET Framework Data Provider for OLEDB as the data provider. ... the results and also I could see the connection in Server Explorer tab. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: If you connect to Oracle through .NET please help!
    ... ¤ I need to connect to an Oracle database. ... in order for the framework classes to even work. ... b) Do you need to download and install other Oracle files, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
    ... ¤ Hi ... System.Data.OracleClient requires Oracle client software version 8.1.7 ... Microsoft OLE DB Provider for Oracle ...
    (microsoft.public.dotnet.framework.adonet)