posted 17 years ago
Do you create a connection pool or keep a connection across the IP change? My gut feeling is that the connection is not valid after the IP change for whatever reason (session with db is invalid, underlaying network socket closed and so on). If this is not an interactive program you could probably get away with creating the connection each time you update the data. You could also talk to your network administrator and try to convince him that you need a static ip address.