topic OLE DB Connection!! Microsoft Data Link Error in QlikView

OLE DB Connection!! Microsoft Data Link Error

Fri, 05 Aug 2011 06:00:52 GMT

Hi All,

I am trying to connect to Oracle DB using OLE DB connection. After selecting the drivers and entering Data Source name , Username and Password its gives an error of "Microsoft Data Link Error not all properties set". I get this error when i click on test connection. And even after clicking "Ok" it says test connection successful.

I am using ORAOLEDB provider and qlikview 9.0 (64 bit)

Any suggestion please reply

Thanks

Jigesh

OLE DB Connection!! Microsoft Data Link Error

kaushiknsolanki — Fri, 05 Aug 2011 07:17:02 GMT

Hi,

I am not sure, but you can try this.

Check the box in edit script with name "Force 32 bit"

Regards,

Kaushik Solanki

OLE DB Connection!! Microsoft Data Link Error

Mon, 08 Aug 2011 09:12:09 GMT

Hi Kaushik,

Thanks for the reply.

But We are using Version 9.0 and Force 32 bit option is available only in version 10.0

If anyone can help please reply.

Thanks

Jigesh