1. Damson Li
  2. PowerBuilder
  3. Tuesday, 17 July 2018 03:48 AM UTC

Dear all,

When I used Powerbuilder 2017 R2 classic to connnect MySQL 5.7.17 at Windows Server 2012 R2 via ADO.Net 6.9.10 provided by MySQL, there is issue to show "No procedure parameter found" after calling mysql store procedure. When I open powerbuiler database panel, and found no parameter for each store procedure as attached screenshot.

I tried to upgrade MySQL ado.net driver to the newest version, but same issue happening.

The connection setting is as below:

SQLCA.DBMS = "ADO.Net"
SQLCA.LogPass = <*********>
SQLCA.LogId = "root"
SQLCA.AutoCommit = False
SQLCA.DBParm = SQLCA.DBParm = "Namespace='MySql.Data.MySqlClient',Database='bss_wms',PROVIDERSTRING='Server=localhost;Port=8806;Encrypt=no;Database=bss_wms',TrimSpaces=1"

Using that setting, it is fine to run select, update, delete SQL & datawindow, only cannot call store procedure.

By the way, the ADO.Net driver is from https://dev.mysql.com/downloads/connector/net/

However, when I switch the driver from ado.net to JDBC (also from MySQL), all are fine !!!

Is there anyone to help for the case, so that I can use ado.net to run MySQL store procedure?

Thanks a lot.

Attachments (3)
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 17 July 2018 04:09 AM UTC
  2. PowerBuilder
  3. # 1

MySQL is not an officially supported database of PB 2017 R2.  PostgreSQL is.  Are you too deep in MySQL that it is not feasible to switch to PostgreSQL?

Comment
  1. Damson Li
  2. Tuesday, 17 July 2018 06:09 AM UTC
Thank you for your comment Armeen. I am deep in MySQL with a lot of store procedure, so have to be used MySQL, but can switch from Powerbuilder to others.
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Tuesday, 17 July 2018 06:28 AM UTC
Have you tried using ODBC driver. ODBC usually works well with databases that are not officially supported by PowerBuilder.
  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.