topic Can we use OLE DB connection for Oracle? in QlikView

Can we use OLE DB connection for Oracle?

Wed, 29 Feb 2012 17:54:08 GMT

Hi All,

Can we use OLE DB connection for Oracle?

Thanks,

Attitude

Can we use OLE DB connection for Oracle?

jagan — Thu, 01 Mar 2012 08:14:19 GMT

Hi,

You can use OLE DB connection from Oracle. Refer this URL

http://www.connectionstrings.com/oracle

Hope it helps you.

Regards,

Jagan.

Can we use OLE DB connection for Oracle?

Thu, 01 Mar 2012 15:39:25 GMT

Hi Jagan,

Thanks for your reply! My question was is it possible to use OLE DB connection when are connecting to Oracle data source?

Thanks,

Attitude

Can we use OLE DB connection for Oracle?

jagan — Fri, 02 Mar 2012 05:58:24 GMT

Hi,

Yes, It is possible to connect to Oracle using OLE DB.

Regards,

Jagan.

Can we use OLE DB connection for Oracle?

Fri, 02 Mar 2012 13:44:35 GMT

Hi Jagan,

Thanks for your reply! I heard from someone saying that it is not possible to connect to Oracle using OLE DB.

Anyway is there is anyother Datasources which cannot be connected using OLE DB? I heard someone saying that we cannot use OLE DB in some of the databases.

Please name them if any!

Thanks,

Attitude

Can we use OLE DB connection for Oracle?

Tue, 13 Mar 2012 16:27:50 GMT

Any answer for my above post friends?

Can we use OLE DB connection for Oracle?

erichshiino — Tue, 13 Mar 2012 16:44:05 GMT

Hi, At titude

It would depend on the DB vendor to provide an OLE DB driver. So, it may be difficult to identify and create a list of them.

For oracle databases, you need to install ODAC (Oracle Data Access Components) to get the OLEDB driver.

For SAP, althought you are able to connect to the database, you could break the license agreement. That`s will you need to use the SAP Connector, as discussed here:

http://community.qlik.com/message/82932#82932

Regards,

Erich

Can we use OLE DB connection for Oracle?

Wed, 14 Mar 2012 06:54:05 GMT

Thanks Erich for your valuable sharing!