Data source name not found

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Detailed Description and Symptoms

When starting a WP or CP for the first time, you may receive the error message:

U0003590 DB error: 'SQLDriverConnect', 'ERROR ', 'IM002', 'Data source name not found and no default driver specified'

Investigation

1) Check to be sure you are using the correct SQLDRIVERCONNECT= setting in the ucsrv.ini file (for instance, if using Oracle, be sure to comment out the SQL Server SQLDRIVERCONNECT= setting)

2) Check that your ODBC connection name and the DSN= in the SQLDRIVERCONNECT= setting are the same

3) Be sure that the SQL Native Client is being used for the ODBC connection. This can be found by viewing the following in the WP or CP log file:

   U0003535 DB INFO: 'DRIVER-NAME           = SQLSRV32.DLL'

   SQLSRV32.DLL is for the regular ODBC connection. In order to confirm that you are using the Native Client, this line should like one of the following:

   U0003535 DB INFO: 'DRIVER-NAME           = sqlncli10.dll'
   U0003535 DB INFO: 'DRIVER-NAME           = SQLNCLI.DLL'

   These include SQLNCLI* in the name which means it is the Native Client.

Solution

1) If you are attempting to run the Automation Engine on Oracle, be sure that you are using the correct SQLDRIVERCONNECT= setting in the ucsrv.ini.

2) This error can be caused by using the incorrect ODBC connection. Double check that your ODBC connection has the same name as the DSN= in your SQLDRIVERCONNET= setting in ucsrv.ini

3) This error can be caused by not using the SQL Native Client for your ODBC connection. This can be found by viewing the following in the WP or CP log file:

   U0003535 DB INFO: 'DRIVER-NAME           = SQLSRV32.DLL'

   SQLSRV32.DLL is for the regular ODBC connection. In order to confirm that you are using the Native Client, this line should like one of the following:

   U0003535 DB INFO: 'DRIVER-NAME           = sqlncli10.dll'
   U0003535 DB INFO: 'DRIVER-NAME           = SQLNCLI.DLL'

   These include SQLNCLI* in the name which means it is the Native Client.

Problem Persists:
If you have attempted the above and are still seeing the same error, please send the following to Automic Support:

1) The full CP or WP log file where this message is being displayed
2) A screenshot of the ODBC connection name and successful connection test