Exempel ADO import: OLE DB Provider for Oracle (from Oracle).

Connect string for standard security:

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;

For a Trusted connection:

OS Authenticated connect setting user ID to "/":
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB; User Id=/;Password=;");

OS Authenticated connection using OSAuthent:

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;

Note: "Data Source=" must be set to the appropriate Net8 name which is known to the naming method in use. For example, for Local Naming, it is the alias in the tnsnames.ora file; for Oracle Names, it is the Net8 Service Name.