Re: MSDAORA provider not found

On Fri, 14 Apr 2006 08:58:02 -0700, chris wrote:

The Oracle client is installed and working fine. I can get to my Oracle DB
with the Oracle provider - OraOLEDB - without any problems. ...
...
"Provider=MSDAORA;Data Source=TEST1;User ID=TEST;Password=TEST;PLSQLRSet=1;"
I get the provider not found message. I know I can just use Oracle's
provider, it's just that I wanted to test the speed of both.

Check the tips on these pages, and if nothing else left, try installing
a recent MDAC (i.e. one suitable for your environment).

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q259959
http://msdn.microsoft.com/library/en-us/oledb/htm/oledboracleconnectivity_checklist.asp

You might also want to check out your MDAC installation with the
Component Checker:
http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9
--
Ross McKay, Toronto, NSW Australia
"Let the laddie play wi the knife - he'll learn"
- The Wee Book of Calvin
.

Relevant Pages

  • Re: SQL 64 to Oracle Link
    ... But I could not see in provider list in SSMS. ... That might be related to Oracle provider driver. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.sqlserver.connect)
  • Does .NET Framework Data Provider for Oracle also have a CacheType feature like OraOLEDB?
    ... Does MS supplied .NET Framework Data Provider for Oracle also have ... OraOLEDB provides two caching mechanisms: ... mechanism provides better performance at the expense of higher memory ...
    (microsoft.public.dotnet.framework.adonet)
  • Single Cube from Multiple sources
    ... Provider=OraOLEDB.Oracle.1 (Oracle Provider for OLEDB) ... Error Text: OLE DB error: OLE DB or ODBC error: Cannot initialize the ... name>' secondary data source is not a relational data source, ...
    (microsoft.public.sqlserver.olap)
  • Re: Oracle Provider or Microsoft Provider
    ... the new provider from microsoft follows a strict parameter ... check while the old oracle provider was flexible on parameter names, ... Now I want to use the Microsoft provided data provider ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: How to I reinstall the Microsoft OLE DB Provider for Oracle
    ... My problem is not with OraOledb, but with the Microsoft OLE DB Provider. ... TIm ...
    (microsoft.public.data.oledb)