Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sep 1, 2023 8:45:49 AM
Sep 1, 2023 8:45:49 AM
After upgrading the Qlik Replicate to 2023.5.0.322 and upgrading the Redshift driver to 2.0.0.8, testing the Redshift endpoint fails with the following error:
00004260: 2023-08-28T16:06:05:467371 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [1022502] (ar_odbc_conn.c:584)
00004260: 2023-08-28T16:06:05:467371 [SERVER ]E: Cannot connect to Cloud server [1022505] (cloud_imp.c:4397)
Resolution
To resolve this error, verify that the correct ODBC driver version is installed and is correctly named. The supported driver version is listed in Get started with Amazon Redshift. For Qlik Replicate May 2023, the version is 1.4.34.1000 or later.
If a later version of the driver is installed, such as 2.0.0.8, the driver name will have changed and may not match the one expected by Qlik Replicate. This can be resolved by editing the driver name in the Qlik Replicate Web Console.
To rename the driver:
- Open the Qlik Replicate Web Console
- Open your Redshift endpoint
- Open Advanced
- Review the ODBC driver name.
The default name is Amazon Redshift (x64), which is the name of the installed driver for versions such as 1.4.34.1000. Later versions, however, use a different driver name.
- For version 1.4.34.1000 the default name is correct
- For version 2.0.0.8, change the name to Amazon Redshift ODBC Driver (64-bit)
You can verify what the installed driver is named in the ODBC Data Source Administration panel in Windows (see Fig 02).
Cause
The installed driver is named Amazon Redshift ODBC Driver (64-bit), while Qlik Replicate expects Amazon Redshift (x64).
Environment
