Forum Discussion

merinmione's avatar
merinmione
Helper I
6 years ago

Prepared statements? Amazon Redshift ODBC Error prepared statements

hi, i'm trying to connect to an Amazon redshift database to get Greenhouse data (recruiting system) but i keep getting an error.   DataSource.Error: ODBC: ERROR [42P05] [Microsoft][Amazon Redshift]...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Any luck resolving this issue?  I'm running into the exact same problem.

  • th340385's avatar
    th340385
    Helper I
    5 years ago

    I am having the same issue as well. Did you happen to resolve yet? We have reached out to GH and they are pointing the issue back to Microsoft. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      No, I didn't have any luck.  GH referred me to their PostGreSQL alternative.  Which works, but is slower and will result in truncation errors for certain tables.

       

      • merinmione's avatar
        merinmione
        Helper I
        5 years ago

        After the back and forth between Msft and GH, I started using a data gateway to get to GH data and it resolved itself.