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
6 years ago

Hi merinmione 

 

Did you get any resolution to this?

 

I am having the exact same problem trying to access Greenhouse data via Redshift in Power BI and am really struggling to troubleshoot. We have tried the built-in Redshift driver in Power BI plus also other ODBC drivers but still experiencing errors. And I got the same feedback from Greenhouse and no other help from them.

 

I'd be grateful for any feedback or learnings you have!

merinmione's avatar
merinmione
Icon for Helper I rankHelper I
6 years ago

Anonymous I'm still having my issue and no help from Greenhouse either. Have you got any other update?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I've collected a support ticket and I've been collecting records for them. They're still investigating, but so far they think it's a problem with the Power BI Redshift driver, so they've scaled it to Simba. I'll update you if I get any progress

    • nvilvovsky's avatar
      nvilvovsky
      New Member
      5 years ago

      Hey, were you able to resolve this since you last posted? Dealing with the same problem and trying to get it to work.

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

        No, we are still getting the run around from Greenhouse.