topic Re: Oracle Provider for OLEDB Issue in QlikView

Oracle Provider for OLEDB Issue

amit_saini — Thu, 21 Dec 2017 06:58:33 GMT

Hi Folks,

I'm using below connector to connect with Oracle DB.

While doing show , I don't know why "Use Windows NT" option is disable here. Any Idea???

Regards,

Re: Oracle Provider for OLEDB Issue

Anil_Babu_Samineni — Thu, 21 Dec 2017 07:14:01 GMT

I never face this issue, But can you tell us where you are accessing {i mean view/sense}

Re: Oracle Provider for OLEDB Issue

amit_saini — Thu, 21 Dec 2017 07:15:48 GMT

QlikView and only when I'm trying to connect for Oracle for rest I do have that option enabled.

Regards,

Re: Oracle Provider for OLEDB Issue

Anil_Babu_Samineni — Thu, 21 Dec 2017 07:18:48 GMT

What i understand earlier with Oracle it should connect from ODBC because Oracle is native for ODBC and not for OLEDB. I even not 100% sure reg this? I will try in the evening.

Meantime, I would recommend marcus_sommer‌ who decipher from insight ..!

Re: Oracle Provider for OLEDB Issue

amit_saini — Thu, 21 Dec 2017 07:22:35 GMT

We are connected with 28 Oracle DB through OLEDB , never used ODBC till now for this.

Regards,

Re: Oracle Provider for OLEDB Issue

marcus_sommer — Thu, 21 Dec 2017 08:51:25 GMT

I don't have any experience with the oracle oledb but I could imagine that it is caused by the driver itself (maybe NT authentication is disabled there) or that the driver isn't installed correctly or properly registred in windows registry. Also where the driver is enabled may be important - as user / system / file - dns for this option.

- Marcus

Re: Oracle Provider for OLEDB Issue

andycheetham — Fri, 22 Dec 2017 12:16:24 GMT

This is because the OLEDB driver you are using is expecting an Oracle Username/Password NOT a windows account.