1. Elvis Cardenas
  2. PowerBuilder
  3. Friday, 6 November 2020 01:53 AM UTC

Hice un STORE PROCEDURE en MySQL para empezar a conocer sobre este tema, con el siguiente SQL

Cuando quiero acceder desde el Perfil de Power Builder me sale error

Obviamente no me permite crear el Procedimiento de almacenamiento de Datawindows.
Sin embargo cuando no le pongo parametros al Store Procedure en MySQL funciona normal y me permite la creacion del objeto datawindow store procedure.

Debo hacer algun cambio en la configuracion del ODBC, del PowerBuilder o del SP en MySQL?

 

Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 6 November 2020 03:32 AM UTC
  2. PowerBuilder
  3. # 1

MySQL is not yet officially supported by PowerBuilder. An unsupported database over ODBC connection might work OK for basic SQL, but complex SQL or stored procedures are likely to fail.

 If you want to use a free open-source database, go with PostgreSQL.  

Comment
  1. Elvis Cardenas
  2. Monday, 9 November 2020 22:32 PM UTC
It is unfortunate to find out about it, it is impossible for me to use other databases because everything is in MySQL, and my team is a specialist in MySQL ... I doubt that switching to PostglesSQL is an alternative ... it seems that more ideal for me would be to leave PB .



Thank you.
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Monday, 9 November 2020 23:08 PM UTC
I understand. Hopefully, you can find workaround for your stored procedure issue. Or another option is consider converting your application to cloud app with PowerServer 2021. PowerServer 2021 supports MySQL.
  1. Helpful
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Tuesday, 10 November 2020 01:05 AM UTC
  2. PowerBuilder
  3. # 2

there are several database settings available in pb that control how the system interacts with stored procedure.  strip parameter names and call escape syntax are two examples of options that you should review

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.