I have two system.
First one is: Windows Server 2003 .
Second One is : RedHat with Oracle10g installed
I have developed an .net(3.5)(asp.net, C#) application.Windows system is my application server and second system i have is oracle database installed. When I deploy this application in windows 2003 server it gives me following error :
Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.
my connection string looks like :
Provider=MSDAORA.1;Data Source=test1;Persist Security Info=True;User ID=username; Password=password
I am using OleDb.
I googled and found some solution:
1. OCIW32.dll : I have only one copy of this file.
2. IUSR_machine and IWAM_machine both have full control to oracle installation directory.