*** Archive *** Oracle Database Connection String

Question / Problem: 

What is a possible database connection string to the Oracle Database

Answer / Solution: 

Oracle Connection String without the TNS names.ora

Connection String Syntax

Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));User ID=myUsername;Password=myPassword;

Example

Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mydbserver.net)(PORT=5502))(CONNECT_DATA=(SERVICE_NAME=abcoracle)));User ID=kofax_app;Password=kofax_ocr_app;

Applies to: