Posting from the Informix-list

data 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.