Hi I am trying to connect amazon redshift database using A360 but I am getting error Could not Connect to Database. [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified What driver should be installed

Hi @Vignesh M S​ ,

Checkout below details,

Create 32 Bit ODBC connection string using UDL file from the Microsoft OLEDB ODBC driver.

Sample connection string -

DRIVER={Amazon Redshift (x86)};AuthType=;Database=xxxx;EPWD=**;FILEDSN=local path\xxxx.dsn;IAM=0;Port=5439;Server=***;SystemWideEncryption=0;UID=**;

Additional InformationReferences:

https://docs.aws.amazon.com/redshift/latest/mgmt/configuring-connections.html

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-using-database-connect-action.html