Re: Create Remote Dbase

>Re: > >> Whenever I try to create a database through ISQL at the >> client, a local SE-database (*.dbs) will be created ! It >> seems impossible to create a remote ONLINE-database, even >> if I use the //<HOST>/<database> format. The SQLEXEC- >> variable is correctly set to $INFORMIXDIR/ sqlexec_tcp and >> there is *NO* SE-backend on the local machine ! > >According to pg 30 of the I-NET I-STAR User Guide, > >'If you are using a client running I-NET, you cannot create a >database on a remote UNIX server running TURBO or I-STAR and >vice-versa' > >You would have to have a corresponding Informix product on the server >for the create database to work. Perhaps you could set up some sort >of remote shell command to do this manually ? Not necessarily so! I have found that in a similar situation it is possible to create a database on the server by setting the environment variable SQLHOST to be the name of the remote server, and unsetting DBPATH. However I can find no documentation of the SQLHOST environment variable anywhere except in the text for error -420, which reads:- -420 Cannot execute remote sqlexec. Your application program is starting up and trying to make contact with the database engine process in another computer. It does this using the contents of the SQLHOST environment variable. Check the SQLHOST variable and verify that the INFORMIX-NET or INFORMIX-STAR service has been started in the other machine. Our Environment:- Server SUN 4/490 OnLine 5.00.UC2 I-Star 5.00.UC2 Tools 4.10.UC1 Client SUN SS2 I-Net 4.10.UC2 Tools 4.10.UC1 ------------------------------------------------------------------------------ John Brown (Software Support Manager) Amgen Ltd Email: johnb@amgen.com Cambridge UK ------------------------------------------------------------------------------ Any opinions stated here are not neccesarily those of my employer