Get Data Moving 1
Results 1 to 2 of 2

Thread: Ugrade to Replicate 4.0.8.25 - Redshift connection fail on SQL_ERROR SqlState: IM002

  1. #1
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    299
    Rep Power
    6

    Ugrade to Replicate 4.0.8.25 - Redshift connection fail on SQL_ERROR SqlState: IM002

    Upgrade to Replicate 4.0.8.25 - Redshift connection fail on
    SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [122502] ODBC general error.

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    299
    Rep Power
    6
    Since Replicate 4.0.8.25

    The Redshift Target database is using Amazon Redshift ODBC.

    Solution 1:
    You can just edit the Redshift Database connection, from the advanced tab, change the ODBC driver to : PostgreSQL Unicode(x64)

    Solution 2:
    You can download and install the Amazon Redshift ODBC 64-bit connection:
    Install and Configure the Amazon Redshift ODBC Driver on Microsoft Windows Operating Systems - Amazon Redshift

    Note you would need to restart the Replicate Service after installing the Amazon Redshift ODBC 64-bit connection.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •