I'm running Windows 7 (64 bit). In Service Center and while creating an Oracle connection, it fails with error:
Connection String test failed: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.
Sqlplus works fine at a command prompt.
I'm hoping you know an "easy fix"? I've already set the compatbility mode on the executables to Windows XP Service Pack 3 without positive results.
Support for ORACLE connection in the OutSystems Agile Platform 5.0 will only be available in February 2010 ( see the document Agile Platform 5.0 – Systems Requirements ). The connection to ORACLE is also supported only for 32-bit operating systems.
As a workaround, you can write a .Net or Java extension that connects to you ORACLE database and executes the desired statmentents in the target database.