Question

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

  • 20 September 2022
  • 1 reply
  • 30 views

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

1 reply

Userlevel 5
Badge +8

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

 

Reply