Skip to content Skip to sidebar Skip to footer
Home / Amazon Redshift / Python

How Do I Connect To My Amazon Redshift Cluster Using Python?

Post a Comment
I have the ODBC url to my Amazon RedShift cluster. I wrote a simple Python script to connect to the cluster, however the connection keeps failing. I have tried the following connec

Solution 1:

Ok so after a lot of troubleshooting, I found the solution!

In the file 'odbc.ini', 'Driver32' had the following value:

Driver32=C:\Program Files\Amazon Redshift ODBC Driver\lib\AmazonRedshiftODBC64.dll

'Driver32' is pointing to a 64 bit file. As a result I downloaded the 32 bit driver and updated the path to:

Driver32=C:\Program Files (x86)\Amazon Redshift ODBC Driver\lib\AmazonRedshiftODBC32.dll

This has fixed the problem.

You may like these posts

Post a Comment for "How Do I Connect To My Amazon Redshift Cluster Using Python?"