Can we use OLE DB connection for Oracle?

[#1]

Hi All,

Can we use OLE DB connection for Oracle?

Thanks,

Attitude

[jagan]

Hi,

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

http://www.connectionstrings.com/oracle

Hope it helps you.

Regards,

Jagan.

[#3]

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

[jagan]

Hi,

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

Regards,

Jagan.

[#5]

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

[#6]

Any answer for my above post friends?

[erichshiino]

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

[#8]

Thanks Erich for your valuable sharing!