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
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.

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
    Helper 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.  

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      That was my experience as well.  We were about to deploy our reports when the June PBI update hit and everything stopped working.

      • Epreisz's avatar
        Epreisz
        New Member
        5 years ago

        I wasn't able to get x64 PBI working with the x64 redshift drivers. I wrote a little program in C# so that I could get better error messages and found that I was able to get x86 redshift drivers to work. I downloaded x86 PBI and I'm able to access everything now. 

  • merinmione's avatar
    merinmione
    Helper I
    5 years ago

    redshift

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Interesting.  Are you able to refresh from PBI desktop as well?

      • merinmione's avatar
        merinmione
        Helper I
        5 years ago

        yes, but now that we are working from home, we have had to use a jump box because of greenhouse's requirement of storing the appropriate company IP addresses the request is coming from.