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

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

  • nvilvovsky's avatar
    nvilvovsky
    New Member
    4 years ago

    how did you revert back to an old version?

  • ZeeshanUmar's avatar
    ZeeshanUmar
    New Member
    2 years ago

    Hi do you have odbc driver for Redshift Version 1.03.01.1000 files, I really need them but couldn't find them as they are no longer available