Search code examples
asp.netoracledatabase-connectionoledb

MSDAORA provider not found for asp.net site

I've got stuck with strange Oracle connection error on Windows Server 2003 x64 (IIS 6)

While console .Net application that runs onbehalf of administrator successfully connects to Oracle 10g Express via OleDb [Connection string looks like: Provider=MSDAORA;Data Source=server-ip:port;User Id=user;Password=password;]

ASP.NET 4.0 web-site (application pool runs on behalf of administrator too) fails with error: The 'MSDAORA' provider is not registered on the local machine

Connection string is the same, but it doesn't work for asp.net site. What shall I check?

Thank you in advance!

Solution

  • This Social.MSDN link seems to point to the fact that you have x86 drivers installed;

    From my viewpoint you have two options:

    1. Convert the app to run on 32bit mode in IIS - Can help if you require assistance. LINK
    2. Download and try the 64bit version of the drivers. Oracle x64 downloads