SQL Developer

Hi,

Being trying to configure and use the Connect Identifier rather than the Network Alias but I get the following error;

Status : Failure -Test failed: C:\app\nkansahd\product\12.1.0\client_1\ocijdbc12.dll: Can't load IA 32-bit .dll on a AMD 64-bit platform

I am using;

sqlplus "user1/xxxxx@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=anda1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME = DELTA)))"

This works on the DOS prompt.

I can't however get this to work with SQL Developer. I tried this;

"user1/xxxxx@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=anda1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME = DELTA)))"

then this;

user1/xxxxx@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=anda1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME = DELTA)))

then this;

@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=anda1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME = DELTA)))

then this;

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=anda1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME = DELTA)))

And none works.

I used the jdbc side of things and it works nicely.

The Network Alias also works. I just have a requirement to use Connect Identifier. I have tried other variants of the string and they dont work. I keep trying though.

Does anyone know which one to use?

Thanks,

Derek