topic Oracle OLE DB Provider in QlikView

Oracle OLE DB Provider

darrellbutler — Fri, 13 May 2011 10:59:58 GMT

Hi Folks,

I've just got a new laptop. I've installed QV but when I want to connect to Oracle databases I cant see the Oracle OLE DB provider in the data link properties box. I've installed Oracle Provider for OLE DB (11.2.0.2.0) from ODAC 11.2 Release 3 , I thought this might do the trick but it hasn't any ideas ?Many thanks

Darrell.

Oracle OLE DB Provider

rbecher — Fri, 13 May 2011 11:02:45 GMT

Could this be a 32/64bit issue? Which version you are running?

- Ralf

Oracle OLE DB Provider

darrellbutler — Fri, 13 May 2011 11:09:21 GMT

Ralf,

I'm using 64bit QV, laptop is 64 bit but it looks like the ODAC components are 32Bit - although in saying that the system requirements for ODAC are:

System Requirements

======================================================

The following items are required for ODAC:

Windows operating system
- 32-bit: Windows 7 (Professional, Enterprise, Ultimate editions), Windows Server 2008, Windows Vista (Business, Enterprise, Ultimate editions), Windows Server 2003, Windows Server 2003 R2, Windows XP Professional
- x64: Windows 7 (Professional, Enterprise, Ultimate editions), Windows Server 2008 R2 and Windows Server 2008 (all editions, except HPC), Windows Vista (Business, Enterprise, Ultimate editions), Windows Server 2003, Windows Server 2003 R2, Windows XP
Microsoft .NET Framework 2.0, 3.0, 3.5, or 4
Note: .NET Framework 1.x is not supported.
Access to an Oracle Database Server (Oracle 9i Release 2 or later)

Oracle OLE DB Provider

rbecher — Fri, 13 May 2011 11:26:25 GMT

But the website says 32-bit:

http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

You should install the Microsoft Windows (x64) Client:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

2. Paragraph: Oracle Database 11g Release 2 Client

- Ralf

Oracle OLE DB Provider

darrellbutler — Fri, 13 May 2011 13:44:20 GMT

Cheers Ralf - this worked, one thing to be careful about though is to do a custom install as the oracle ole db provider soesn't install by default you have to select it.

Many ThanksDarrell