Skip to Content
avatar image
Former Member

Need PowerBuilder plus Oracle related info

Hi,

In my current project i am going to work with PowerBuilder with Oracle, i had worked with SQL server.

Now i would like to know what are the prerequisite to use oracle, what would be the difference from SQL server from PowerBuilder developer point of view.

Means while making a connection to database from PB ?

are there any environment variable which i need to set ?

I am asking all this as i have a application which is throwing below error.

-----------------------------------------------------------------------------------------------------------------------

--------------------------- Error connected to *** database Oracle library OCI.DLL or ORA803.DLL could not be loaded. --------------------------- Try again in a time and it isn´t be able to contact to the administrator Oracle library OCI.DLL or ORA803.DLL could not be loaded. --------------------------- OK ---------------------------

---------------------------------------------------------------------------------------------------------------------- Please help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 02, 2017 at 06:43 AM

    Hi,

    the Oracle Client should be installed. The application needs to find some files from "bin" directory of the client installation. So you should add it to the PATH environment variable.

    The client installation also creates a ORACLE_HOME environment variable. It points to the directory where the Oracle Client is installed. And there are some registry settings.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 02, 2017 at 04:46 PM

    What version of PowerBuilder & what version of Oracle?

    In general, the database driver (O83, O84, O90, etc.) has to match the version of Oracle Client installed. The Oracle server wouldn't have to be the same version as the Oracle Client. You would only be able to use Oracle features available in the version of Oracle Client used.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 02, 2017 at 04:18 PM

    Hi,

    There are some information that could help you:

    Support for Using PowerBuilder and Oracle:
    https://wiki.scn.sap.com/wiki/display/SYBPB/Support+for+Using+PowerBuilder+and+Oracle


    Preparing to use the Oracle database (Here you could find more information related to ORACLE)
    http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc37776.1250/html/connpb/CCJEAHBJ.htm

    Regards.

    Luis.

    Add comment
    10|10000 characters needed characters exceeded