Alternative location OCI.DLL

[Frank Huijbreghs]

Hi,

Is it possible to set the location of OCI.DLL to an another location?

Users on our terminalserver cannot see the C:\ drive and therefore Queryreporter cannot load OCI.DLL although the C:\ drive is available.

When running with C:\ drive visible Queryreporter runs whitout any problem.

Regards,
Frank

 

[Marco Kalter]

You can use the OracleHome parameter to specify the name (not a directory or file location) of a specific Oracle Home. For example:

queryreporter.exe OracleHome=OraClient11g_home1

The Oracle Home name must match the name of the Oracle Home as defined in the Oracle Registry.

 

[Frank Huijbreghs]

hi Kalter,

When i run this:

"C:\Program Files\Query Reporter\queryreporter.exe" OracleHome=KEY_OraClient12Home1

I get this message:

Unknown parameter: ORACLEHOME=

Any suggestions?

Regards,
Frank

 

[Marco Kalter]

You can alternatively use the OCIDLL= parameter:

queryreporter.exe OCIDLL=S:\Oracle\bin\oci.dll

In this case you may also need to set the TNS_ADMIN and NLS_LANG environment variables though.

We'll look into the OracleHome parameter issue.