• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • MySQL ADO.NET driver is not available for Powerbuilder

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved MySQL ADO.NET driver is not available for Powerbuilder

  1. Issue
0
Votes
Undo
  1. Damson Li
    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)
2.jpg 2.jpg
1.jpg 1.jpg
3.jpg 3.jpg
PB 2018 and C# Datastore
Data Source for SQL statement starting with "WITH"
Responses (1)
Armeen Mazda @Appeon
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
Damson Li
  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
Armeen Mazda @Appeon
  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.