topic Re: Multiple Attempts to OLEDB failed in Product Forum

Multiple Attempts to OLEDB failed

GagandeepSingh1 — Wed, 16 Dec 2020 10:05:09 GMT

I am trying to access multiple MS Access DB 's one after the other using OLEDB utility in a loop.
It works for first DB file but 2nd file it throws an error- check file name is correct. Although if i run 2nd directly , it works but other fails.

So basically only running one at a time and 2nd it throws error.

Is there a data integrity issue with it.

An alternative approach to work on this?

Note: All DB's are in same folder. I am just changing the name for which file within a loop and trying to connect, query &After closing the connection, try next.

Re: Multiple Attempts to OLEDB failed

hossein.azimi — Wed, 16 Dec 2020 11:18:58 GMT

Hi Gagandeep
I suggest creating a Business Object for each database DB file and use them sepratly.

Re: Multiple Attempts to OLEDB failed

ewilson — Wed, 16 Dec 2020 15:24:22 GMT

Hi Gagandeep,

Are you attempting to attach to each database in this fashion:

Set Connection -> Open -> Get Collection/Execute -> Close -> repeat?

In other words, are you connecting a DB, doing your work, closing the connection, and then moving to the next DB? Or are you trying to open and maintain active connections to all of your DB's at the same time?

Cheers,

Re: Multiple Attempts to OLEDB failed

Anilkumar_Vunduru — Thu, 17 Dec 2020 05:22:23 GMT

Hi Eric,

Yes, we are connecting a db, getting data, closing the connecting and then moving to next db.

Re: Multiple Attempts to OLEDB failed

GagandeepSingh1 — Tue, 05 Jan 2021 05:19:28 GMT

Hi @ewilson ,

As you said, I am following this order as they are different DB's files

Set Connection -> Open -> Get Collection/Execute -> Close -> repeat?

but no luck, any other alternate approach?

Re: Multiple Attempts to OLEDB failed

ewilson — Wed, 06 Jan 2021 15:57:09 GMT

Hi Gagandeep,

I just looked at a similar issue, and I think the problem is that once the VBO is used to connect to a specific DB instance it remains tied to that instance until the VBO is garbage collected. Unfortunately, that doesn't happen until the process completes.

Is this the main functional area of the process you're working with? I'm wondering if you can create try creating a secondary process that just touches the database. Input to the process would be the specific DB file to work with. So you would basically invoke this separate process to handle just the DB interaction. When it's done with the specific DB file, the secondary process ends. Then you invoke it again with the next DB file. Does that make sense?

This is basically the same idea as @Hossein Azimi mentioned above.

Cheers,