SergeChel Log

Sometimes you have to code an Oracle connection and you don't have a way to modify tnsnames.ora. This is the way to solve this problem. Use this form of oracle connection string:

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;