Oracle XE, VB6 ADO using OraOLEDB.Oracle
Connection string
This Oracle Provider for OLE DB connection string can be used for connections to Oracle.
Provider=OraOLEDB.Oracle;dbq=localhost:1521/XE;Database=myDataBase;
User Id=myUsername;Password=myPassword;