Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help on OLE object read from Access

Tried info, bundle loads but not able to view the images

8 Replies
Gysbert_Wassenaar

The zip file you uploaded seems to be corrupt.


talk is cheap, supply exceeds demand
Not applicable
Author

uploaded it again in the original post.

ashfaq_haseeb

Hi try below in load script

ODBC CONNECT TO [testatt;DBQ=D:\mdb\test.accdb];

// info

// LOAD ID,

//    png;

//SQL SELECT *

//FROM Table1;

//OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=dise;Data Source="";Extended Properties=""] (XPassword is MFUFBSFNTLZGD);

bundle iNFO SELECT ID, Attachment FROM Table1;

//OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=qed;Data Source=qedquest-PC;Extended Properties=""] (XPassword is ffACfYVMELLA);

//

//bundle info

//SELECT *

//FROM DISE.TEST;

Regards

ASHFAQ

Not applicable
Author

Not working Ashfaq

Not applicable
Author

any luck

ashfaq_haseeb

Hi the proble is that I cannot read your .accdb file

Can you somehow provide me .mdb file.

Regards

ASHFAQ

Not applicable
Author

Hi Ashfaq,

Attached the mdb file.

Also as a alternate you can use the driver for accdb(ms office 2007)accdb.png

Not applicable
Author

Experts pls help