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=188.8.131.52)(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?