Mephansteras
MIS
Hi all!
I'm trying to figure out a better way of using DBI:roxy. We have an NT server with SQL7 on it and a RUMBA connection to DB2 on an AS400. I need to be able to access both databases from a linux box, so I'm using DBI and DBIProxy. Problem is, DBIProxy on NT doesn't have either threading or fork, so I have to have multiple ports open. I need a way to check to see if a port is open to prevent collisions. We have a lot of automated processes that run throughout the day extracting and inserting data.
Right now, I'm checking by using alarm() and doing a query one of the databases. But, if that database is down, none of the ports work, even if I'm just trying to go to the other database.
I'm sure there must be a better way to do this, but all of my attempts have failed. Any ideas?
I'm trying to figure out a better way of using DBI:roxy. We have an NT server with SQL7 on it and a RUMBA connection to DB2 on an AS400. I need to be able to access both databases from a linux box, so I'm using DBI and DBIProxy. Problem is, DBIProxy on NT doesn't have either threading or fork, so I have to have multiple ports open. I need a way to check to see if a port is open to prevent collisions. We have a lot of automated processes that run throughout the day extracting and inserting data.
Right now, I'm checking by using alarm() and doing a query one of the databases. But, if that database is down, none of the ports work, even if I'm just trying to go to the other database.
I'm sure there must be a better way to do this, but all of my attempts have failed. Any ideas?