Re: Communication between servers and Informix 5 and 7

Thanks to everyone who responded. I'm working this now. I have to get my Admin to update the /etc/services file. Once done I'll test again. If I have a problem, you all will hear about it. Boy did you all save me some night reading and this I am really thankful for!!!! ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR kendric@gwysmtp.jcdc.doleta.gov OR cherylk@spamis.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Thu, 25 Apr 1996, Jacques Renaut wrote: } Cheryl Kendricks wrote: } > } > Can I access my Informix 5 Database Data from my Inormix 7 Database } > Server? } > } > If so how? } > I tried to do a select * from <hostname>@<data_basename>:<table_name> } > and got an error. } > } > Has anyone done this? } > } > Thanks!!!!!! } > } } Yes you should be able to as long as both databases have the same } logging status, you've configured the 5.x instance for remote } connections and your 7.x system for remote connections. Also, } the syntax for the select would be: } } select * from <data_basename>@<dbserver_name>:<table_name> } } dbserver_name being the 1st column of the sqlhosts file entry } which should be something like this: } } dbserver_name on<soc|tli>tcp hostname servicesname } } Also if you included what error you got it might be helpful as well. } Hope this helps you a bit. } } Jacques } } -- } ******************************************************************** } * Jacques P. Renaut "I'd dazzle you with brilliance * } * Informix Advanced Support if I only had the knack..." * } * email: jrenaut@informix.com #include <disclamier.h> * } ******************************************************************** }