Oninit cdi / Archive
Talk to an expert →

Error 908 from one instance to another

Posted in 2000

Topics: Server Administration, Networking & sqlhosts Configuration

2char@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

I have 2 instances on one database server (Sun Sparc). My NEG_tli instance is IDS9.2 and my GEO_tli instance is IDS7.3 I want to do the following from my NEG_tli instance: select * from geosr1@GEO_tli:informix.gocur; (using the syntax dbname@dbserver:owner.tabname) but receive the 908 error. With my environment parms pointing to the 9.2 instance I can do this: dbaccess geosr1@GEO_tli and access my 7.3 database. My sqlhosts file for the 7.3 instance: GEO_shm onipcshm chimchim dummy GEO_tli ontlitcp chimchim-local geo_tli k=1,b=32767 GEO2_tli ontlitcp chimchim geo_tli k=1,b=32767 NEG_shm onipcshm chimchim dummy NEG_tli ontlitcp chimchim-local neg_tli k=1,b=32767NEG2_tli ontlitcp chimchim neg_tli k=1,b=32767 My sqlhosts file for the 9.2 instance: NEG_shm onipcshm chimchim dummy NEG_tli ontlitcp chimchim-local neg_tli k=1,b=32767NEG2_tli ontlitcp chimchim neg_tli k=1,b=32767 GEO_shm onipcshm chimchim dummy GEO_tli ontlitcp chimchim-local geo_tli k=1,b=32767GEO2_tli ontlitcp chimchim geo_tli k=1,b=32767 #GEO_tli ontlitcp 172.28.208.77 geo_tli k=1,b=32767 my /etc/services file: neg_tli 1594/tcp pied1_tli 1595/tcp gui_tli 1596/tcp geo_tli 1597/tcp baf_tli 1598/tcp uname -n = chimchim uname -a = SunOS chimchim 5.6 Generic_105181-19 sun4u sparc SUNW, Ultra-Enterprise What am I doing wrong?? I've been at this for several hours and would greatly appreciate any help! Thanks.... Charlene Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to 2char@my-deja.com
Norman Erickson Lugtu — — source: Informix-list mailing list archive (1991-1998)

Is the user a trusted user? In article <8u2lsp$g2i$1@nnrp1.deja.com>, 2char@my-deja.com wrote: > I have 2 instances on one database server (Sun Sparc). My NEG_tli > instance is IDS9.2 and my GEO_tli instance is IDS7.3 > I want to do the following from my NEG_tli instance: > > select * from geosr1@GEO_tli:informix.gocur;> (using the syntax dbname@dbserver:owner.tabname) > > but receive the 908 error. > > With my environment parms pointing to the 9.2 instance I can do this: > > dbaccess geosr1@GEO_tli > and access my 7.3 database. > > My sqlhosts file for the 7.3 instance: > > GEO_shm onipcshm chimchim dummy > GEO_tli ontlitcp chimchim-local geo_tli k=1,b=32767 > GEO2_tli ontlitcp chimchim geo_tli k=1,b=32767 > NEG_shm onipcshm chimchim dummy > NEG_tli ontlitcp chimchim-local neg_tli k=1,b=32767> NEG2_tli ontlitcp chimchim neg_tli k=1,b=32767 > > My sqlhosts file for the 9.2 instance: > > NEG_shm onipcshm chimchim dummy > NEG_tli ontlitcp chimchim-local neg_tli k=1,b=32767> NEG2_tli ontlitcp chimchim neg_tli k=1,b=32767 > GEO_shm onipcshm chimchim dummy > GEO_tli ontlitcp chimchim-local geo_tli k=1,b=32767> GEO2_tli ontlitcp chimchim geo_tli k=1,b=32767 > #GEO_tli ontlitcp 172.28.208.77 geo_tli k=1,b=32767 > > my /etc/services file: > > neg_tli 1594/tcp > pied1_tli 1595/tcp > gui_tli 1596/tcp > geo_tli 1597/tcp > baf_tli 1598/tcp > > uname -n = chimchim > uname -a = SunOS chimchim 5.6 Generic_105181-19 sun4u sparc SUNW, > Ultra-Enterprise > > What am I doing wrong?? > I've been at this for several hours and would greatly appreciate any > help! > > Thanks.... Charlene > > Sent via Deja.com http://www.deja.com/ > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.

Glossary