1. CJ Lai
  2. PowerBuilder
  3. Wednesday, 24 July 2019 13:30 PM UTC

Hi all,

I have two tasks at hand for which I need your input and/or advice:

1 - I have an application that was built in Powerbuilder 5/32 bit. (Yes, PB 5) with a back-end of Oracle 8i/32bit database. In the PB IDE database DB painter, I got drivers for Oracle 7.1 / 7.2 and 7.3 in the dropdown list in the profile setup, which are not working. Those options got 

ORA-12560: TNS:protocol adapter error

Please keep in mind, this is all in PB5 IDE.

I have the Oracle Client installed, the Home path set, verified the home entry in the registry (it is under WOW6432Node under Software instead of Oracle under Software)

After re/searching online, I believe a PBO8xxxx.DLL would work for me.
But, for the life of me, I can not find any on the internet. I understand it's a very, VERY old software and it was from Powersoft.

Am I missing something or is there any solution or hope for this application to connect to Oracle 8i in its current setup?


2 - Should all hopes fail, we are migrating the PB5 app to PB 12.5. (I know you will ask why this is the second option. I was told we should give option 1 a fair shot)

I would utilize the migration tool that comes with PB 12 and I understand there will be output of some obsolete function and event calls as well as some data type changes (string vs char and Ansi vs Unicode).

Also, I expect some changes in the PFC class.

Are there any other concerns or places where I should pay closer attention to or should watch out for?

Thank you all for your input

CJ



Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 24 July 2019 18:56 PM UTC
  2. PowerBuilder
  3. # 1

One thing to remember is that PowerBuilder connects to the Oracle software on the client, not the database.

When using the native interface you have to match the PB interface version to the Oracle Client version.

Using ODBC should allow you to connect using Oracle Client software version matching your database but you'll need to be careful to not use any Oracle features (new data types or functions) that were added after 7.3.

Comment
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 24 July 2019 18:45 PM UTC
  2. PowerBuilder
  3. # 2

1. In the Database Painter of your PB IDE, you should have  ODBC as one of the listed connection types.
    If you do not, then re-install the PowerBuilder application and ensure that both Oracle and ODBC are selected.

2. Open the ODB ODBC option
    Expand the UTILITIES folder
    Double-click the ODBC Administrator

3. Create a Data Source Name (DSN)
    a. Click on the SYSTEM DSN tabpage
    b. Look for Oracle
    c. If Oracle does NOT exist, click the ADD button on the right
    d. Find the appropriate Oracle entry
         - Note, you will need to have an Oracle Client installed on your platform in order to get these entries
    e. Select the appropriate entry (like Oracle in OraClient11g_home1), and click the FINISH button
    f. Complete the Oracle ODBC Driver Configuration page
       - Data Source Name = whatever you want, like Oracle 12 Cust01
       - Description = whatever you want
       - TNS Service Name = the Service ID from the TNSNAMES.ORA file
       - User ID = your user ID to the database



       - Click the TEST CONNECTION button, enter your password, and click OK....


       .... and you should see this:


       - Click OK, and OK, which returns you to the ODBC Data Source Administrator.
         Notice that my new DSN is listed:


       - Click OK. You are done.


Later -

Olan

Comment
  1. CJ Lai
  2. Thursday, 25 July 2019 11:46 AM UTC
Most awesome and appreciated! Thank you, Olan, very much! - CJ
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 24 July 2019 14:44 PM UTC
  2. PowerBuilder
  3. # 3

Hi CJ;

   FYI: Both Sybase and SAP versions of PB - that is v12.6 and below - are no longer supported by SAP. My suggestion is also to move to Appeon PB instead as your option #2.

  Note that the PFC is now "Open Source". FYI:  https://github.com/OpenSourcePFCLibraries

Regards ... Chris

Comment
  1. CJ Lai
  2. Wednesday, 24 July 2019 17:43 PM UTC
Hi Chris

Thank you for your input. I will bring the support, or the lack thereof, issue to my client. I don't think they will be willing to move from 12 as the application only deals very small portion of the daily business. It's been in place for 20 years after all...
  1. Helpful
There are no comments made yet.
Kevin Ridley Accepted Answer Pending Moderation
  1. Wednesday, 24 July 2019 13:48 PM UTC
  2. PowerBuilder
  3. # 4

1 - you can probably setup an ODBC connection to Oracle 8 

2 - you'd be crazy to migrate to 12.5 instead of PB2017 or PB2019, unless it was a middle step to get to the current version.

Comment
  1. CJ Lai
  2. Wednesday, 24 July 2019 17:39 PM UTC
Hi Kevin

I am not crazy but my employer is... ¯\_(ツ)_/¯



Could you, by any chance, point me to how to set up an ODBC in PB5 to Oracle 8, please? I'd appreciate it.
  1. Helpful
  1. Kevin Ridley
  2. Wednesday, 24 July 2019 18:23 PM UTC
  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.