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

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

      • Epreisz's avatar
        Epreisz
        New Member
        4 years ago

        Not sure what was harder, configuring my ODBC connection or replying to this thread (it kept refreshing and not letting me reply).

        So, I set this up on another machine but this time being 32 bit wasn't enough. I needed to downgrade to older drivers. 32bit PowerBI with 32bit driver Version 1.03.01.1000 are working for me now. What a pain!