1. Kyle Griffis
  2. PowerBuilder
  3. Wednesday, 9 January 2019 19:13 PM UTC

Hello everyone,

I am running into a General Application crash when running a 64Bit build. 

I am trying the Native Oracle driver against an Oracle client 18.  I can run the application through the debugger without issue, it's just the exe crashes when logging into the database.  I was wondering if anyone has experienced the same type of issue and what they did to track down the cause.

Thanks,

Kyle

 

 

 

 

Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 10 January 2019 23:00 PM UTC
  2. PowerBuilder
  3. # 1

FYI: we are running the 32 bit Oracle 12C driver against Oracle 18 databases in Windows 7 using PBv12.1 without any problems.

Olan

 

Comment
  1. Kyle Griffis
  2. Friday, 11 January 2019 14:04 PM UTC
Hi Olan,



We were trying to use the Oracle 18 driver, it's the 12 that is supported.
  1. Helpful
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 10 January 2019 13:59 PM UTC
  2. PowerBuilder
  3. # 2

You could run it with /pbdebug command line parm. It will write to a log file for every line of code executed. It runs slowly but it will help you locate the line of code.

Comment
  1. Kyle Griffis
  2. Thursday, 10 January 2019 14:22 PM UTC
Perfect, thank you sir!
  1. Helpful
There are no comments made yet.
Kyle Griffis Accepted Answer Pending Moderation
  1. Wednesday, 9 January 2019 21:27 PM UTC
  2. PowerBuilder
  3. # 3

Thanks Roland,

I am using the 64bit Oracle Client (18) with the 64bit PowerBuilder application which is using the Oracle Native driver installed by the PowerBuilder 2017 installer.  I also deploy the PB 64bit application with the proper 64 Bit PB runtimes.

I can't tell specifically what the issue is that is causing the Application Crash but it seems to be when it's trying to connect from the login window, we have been using the PFC for years so the framework I trust.  So I was trying to see if anyone has a method to see what PB does during runtime to see if something shows up as the cause.

Thanks again for helping me out.

 

 

 

 

 

 

Comment
  1. Chris Pollach @Appeon
  2. Wednesday, 9 January 2019 21:42 PM UTC
Hi Kyle;



As Roland already mentioned ... Did you install the Oracle client 64bit driver from Oracle. This is NOT the Oracle DB interface driver that comes with PB (PBORA170.dll). It would be a an Oracle supplied set of DLL's. For example, when installing the Oracle "Instant Client" driver suite. Also, make sure that your App is capturing the SystemError event to log any issues at DB connect time.



You could also try placing a TRY...CATCH around the DB Connect code and see if the caught "exception" object has more error information at the point of failure.



Regards ... Chris

  1. Helpful
  1. Kyle Griffis
  2. Thursday, 10 January 2019 14:42 PM UTC
Thanks Chris,



It was installed from the installer provided from Oracle. I think I found the issue, according to the documentation, pasted below, it appears that the Oracle Client 18 is not supported. So we are going to use the 12c client and see if that works. Chris is there any way for us to run a 64 bit PB application against a 32 bit Oracle client using some kind of wrapper object like perhaps ODBC? The need we have is scalability for deployment and support until the entire enterprise is converted to use a 64 bit database client. The goal is to see if we can get away from having to support 2 PB versions (32, 64 ) of our enterprise PB application.



Thank you for reaching back to me!





Supported versions for Oracle

...

The ORA database interface allows you to connect to Oracle 11g/12c servers using Oracle 11g/12c Database Client or Oracle 11g/12c Instant Client. ...

...

  1. Helpful
  1. Chris Pollach @Appeon
  2. Thursday, 10 January 2019 18:47 PM UTC
Hi Kyle;

Please let us know how your 64bit App works with O18 using the O12C client. That would be a "work around" until PB officially supports O18.

The answer to your ODBC wrapper question is No, The bitness is an App wide setting & via its compilation. Its either all 32bit or all 64 bit within one EXE ... sorry.

Regards ... Chris
  1. Helpful
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 9 January 2019 19:53 PM UTC
  2. PowerBuilder
  3. # 4

The database client has to be the same bitness as the application.

When running a 64bit app, you'll need the 64bit Oracle Client. The PB IDE is 32bit only so you'll also need the 32bit version.

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.