MySQL ADO.NET driver is not available for Powerbuilder

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.

Comment

Damson Li
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.

Helpful 0

Armeen Mazda @Appeon
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.

There are no comments made yet.

Resolved MySQL ADO.NET driver is not available for Powerbuilder