AE DB LOAD returning U00003590 UCUDB - DB error: 'SQLDriverConnect', 'ERROR

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation
• CA Automic Operations Manager

Issue/Introduction

Running a JOBP that calls the ucybdbld utility to import a transport case shows the following error message in the DB Load log:

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

 

Environment

Release : 12.3.8, v21

MSSQL Server

Cause

This is an error message specific to MSSQL Server. The DSN "IM002" doesn't actually exist - this is like a placeholder for the error message.

The SQLDriverConnect connection string requires that the actual driver name be specified in the string.

Resolution

To fix this, update the connection string in the ini file to include the driver name from the ODBC Datasources dialog.

If your DSN dialog shows the following:

That name "ODBC Driver 17 for SQL Server" must be part of the connection string in the [ODBC] section as follows:

SQLDRIVERCONNECT=ODBCVAR=NNNNNNRN,Driver={ODBC Driver 17 for SQL Server};Server=tcp:[hostname],1433;Database=[db_name];Uid=[user_name];PWD=[password;MARS_CONNECTION=Yes;TrustServerCertificate=YES;AutoTranslate=NO

where [hostname] is your SQL Server host, [db_name] is your Automic DB name, [user_name] is your DB username, and [password] is your DB user password. Verify the DB port as well, but 1433 is default for SQL Server.