Facing issues after getting connected to Oracle database.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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?

[Former Member]

Yes i am able to retrieve from oracle client. My user have proper permission and i have also tried to reinstall the drivers many time.

[Former Member]

That seems like a driver issue. Can you retrieve using ODBC?

[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.