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