How do you set up a connection to Amazon Redshift? No driver is listed when trying to set up the DSN through Toad's connection window.
The driver and dsn created for the connection can be found in the ODBC Admin window when accessed directly from Windows.
Connection to Amazon Redshift is through ODBC. Toad Data Point only supports a 32 ODBC driver. If a 64 bit driver is installed it will not be recognized by Toad.
Please review Configure ODBC Connection which also includes a link to download, install, configure and test the connection.
Within Toad, launching the ODBC Data Source Administrator window will automatically open the 32 bit version of the manager, displaying the 32 bit drivers and DSN (Data Source Name) that was set up previously.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center