My Oracle Support Banner

Error Configuring Database Connection 20036; 16389 "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" (Doc ID 1415770.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Oracle WebCenter Capture 10g - Version 10.1.3.5.1 and later
Oracle WebCenter Distributed Capture - Version 10.1.3.5.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to configure WebCenter Enterprise Capture to connect to an Oracle Database with a complicated connection string, they are able to configure the DB connection and test the connection and initialization is reported as successful. However, when reopening Capture the following messages are displayed:


Login failed.
Error number:20036
Error Description: [The following error occurred connecting to the database:
Error Number 20036
Error Description: The following error occurred connecting to the database:
Error Number: 16389
Error Description: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]


followed by:


The following error occurred connecting to the database:
Error Number: 16389
Error Description: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


The data used for the connection string is for the "Oracle Provider for OLE DB" and the data source specified is:


(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=machinename_01.oracleoutsourcing.com)(PORT=10710)))(CONNECT_DATA=(SERVICE_NAME=DFAFC010)))


Attempting to configure for the smaller TNS Name in Capture for this connection results in error:


ORA-12154: TNS:could not resolve the connect identifier specified

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.