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.
Matt Balent Accepted Answer Pending Moderation
  1. Thursday, 6 June 2024 02:00 AM UTC
  2. PowerBuilder
  3. # 2

Used ODBC to connect.  Tested both the Open Source and Devart drivers without issue.  If you have the AWS access to the Aurora DB you just use the url/port just like any other.  Set up a System DNS entry and used that in my PB db connection and application transaction object.

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