PowerBuilder & MySQL Problem: Tips & Tricks

For a months, I’ve been included to join a latest research on a team about an application written from PowerBuilder & MySQL. After struggling hard with it, so many incompatibility found through out PowerBuilder 7 within MySQL 5 backend connection. I don’t have any idea why it’s happened since I though they both is a robust already application. I’d choose MySQL 5 since it has sub query features enabled whether than previous version which it so helping us a big hand to make a high-level query. I’ll describe some of the problems we had face:

1. Error Resulted with Select Sum, Count, Max or Min Query
At first, we’re confused with this since the query resulted an error. However, this could be solved by adding an option=135168 in dbparm string connection.

ConnectString(e.g.,sqlca.dbparm="ConnectString='DSN=mysql;UID=root;PWD=123456;OPTION=135168',PBUseProcOwner="NO"")

2. Error Resulted in Query Select Where on DataWindow
Filtering record with select where query resulting truncated selected row (ODBC error no.#01004).



This also weird things happened around since we didn’t playing with string truncation except just a plain simple query. The answer is simply to turn on the Disabled Bind option check box in Database Profile Setup



3. Very Uncomfortable Development Environment – In My Opinion
Again – in my opinion – the RAD environment of PowerBuilder to modifying the database are too difficult. There are no MySQL front-end application better than MySQLFront. The PowerBuilder it self concept are persistent to define the final tables before it start to proceed the development process. Once you make a mistake to define the length of a field, you have to rebuild the table from PowerBuilder & then re-compile the program. Very weird – In my opinion… as I said before.

4. Fault on Numeric Type Data in PowerBuilder (Very Significant Problem!)
A crucial matter happened when having a row transaction with decimal or numeric data type. A decimal data type which exist in MySQL wouldn’t recognized properly from PowerBuilder since it will display an empty string on Data Type column in Database Connection window. And so on eventually happened also in numeric data type.

Define data type from MySQLFront


View data type from PowerBuilder


However, as we have much troubles & complicated within it, we temporary solved to downgrade the MySQL into version 4 as the quick trick. The potential problem as described as no #4 above are suddenly lost. Now, we are waiting for any future severe that we don’t hope actually. We just only need a grips of lucky strike…

Labels: ,

Sincerelly,

Eko Wahyudiharto
PS: If you've benefit from this blog,
you can support it by making a small contribution.

Enter your email address:

Delivered by FeedBurner

Post a Comment Bookmark and Share

 

  1. Anonymous indrayusmita said,

    Thursday, November 15, 2007 2:55:00 PM

    aku ada informasi nih buat bapak mungkin menarik. dan saatnya kita mencoba untuk melakukan bisnis online di internet http://www.Invescria.com?id=indra.
    kunjungi dan pastikan anda untuk join karena ini sangat bermanfaat

  2. Anonymous Anonymous said,

    Wednesday, November 28, 2007 7:36:00 PM

    hi there,
    i have some strange effects during developing in PB (10) with MySQL (4). i had to learn to deal with.
    but in production everything is stable.

  3. Blogger Eko Wahyudiharto said,

    Thursday, November 29, 2007 9:04:00 AM

    @anonymous: What was your strange effects anyway?

  4. Anonymous Anonymous said,

    Tuesday, July 22, 2008 1:23:00 PM

    Mas Wahyu, tolongin aku donk. Aku lagi develop aplikasi client server pakai PowerBuilder & MySQL. Kalo develop trus di compile aplikasinya bisa jalan pake connectionstring yg udah Mas Wahyu terangin sama setting DNS nya pake driver MyODBC. Tapi kalo jalaninnya di client gimana ya caranya ? pake DNS juga ya? tapi koq gak konek sich ? :(
    Oh ya, aku pake powerbuilder 8.0, mySQL 5.0 dan MyODBC ver. 5.1

    Kalo Mas Wahyu ada waktu, kirim aja tips n triknya ke emailku di precorgians@gmail.com

    Thanks ya mas

  5. Anonymous RolandoG said,

    Friday, September 05, 2008 1:32:00 AM

    HI, How did ou solve the transaction issue, where an Uodate from one session is not vissible to other sessions, How Can I make it visible? I am using commit but nothing happens unless I close the 2nd session and open it back. it is killing me, Thanks

  6. Anonymous Anonymous said,

    Monday, November 17, 2008 2:16:00 PM

    saya ada masalah nih, mohon pencerahannya.
    saya bermaksud mengkonversi program applikasi yg menggunakan poer bulder kedalam bentuk web, untuk itu saya install appeon server di win2000 server.
    ketika program itu saya akses melalui client ber-OS winXP tidak ada masalah,applikasinya muncul di web ( boongan ),
    tapi ketika saya pake client Linux, halaman webnya menjadi blank ( saya sudah install wine, cabextract, Ies4Linux untuk mendukung itu semua ), apakah ada yg salah atau kurang di langkah2 saya atau gimana yah ?

  7. Anonymous Anonymous said,

    Monday, November 17, 2008 2:20:00 PM

    aya ada masalah nih, mohon pencerahannya.
    saya bermaksud mengkonversi program applikasi yg menggunakan power builder kedalam bentuk web, untuk itu saya install appeon server di win2000 server.
    ketika program itu saya akses melalui client ber-OS winXP tidak ada masalah,applikasinya muncul di web ( boongan ),
    tapi ketika saya pake client Linux, halaman webnya menjadi blank ( saya sudah install wine, cabextract, Ies4Linux untuk mendukung itu semua ), apakah ada yg salah atau kurang di langkah2 saya atau gimana yah ?

  8. Blogger jackob said,

    Thursday, September 23, 2010 5:28:00 AM

    Hi dude,
    i read your blog,This is a wonderful blog.I was able to get the
    information that I had been looking for. Thanks once again.
    PowerBuilder

Post a Comment

Leave comments here...