SQL_response "provider cannot be empty" error

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

sql_response probe returns "provider cannot be empty" error when testing connection with ODBC driver selected 

Environment

DX UIM 20.4.x / 23.4.x

sql_response 1.81

Resolution

Please use the OLDEB driver and select the appropriate provider ( for example "Oracle for OLEDB" ) 

OLDEB is more comprehensive and modern provides also access to ODBC data sources, ODBC provides access only to relational databases