Skip to Content
avatar image
Former Member

Facing issues after getting connected to Oracle database.

Hello All,

I am trying to connect to oracle database and I am able to do it successfully (From database painter i get Connection successful message), but when i am trying to expand the tables Powerbuilder is getting crashed.

Apart from that i am also able to connect to database through code, but when i try to retrieve the data i get zero rows.

I am currently using PowerBuilder 12.6, Oracle 9.2 database, as this is a new project we were not able to find drivers for Oracle 9.2 so we have installed oracle 10G (10.2).

As per my understanding database is not getting connected and i am getting false messages.

Could it be a driver issue ? or this is something else.

Let me know if you need any information from my end.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Aug 09, 2017 at 01:22 PM

    This can be a number of issues. Can you connect and retrieve using Oracle client? Does your user have proper permissions? Did you try reinstalling the driver?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I am able to understand when you say connect using ODBC ? I am using to oracle client to connect and retrieve the data but from Powerbuilder i am getting error.

  • avatar image
    Former Member
    Aug 11, 2017 at 01:30 PM

    There are two ways you can connect from PowerBuilder. You can use a native client which is what you are doing or you can use ODBC. ODBC is like a middleware between Powerbuilder and the Oracle driver. In your case since you have incompatible drivers, ODBC might be the way to go.

    Open the ODBC admin panel from %windir%\sysWOW64\odbcad32.exe (as admin) and then configure your Oracle database as a system datasource.

    Add comment
    10|10000 characters needed characters exceeded