Thursday, June 18, 2009

Unsupported Oracle data type USERDEFINED encountered.

Make sure that you use Oracle.DataAccess.Client instead of System.Data.OracleClient.

using Oracle.DataAccess.Client;

Oracle Host Credentials: Failed to verify credentials

To resolve this error, you need to set OS user name here

Control Panel-> Admin. Tools -> Local Security Policy -> Local Policies -> User Rights Assignment

Locate "Log on as batch job" Policy, right click and select properties

Add the OS User to "Local Security Setting" tab.