Connect Excel VB to ORACLE without the Oracle Client installed. How?

Hi there,
the connection from Excel VB to Oracle 10g and 11g using the Microsoft OLE DB-Provider 'MSDAORA' and installed Oracle Client works fine with this connection string:

Provider=MSDAORA;Password=myPassword;User ID=myUser;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.122.101.15)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=myOraService)))

But on some client computers it is not allowed to install the oracle client. But the MS OLE DB-Provider is installed as part of the standard windows.

Is it possible to connect to an Oracle Database with the pure MS OLE DB-Provider?
What ist the correct connection string for that?

0 answers