Re: Q: multiple connections

That's probably because you are connecting to the server which defined as share memory connection in sqlhosts. Check that file and find the server name which allow tcp connection and use that server name instead. Fredrik Fyring wrote: > > Hi! > > I'm using a java/jdbc application to connect to an Informix 7.24 > server residing on a SunOs 5.5.1 machine. > > Sometimes the connections don't get closed properly, and when I > try to reconnect I get the error-message > > "SQLException: XIX000:-27000:Cannot support multiple connections > over shared memory." > > Then I have to manually close the connection from the server-end to > get it running again. > > My questions is this: > > 1) How should I do to get Informix to close a connection to a > client that is gone? > > 2) Can I get Informix in some way to support multiple connections? > > regards > > / Fredrik Fyring -- Jeff So Email : jeffso@lucent.com