Connecting Oracle 9i database from PowerBuilder12.6

[BooneVA]

Hello,

We are trying to migrate PowerBuilder from 10.0 to 12.6. The database we have been using is Oracle 9i. There has been no issue connecting from PB10.0.
We tried the same DB configuration on PB12.6 to Oracle 9i. On the DB profile setup - Preview tab, "Test Connection" returned connection successful. Datawindows can also connect to DB and retrieve data without any issue.

However, at the Application level, we were not able to connect when running the executable.
l_connection = Create n_tr
l_connection.of_connect()
returned -1.

Note that driver pbo90126.dll does exist in local directory: C:\Program Files\Sybase\Shared\PowerBuilder

Could you advise why the development layer connection is established whereas the application layer connection is not?
Thank you.

 

[mbalent]

You have the exact connection parameters in the transaction object as you use in the db connection in the painter?

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com