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
Page 1 / 1
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.