Application and database versions

Does anyone know if you can run an application compiled under Informix 7.24 and connect to a remote database server running 7.3? Or does the application have to be compiled under the same version as the database? Thanks in advance... Val Valerie H. Webber Valerie.H.Webber@m1.irs.gov 704-569-1002 x107 <<...>>

Webber Valerie H <Valerie.H.Webber@m1.irs.gov> wrote in message news:80p9su$46s$1@news.xmission.com... > > Does anyone know if you can run an application compiled under Informix 7.24 > and connect to a remote database server running 7.3? > > Or does the application have to be compiled under the same version as the > database? > > Thanks in advance... > Val > > Valerie H. Webber > Valerie.H.Webber@m1.irs.gov > 704-569-1002 x107 > <<...>> > The application has to be compiled under the newer version for it to connect! Bit of a bummer really!

It can connect using a network connection while running in a 7.24 runtime environment. In effect you have to install iConnect 7.24 in a separate directory and place an sqlhosts file there that list the server's network or stream pipe connections (you can also fake the shared memory connection name by using the service and connection type of one of the network connections for apps that hardwire the servername). Art S. Kagel Webber Valerie H wrote: > > Does anyone know if you can run an application compiled under Informix 7.24 > and connect to a remote database server running 7.3? > > Or does the application have to be compiled under the same version as the > database? > > Thanks in advance... > Val > > Valerie H. Webber > Valerie.H.Webber@m1.irs.gov > 704-569-1002 x107 > <<...>>

Oops, I did not mention: Set INFORMIXDIR to the 7.24 connect installation, INFORMIXSERVER to one of the names in the 7.24 sqlhosts file, and finally set LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql. The real problem is that the 7.24 executable is not compatible with the SDK2.xx shared libraries. If the 7.24 executable were linked static it be fine. Art S. Kagel "Art S. Kagel" wrote: > > It can connect using a network connection while running in a 7.24 runtime > environment. In effect you have to install iConnect 7.24 in a separate > directory and place an sqlhosts file there that list the server's network > or stream pipe connections (you can also fake the shared memory connection > name by using the service and connection type of one of the network > connections for apps that hardwire the servername). > > Art S. Kagel > > Webber Valerie H wrote: > > > > Does anyone know if you can run an application compiled under Informix 7.24 > > and connect to a remote database server running 7.3? > > > > Or does the application have to be compiled under the same version as the > > database? > > > > Thanks in advance... > > Val > > > > Valerie H. Webber > > Valerie.H.Webber@m1.irs.gov > > 704-569-1002 x107 > > <<...>>

Webber Valerie H wrote: > Does anyone know if you can run an application compiled under Informix 7.24 > and connect to a remote database server running 7.3? > > Or does the application have to be compiled under the same version as the > database? > > Thanks in advance... > Val > > Valerie H. Webber > Valerie.H.Webber@m1.irs.gov > 704-569-1002 x107 > <<...>> Yes, Depending on what tool you use to compile your application. -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible. Some features are: True Windows GUI Clients. ActiveX support. HTML Report Generation. More rigorous error handling. Connection to other RDBMS such as Oracle. Connection to all versions of Informix 4GL with no need to change compiler. For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------