asked on

provider is not registered on the local machine

Hello Experts,

I'm new to web services and connecting to Oracle. I am using Oracle Express Edition 11.2.0.2.0 and running on Windows 7 64 bit machine. the connection string I'm using is:

Provider=OraOLEDB.Oracle;Data Source=XE;User ID=system;Password=pwd01

I get the following error when the web service tries to connect to the DB:

System.InvalidOperationException: The 'OraOLEDB.Oracle' provider is not registered on the local machine.
at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at RealPropertyWebServices.clsDataAccess.OpenDatabase() in C:\Users\kmfrancis\Documents\Visual Studio 2010\Projects\RealPropertyServices\RealPropertyApplicationSolution\RealPropertyWebServices\clsDataAccess.vb:line 6984
at RealPropertyWebServices.RealPropertyWebServices.GetDocumentTypes() in C:\Users\kmfrancis\Documents\Visual Studio 2010\Projects\RealPropertyServices\RealPropertyApplicationSolution\RealPropertyWebServices\RealPropertyWebServices.asmx.vb:line 189

What am I doing wrong?

Carl Tawn

Did you install the Oracle client tools on the machine too?

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mutu

ASKER

Yes the .Net web service is 32Bit and the web service is running on the same server as the XE instance. The Oracle install is 32Bit - I don't think Oracle has a 64Bit version for 11.2.0.2.0.

I will download the drivers and try it ...

Thank you for your help!

mutu

ASKER

Carl_tawn - What are the client tools and where do I get them?

mutu

ASKER

I downloaded the Oracle tools and ran the sql scripts but I still get the same error and I don't know what else to try!

slightwv (䄆 Netminder)

It's been a while since I had to install the drivers but I remember there being an install process of some sort for the OLEDb drivers.

Did you run that?

There should be a readme type file as part of the unzipped download that tells you how to install them.

Carl Tawn

In Windows go to:

Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC)

Look under the "Drivers" tab. What, if anything, is listed for Oracle?

slightwv (䄆 Netminder)

>>Look under the "Drivers" tab. What, if anything, is listed for Oracle?

I can install the OleDB drivers and not the ODBC drivers. Not sure what looking for the ODBC drivers will help solve.

mutu

ASKER

Under the Drivers tab there are two items listed:

SQL Server
SQL Server Native client

I looked at the readme file but didn't see anything about ODBC drivers. I'm going to look at the readme file again to see if I missed anything and I will look into ODBC drivers.

slightwv (䄆 Netminder)

>>if I missed anything and I will look into ODBC drivers.

I suggest not using ODBC. They are problematic and typically have limitations that other native drivers do not have.

If you are considering changing drivers, I suggest ODP.Net.

mutu

ASKER

Experts thank you for all your help!! This is a 64 vs 32 bit conflict. The problem went away when I enabled 32 bit applications in IIS.

1. Start IIS (Start -> type inetmgr in search box)
2. Click on Application Pools in left panel, list of Application Pools will display in right panel
3. Select DefaultAppPool and name of the virtual directory of the app then click on Advanced Settings in Action Panel under Edit Application Pool.
4. Enable 32-Bit Applications = True for both

I will accept solution and award points.

mutu

ASKER

Your comments were helpful to narrow the search for a solution. Thank you very much!