1. Glenn Barber
  2. PowerBuilder
  3. Sunday, 13 August 2017

HI - our PB 12.6 app is currently running on SQL Anywhere V16 and we are considering a move to PostGresql or MariaDB for the future with PB2017

Can anyone comment on usability and stability of PB2017 with MariaDB or PostgreSQL?

Dan Cooperstock Accepted Answer Pending Moderation
0
Votes
Undo

I was able to quite easily port my PB apps from Firebird SQL to PostgreSQL.

However, I'm seeing from a couple of sources now a preference for MySQL over PostgreSQL. Does anyone else have comments about that? Thanks.

Comment
There are no comments made yet.
  1. Tuesday, 15 August 2017
  2. PowerBuilder
  3. # 1
Gerry Whitmarsh Accepted Answer Pending Moderation
0
Votes
Undo

Hi,

I have been using MySQL with ODBC for years now. It also works flawlessly with PB 2017. No “tweaking” of PBODB170.ini either.

Good luck,

Gerry.

Comment
Indeed we have use MYSQL with PB out the box. I wonder what the driving force is to use these other DBs.



If you are looking for a free BD, then you have MS Sql Express, Oracle Free version (although they are withdrawing that I think), MYSQL. All of which are going to work with PB.

There are no comments made yet.
  1. Monday, 14 August 2017
  2. PowerBuilder
  3. # 2
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Glenn;

  Neither MariaSQL or PostgreSQL are directly supported by PowerBuilder 2017 at this time. You can use middleware like ODBC to connect to these DBMS however, you will probably then need to manually tweak the PBODB170.ini file settings accordingly to align with your ODBC driver choice.

FYI: See PostgreSQL thread 

Regards ... Chris

Comment
There are no comments made yet.
  1. Monday, 14 August 2017
  2. PowerBuilder
  3. # 3
  • Page :
  • 1


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