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

Resolved SUPPORT FOR MYSQL

  1. Misc
0
Votes
Undo
  1. Elvis Cardenas
    Elvis Cardenas
  2. PowerBuilder
  3. Wednesday, 12 September 2018 00:30 AM UTC

when it includes the support for mysql I still have many problems with a simple "select count (*) from table" or edit columns from the PowerBuilder 2017 database manager

Error: 37000

Attachments (1)
Sin título.png Sin título.png
.net components for PB2017
SyntaxFromSql causing ansinull to change
Accepted Answer
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Wednesday, 12 September 2018 06:38 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Elvis,

the problem is due to mismatch ANSI/UNICODE between your MySQL and the ODBC connector.

You are using version 5.1, please upgrade to 5.3 and try again.

Best,

.m

Comment
There are no comments made yet.
Responses (4)
Shenn Sellers
Shenn Sellers Accepted Answer Pending Moderation
  1. Wednesday, 12 September 2018 16:08 PM UTC
  2. PowerBuilder
  3. # 1

We have been using a MySQL database in one of our applications for quite some time.  We created it using PB 12.5 and it is now on PB 2017 R3.  We haven't had any problems performing any SQL commands.  I see you are using the 5.1 version of the MySQL drivers.  We use the 5.2 version, so maybe try that version or one that is higher.  Also, make sure that your ODBC entry follows the same settings on the SYNTAX tab as I attached.

Attachments (1)
MySQL.png MySQL.png
Comment
There are no comments made yet.
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Wednesday, 12 September 2018 05:37 AM UTC
  2. PowerBuilder
  3. # 2

10 years ago I wrote an PB Application (PB 9) that connected to MySQL using ODBC.

To get it work I added some sections for MySQL to PBODBxx.DLL so Powerbuilder knows about the syntax.

Unfortunately there is only a small documentation of the syntax of INI at the end of the INI file so it was a little bit trial&error...

Comment
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 12 September 2018 03:47 AM UTC
  2. PowerBuilder
  3. # 3

Sorry this is not on our roadmap right now.  We just added PostgreSQL.  If MySQL is really not usable for you and you would like an alternate open-source option please consider PostgreSQL.  PostgreSQL's open-source license is very liberal.

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.