1. Sylvain .
  2. PowerBuilder
  3. Monday, 9 March 2020 17:32 PM UTC

Anyone know when MySQL version 8 will be supported for PB and PowerServer...

TIA

Sylvain

Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 9 March 2020 17:35 PM UTC
  2. PowerBuilder
  3. # 1

Is MySQL 8 not working correctly with PowerServer 2019 or 2020?

Comment
  1. John Murphy
  2. Friday, 15 May 2020 18:57 PM UTC
I started testing MySQL and had serious problems. I downloaded the eval version of CData MySQL ODBC Driver. It seems to solve my problems but it is expensive so I don't think it will work for me.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 9 March 2020 18:33 PM UTC
  2. PowerBuilder
  3. # 2

Hi Sylvain;

   From the PS2020 beta documentation ...

Appeon PowerServer 2020 can connect to any of the following database servers:

  • SAP SQL Anywhere 16.0 or 17.0 with SQL Anywhere .NET Data Provider driver

  • SAP Adaptive Server Enterprise (ASE) 12.5.x or 15.x with ASE native driver

  • IBM DB2 UDB 9.7 with IBM DB2 native driver

  • Informix 7.x, 8.x, 9.x, 10.x or 11.x with IBM Informix .NET Provider

  • Microsoft SQL Server 2012, 2014, 2016, 2017, or 2019 with MS SQL Server native driver

  • MySQL 5.5.x or 5.6.x with ADO.NET Data Provider driver

  • Oracle 11g or 12c with Oracle native driver

  • PostgreSQL 9.2 with PostgreSQL psqlODBC driver

 

  However, The PS 2020 documentation is still beta. I suspect that ASE 16.x and Oracle 18C/19C should be added to the above list as well.

I will check with engineering for you for a definitive answer.

Regards ... Chris

Comment
  1. Chris Pollach @Appeon
  2. Tuesday, 10 March 2020 15:12 PM UTC
Hi Sylvain ... Update: Engineering is still hoping to add support for MySQL 8 and O18C/19C for PS 2020 GA but at this time, they are still working through some functionality issues with each of those releases.
  1. Helpful
There are no comments made yet.
Sylvain . Accepted Answer Pending Moderation
  1. Tuesday, 10 March 2020 13:32 PM UTC
  2. PowerBuilder
  3. # 3

I did some test with version 8 and PB back in September 2018, the problem I had at that time was for some reason PB or the ODBC  was looking for the table mysql.proc  when a store procedure was called but that table do not exist anymore in MySQL version 8.

That why I'm asking if any special work was done on the PB side to fix this or it has nothing to do with PB and I'm missing something...

 

TIA

Sylvain

 

 

Comment
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 15 May 2020 19:01 PM UTC
  2. PowerBuilder
  3. # 4

We plan to support MySQL in PowerServer 2021.

Comment
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Saturday, 16 May 2020 13:38 PM UTC
  2. PowerBuilder
  3. # 5

Have you tried connecting using MySQL JDBC driver? I'm saying this, because we had problems connecting to a Tibero Database using ODBC. ODBC worked for some things but not all, especially when it came to stored procedure calls.

Tibero is not supported by Appeon so we used the jdbc driver and now everything works.

I haven't tried myself with MySQL so no guarantees.

https://docs.appeon.com/appeon_online_help/im2019r2/im_connecting_to_your_database/ch03.html

regards

Comment
  1. Miguel Leeuwe
  2. Saturday, 16 May 2020 13:43 PM UTC
I now see you also want to connect from powerserver. If it works for powerbuilder classic, it would probably not be a solution for PowerServer as most people setup powerserver for IIS and not for JBoss, Wildfly or similar.
  1. Helpful
There are no comments made yet.
Sylvain . Accepted Answer Pending Moderation
  1. Tuesday, 19 May 2020 13:26 PM UTC
  2. PowerBuilder
  3. # 6

 

Thank you Miguel for your post, I also had a response from Armen Mazda saying 2021 for the support of MySQL 8.

I do not understand why Appeon do not support better one of the most use database...

I found the following link, not too where the number come from

   https://db-engines.com/en/ranking

 

TIA

Sylvain

 

 

 
 
Comment
  1. Armeen Mazda @Appeon
  2. Tuesday, 19 May 2020 14:24 PM UTC
The answer is simple... because we don’t have many PowerBuilder customers demanding this. You can’t use such ranking and assume the demand among PowerBuilder customers is the same.
  1. Helpful
  1. Sylvain .
  2. Tuesday, 19 May 2020 14:40 PM UTC
Thank you Ameen for your answer, it make more sense to me now why.
  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.