OLE DB Connection!! Microsoft Data Link Error

[#1]

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

[kaushiknsolanki]

Hi,

     I am not sure, but you can try this.

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

Regards,

Kaushik Solanki

[#3]

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