Originally posted by: johnxp

Hi anyone can help me with this issue?

Background: 

OS: Windows Server 2003 R2

DB: Oracle Server 11.2 (64-bit) only.

WTX: 8.3

First Issue: (-1027) Failed to load shared library.

I realized WTX 8.3 only works with 32-bit oracle, I replaced oci.dll 64-bit with 32-bit.

Now I am getting another issue: (-1005) Failed to connect to the database.

In dbl the error says: no existing connection was found.

I tried both url string and tns name, no luck.

url: 192.168.100.180:1521/SITDB

tns SITDB from tnsnames.ora.

Appreciate your help.

Thanks.

Originally posted by: paul.brett

I would have though just replacing one DLL would be inadequate, and the full 32 bit Oracle client would need to be installed.

You could use the Oracle TNSPING utility to confirm that the TNS name you're using is valid..

Please post the entire DB trace if possible.

Thank you.

Paul.

Follow me on Twitter

Originally posted by: johnxp

We are having many issues on installing 32-bit Client on 64-bit Oracle Server.

Finally we gave up and have to setup 32-bit Oracle Client on a different machine and make it work along with WTX8.3.

Thanks.