Oracle 64 vs 32 bit
Posted on 2011-03-16
Trying to install an application that is using Oracle database. Platform is Win 2008 Server (64bit) running as a domain controller. Downloaded and installed Oracle 11g (64 bit) and I'm able to connect to the database from a command prompt (sqlplus) as well as from a web browser.
After installing the application, the application will not start. It says "Unable to connect to database server". The application developer has checked into this and found that the oci.dll file in the system is 64 bit and that his application can only handle 32 bit.
Two questions come out of this:
1. Will it work ok to download Oracle 32 bit and install on the 64-bit platform?
2. Is there a way to get this to work on the 64 bit Oracle install (developer mentioned something about a 32-bit client....)