Getting OCI.dll issue in PowerDeisgner 16.5

[Former Member]

Hi,

When I am getting OCI.dll cannot be loaded issue when trying to generate the DLL scripts in PowerDesigner 16.5.

[marc_ledier]

Hi,

It sounds as if you selected the database as source of modification.

Therefore, PowerDesigner try to connect to the database in order to get the objects you want to compare, and create the modification script).

In that case, you need to setup a connection to the database you want to use as source.

In your case, you probably tried the connection profile and PowerDesigner claims you cannot load the OCI probably because you don't have the correct Oracle client installed (platform compatibility 32/64 bit).

You may want to try an ODBC connection as an alternative, or even a JDBC connection profile.

In an other hand, using an archive model (a previous version of the model, saved as archive) would not need any connection and allow you to work disconnected.

Marc

[Former Member]

Thanks Ledier.

You want to setup a connection to the database you want to use as source -- Can you please give me more details how to achieve this.

We have Oracle 32 bit client installed on the machine and PD is 64 bit -- will its a prob?

ODBC -- failed to connect

[marc_ledier]

Yes.

Having a difference of platform (32 vs. 64) will prevent connection.

You need to either install Oracle 64b client or work disconnected.

Setting up a connection is described in documentation

Data Modeling

     > Building Data Models

         > Generating and Reverse-Engineering Databases

             > Connecting to a Database

Marc

[Former Member]

Thanks Ledier.

Will go for 64 bit Oracle client.

[c_baker]

What is your 'Generation type' when you generate the database - 'Script' or 'Direct' (on the Database->Generate Database../General tab)?.

I would expect this error if you are trying 'Direct' generation and you have not configured the path correctly to find the Oracle OCI libraries, or are perhaps using the wrong type of driver (e.g. 32-bit vs. 64-bit) depending on whether PD is 32-bit or 64-bit.

If you just want to generate the script, use 'Script' generation.

Chris

[Former Member]

Thanks Baker.

We are using the "Script" generation option.

We are using PD 16.5 64 bit client.

For this we need the 64 bit driver? If so what software we need to install in our local.