Forum Discussion

merinmione's avatar
merinmione
Icon for Helper I rankHelper 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
th340385's avatar
th340385
Icon for Helper I rankHelper 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
    Icon for Helper I rankHelper 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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Are you using the Redshift connect in PBI or the PostGreSQL driver?

      • th340385's avatar
        th340385
        Icon for Helper I rankHelper I
        5 years ago

        I am using the Redshift connect in PBI. Everything worked great for the first 3 months. Randomly stopped working at the end of June.