Glad it helped Marcel.

Hi Ivan,

I had already looked at that one, and another one similar to it, but didn't think it applied.  Then after you suggested to take a look at it, I looked at it again, and guess what?  It was exactly what I was looking for.

Thanks!

Marcel

Hi Marcel.

See if this one helps:

http://forum.strataframe.net/FindPost22228.aspx

Hi guys,


We run a administrative maintenance app that has access to about 30 plus databases (same databases, with different names).  I need to be able to pull a couple of values from each database to present to the administrator as status information.

We use the connection manager.  I'm trying to just iterate through the available database connections, connect to the database, pull the value and move to the next.  Of course when done, I want to reconnect to the original database connection.  What is the easiest way to do this without user intervention?


Thanks,


Marcel