Skip to Content
0

Facing issues after getting connected to Oracle database.

Aug 09, 2017 at 10:38 AM

58

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

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?

Show 3 Share
10 |10000 characters needed characters left characters exceeded
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.

0
Former Member

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

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

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

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.

Share
10 |10000 characters needed characters left characters exceeded