our PB 12.5 application works perfectly on an XP box connecting to 32-bit local Oracle 10g and a 32-bit national Oracle 11g database. With the Windows 7 rollout, we must now connect to a 64-bit local Oracle 11g database and the 32-bit national Oracle database simultaneously. It appears that we cannot. We have two version of Oracle installed - the 64-bit local and 32-bit client. The oracle_home in the registry refers to the 64-bit local. If I change this to refer to the 32-bit client, the listener immediately stops working.
The 64-bit sqlplus can access both the 64-bit oracle database and the 32-bit national database. My .NET applications can also access both applications simultaneously.
However, If I try and create a database profile through PB12.5, I get an Ora-12557 protocol adapter error. If I try and run the application, I get the OCI.DLL cannot be loaded message.
Does anyone have any idea how I can connect to BOTH 64-bit and 32-bit at the same time.