Unable to connect to Oracle 11G using ASP.NET 32 bit application
I was using an ASP.NET 32 bit application which was running on a 64 bit Win 2008 R2.
Oracle client was installed on the machine (Both 32 bit and 64 bit versions).
The application was still not connecting to the database.
Then i created a UDL and tried to connect to the database which was running on another VM.
It didn't work either. Then in checked the Providers available on the VM.
On searching in Oracle forums, i found that MICROSOFT OLE DB PROVIDER FOR ORACLE is now deprecated by Microsoft.
But Oracle provides a Provider "ORACLE OLE DB PROVIDER" which solves the purpose.
I downloaded the provider and deployed it on the VM.
Hope this may help...................
No comments:
Post a Comment