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

Resolved MySQL Integration with PowerBuilder ?

  1. How-to
0
Votes
Undo
  1. Deva Shanmuga
    Deva Shanmuga
  2. PowerBuilder
  3. Wednesday, 8 November 2023 08:32 AM UTC

Hi Experts,

My client is currently using a web application with MySQL as the database. We are planning to migrate the web application to PowerBuilder. Is it possible to continue using the same MySQL database with PowerBuilder? If so, could you please provide me with the steps to connect to the MySQL database from PowerBuilder?

 

Thanks 

Deva S

Dropdowndatawindow based on Stored Procedure retri...
How to set same theme for some group of windows an...
Responses (2)
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Wednesday, 8 November 2023 10:16 AM UTC
  2. PowerBuilder
  3. # 1

Hi.

You can connect to mySQL. The easier way is to install the ODBC Driver for MySQL (Connector/ODBC). You can find it at MySQL :: Download Connector/ODBC.

You must have in mind that while you can connect to mySQL, this database is not listed in supported databases by powerbuilder, which means Appeon may not provide support. MySQL is only supported in SnapDevelop (SnapDevelop 2022 Installation Guide (appeon.com)). Supported databases are: SQL Anywhere, Sap ASE, SQL Server, Oracle, Informix and PostgreSQL (through ODBC).

Andreas.

Comment
Kevin Ridley
  1. Kevin Ridley
  2. Wednesday, 8 November 2023 15:09 PM UTC
It should be easy to connect once you install the MYSQL ODBC driver, then create an ODBC connection for your db. In past versions of PB there was some tweaking needed in pb.ini settings to make it work best. Wish I could remember which settings (although might not be needed anymore). You can probably Google as Miguel mentioned to find out what these setting are.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 8 November 2023 10:14 AM UTC
  2. PowerBuilder
  3. # 2

I think it depends on which version of powerbuilder you have, for mysql to be officially supported or not.

Don't want to be blunt, but if you Google "Appeon Mysql" you should find a bunch of information.

regards.

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 8 November 2023 10:24 AM UTC
Hi Andreas,

I know, but now it seems officially supported.

https://docs.appeon.com/pb2022/connecting_to_your_database/MySQL.html

  1. Helpful 1
Andreas Mykonios
  1. Andreas Mykonios
  2. Wednesday, 8 November 2023 11:30 AM UTC
Wow... But I don't see it to supported databases.
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 8 November 2023 14:27 PM UTC
Lol, the link doesn't give much information either, probably on of those documentation errors.
  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.