Vista 64 bit

[ScottWN]

Trying to install version 7.15 on my Vista 64 bit maching has a couple of problems.

First is that is can not install into a directory that has () is the name. On a 64 bit machine, 32 bit program go into the Program Files (x86) folder. I installed in another directory but I am not sure if there are implications.

Second, once installed it can not find oci.dll even if I give it the current home.

Is there a problem on a 64 bit client platform?

 

[Marco Kalter]

First is that is can not install into a directory that has () is the name.

It can be installed there, but PL/SQL Developer warns you that some Oracle Net versions have a bug when connecting from a directory with parentheses.

Second, once installed it can not find oci.dll even if I give it the current home.

You will need to install a 32 Bit Oracle Client. PL/SQL Developer is a 32 Bit application, so it cannot interface with a 64 Bit Oracle Client.

The 32 Bit Oracle Client can communicate with a 64 Bit Server, even on the same machine if necessary.

 

[ScottWN]

Your right about the install path. I uninstalled PLSQL and re-installed into Program Files (x86), seem to install fine.

But I still get the OCI.dll error. I have installed the ODAC 10g 32 bit client that installs into \oracle\product\10.2.0\client_2\bin. Looking in that directory there is no oci.dll, there is a oci.dll.o.1.

This doesn't seem right to me, any suggestions?

 

[ScottWN]

Just for fun I changed the name of oci.dll.o.1 back to just oci.dll. Now I get my list of servers from the database dropdown on the oracle logon screen. Click on the OK and I get an empty dialog box returned.

Stopped PLSQL and reran as administrator, this time when I try to logon on I get a PL/SQL dialog with ORA-12154: TNS:could not resolve the connect identifier specified.

Still at a loss.

 

[ScottWN]

I think I have enough to work. I uninstalled all the oracle clients, and installed Oracle 11g ODAC 11.1.0.6.20 with Oracle Developer Tools for Visual Studio, this has some problems in VS2008 but PL/SQL seems to be happy.

Thanks.