Hi Techies,
Here is my problem description.
Our application requires .net framework 1.0, Microsoft .net Oracle Client, Oracle 10g client, MDAC 2.6, MS Office to be installed on Application Server and Oracle 10g Server on Database Server. Our client's production environment is Windows 2003 x64 R2 Enterprise Edition for both application as well as database server.
Now since .net framework 1.0 is not supported on 64 bit OS, we tried the following workarounds to run our application on the Servers provided: -
1) We installed .net framework 1.1 which was run in the emolution mode since direct support was not available for even .net framework 1.1. The our application started running but it couldn't connect to Oracle database.
2) So we tried to use Oracle Client 10g 32 bit version, but the Microsoft .net Oracle Client was not able to establish a connection with the database server.
3) Next we tried to use Oracle Client 10g 64 bit version, but the application could not load the OCI.dll file due to incompatibilities.
4) Finally we also tried to connect our local application to connect to the Database Server and it was getting connected.
From all the above observations we have concluded that as Microsoft is not providing support for .net framework 1.0 and 1.1 on 64 bit platform and Microsoft .net Oracle Client Data Provider is a part of .net framework, it is unable to function on a 64 bit environment.
Hence the only way out is to have 32 bit environment. Is it correct conclusion? Please help us ASAP, as we are in deployment phase and client is sitting right on our head.
Thanks and Regards,
Rupesh.