topic Re: ole objects,background and open dataset in Application Development and Automation Discussions

ole objects,background and open dataset

Former Member — Sun, 14 Jan 2007 21:52:00 GMT

Hi,

I want to read ms access files on background using ole objects. Is it possible to apply open dataset operation for mdb files? As known, text files can be get into application server using open dataset. But I need to get mdb file to application server.

On the other way I can simulate my problem as, is it possible to read excel files(for example) using <b>ole object</b> in background? If I can get an aswer, maybe I can simulate it as reading mdb files.

Thanks.

Re: ole objects,background and open dataset

Jelena_Perfiljeva — Tue, 16 Jan 2007 17:28:11 GMT

OPEN DATASET is meant for the flat text files, you won't be able to open an mdb file with it. Once I've tried using OLE objects to obtain the file modification date and, even though it worked great in foreground, it didn't work in the background mode.

This thread on reading MS Access files in SAP might be helpful:

Re: ole objects,background and open dataset

Former Member — Tue, 16 Jan 2007 23:56:54 GMT

OLE and background are incompatible - you can only use OLE in the foreground as it runs on the presentation server.

If you need to run as a background process, you will have to use open dataset. You can read the mdb as a binary file, but I doubt you could do anything useful with it. Can you export the data you need from access into a tab separated, comma separated or fixed format file - then you can open this using open dataset and read the data.

Michael

Re: ole objects,background and open dataset

Former Member — Wed, 05 Jan 2011 13:20:43 GMT

i am facing the same problem with OLE object when i run on the background so

how can i replace this OLE with open dataset (i am connecting to SQL server) .