StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » how to programatically iterate through database connections and connect

how to programatically iterate through database connections and connect

Marcel Heitlager — Sat, 17 Nov 2012 06:02:23 GMT

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

RE: how to programatically iterate through database connections and connect

Ivan George Borges — Sat, 17 Nov 2012 06:02:23 GMT

Glad it helped Marcel. ;)

RE: how to programatically iterate through database connections and connect

Marcel Heitlager — Sat, 17 Nov 2012 01:39:22 GMT

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

RE: how to programatically iterate through database connections and connect

Ivan George Borges — Thu, 15 Nov 2012 06:53:02 GMT

Hi Marcel.

See if this one helps:

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