Connection from PB12.6 to Oracle9i at application layer

[Former Member]

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.

[Former Member]

Thank you all for helping.

We just found out the reason. It was actually the configuration in the .ini file, which specifies the database and application information for runtime.

There is a line in the .ini file:

[Database]

DBMS=o84 Oracle8/8i (8.x.4+)

we updated it to:

DBMS=o90 oracle9i 9.0.1

and that fixed the issue.

Thank you very much for the help anyways.

[former_member190719]

What was the value of SQLErrText for l_connection?

[Former Member]

Hi;

  Have you checked ...

1) O9I DB client software is installed.

2) TNS names is setup correctly.

Regards ... Chris

[Former Member]

Can you confirm that the connection parameters are the same in both cases?