1. Matt Balent
  2. PowerBuilder
  3. Tuesday, 16 April 2024 14:37 PM UTC

Has anyone connected their PB application to an AWS Aurora database (using PB 2022 R3)?  If so, what did you use to connect? ODBC? something else?

Thanks!

Roland Smith Accepted Answer Pending Moderation
  1. Tuesday, 16 April 2024 17:15 PM UTC
  2. PowerBuilder
  3. # 1

I had never heard of it so I did a search. Aurora is Amazon customized versions of MySQL and PostgreSQL.

They have special JDBC based drivers that you can use to connect:

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Connecting.html#Aurora.Connecting.AuroraPostgreSQL.JDBCDriverPostgreSQL

 

Comment
  1. Matt Balent
  2. Tuesday, 16 April 2024 20:48 PM UTC
Thanks Roland, I saw that same post. Wondering if PB dropping support for JDBC in 2022 would affect this? Anyway, my AWS contact says that ODBC Postgres drivers can be used with an Aurora endpoint so I'm counting on his knowledge (he did a quick connect application proof of concept). I will post the information later once I am further along.



Matt
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.