Multiple oledb string connection one same sheet

[ahmedhali]

HI all

I´ve recently tested to read two seperate database connections and had the string in the same sheet. The one at the top connected fine but when trying to connect to the other one it failed. I solved it by using two different sheets but im just curious why it would be a problem?

Kind regards

Ahmed

[vishsaggi]

Can you share a screenshot of your error ?

[maxgro · Accepted solution]

You can use many connections in the same script tab

At runtime you can only have one active connection at a time

[ahmedhali]

Hi,

Tried it today and it weird enough worked fine. I guess it was something else blocking from the data source. But thx for the input.

/Ahmed