Re: how do I find out the server name

Thanks for the answer. I'm using Informix Online version 5.x and there is no INFORMIXSERVER environment variable. The sqlhosts file exists and has the same server name cross-referenced. But I can't connect to the server at all! I keep getting -908 as the error. The problem could be that the server and my client are on the same machine. Is that a problem in this environment? I'm working in SunOS 5.6 Salman squreshi@bnn.com Alnis Bajars wrote: > That's true. But it must match the value of the INFORMIXSERVER environment > variable and needs to be cross referenced in the sqlhosts file, where the > connectivity mechanism for the database server needs to be established. > > BTW, there's some confusion in the wording of your question. These values > refer to an "instance" of the database server - from there, 1 or more > databases can be created within that instance of the database server. > > Alnis Bajars > alnisb@colorcorp.com.au > > squreshi <squreshi@bbn.com> wrote in message > news:38332A12.F94309AD@bbn.com... > > Hi > > > > How can I find out what the server name of the Informix database is. (I > > need it in the jdbc url). I've been using a DBSERVERNAME variable in a > > config file. Is that correct? Is it somewhere else? > > > > Thanks, > > > > Salman > >

Oh, and I'm using Java 2 with JDBC 2.0. Thanks again, by the way Salman squreshi wrote: > Thanks for the answer. I'm using Informix Online version 5.x and there is no > INFORMIXSERVER environment variable. > > The sqlhosts file exists and has the same server name cross-referenced. But I > can't connect to the server at all! I keep getting -908 as the error. The > problem could be that the server and my client are on the same machine. Is that > a problem in this environment? I'm working in SunOS 5.6 > > Salman > squreshi@bnn.com > > Alnis Bajars wrote: > > > That's true. But it must match the value of the INFORMIXSERVER environment > > variable and needs to be cross referenced in the sqlhosts file, where the > > connectivity mechanism for the database server needs to be established. > > > > BTW, there's some confusion in the wording of your question. These values > > refer to an "instance" of the database server - from there, 1 or more > > databases can be created within that instance of the database server. > > > > Alnis Bajars > > alnisb@colorcorp.com.au > > > > squreshi <squreshi@bbn.com> wrote in message > > news:38332A12.F94309AD@bbn.com... > > > Hi > > > > > > How can I find out what the server name of the Informix database is. (I > > > need it in the jdbc url). I've been using a DBSERVERNAME variable in a > > > config file. Is that correct? Is it somewhere else? > > > > > > Thanks, > > > > > > Salman > > >