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
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi merinmione ,

 

do you use the Amazon Redshift Connector or an ODBC Connector?

 

 

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

    redshift. 

    • mwegener's avatar
      mwegener
      Icon for Most Valuable Professional rankMost Valuable Professional
      6 years ago

      Unfortunately I have no experience with Amazon Redshift.

      I always thought prepared statements would be the preferred (secure) query type.