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

I submitted a ticket with PowerBi and they are working through their vendor that does the actual redshift connections. It's been two weeks.  I'll post when i learn anything of value. Not yet. But I do get updates.