Re: Connection between Windows and Informix Online on Unix

SetNet32 is a utility to configure the environment needed for several client-side applications (from Informix), defining variables used on displays, connection types, formats, Global Language Support, editors, and so on... In your case, your client-side application is Visual Basic, and so you shouldn't worry about these, at least for the moment. Later, you'll find usefullness in some of the variables listed in setnet32. For the moment, you just need to use the "Server Information" tab and fill in the blanks. Note this, first: Your IDS Engine has a thread bound to a certain TCP/IP service, which it monitors for incoming messages (clients). You can figure out what service is being used by viewing the "$INFORMIXDIR/etc/sqlhosts" file. The first column refers to an instance's NAME, and the fourth column refers to the SERVICE used in communications. Note the line with ONSOCTCP or ONTLITCP (meaning TCP-IP protocol over SOCKETS or TLI interface). The service on that line is listed in "/etc/services". Lookup this file and add the corresponding entry to your PC's "C:\\WINNT\\SYSTEM32\\DRIVERS\\ETC\\SERVICES" file. Now let's fill in those blanks in SetNet32: Informix Server: the instance name, as seen on the sqlhosts file Hostname: the node (machine) name where IDS resides (the server) Protocolname: onsoctcp (even if your server has ONTLITCP) Service Name: the one you found, or just the number (e.g. 1526) Options: x=??? (substitute the instance name for the ???) Make this the default server, and then proceed to create your ODBC data sources, where you will be asked to fill some of these parameters again, and also the name of a database (remember, a data source means a connection to a DATABASE, not to a database SERVER) Well, I sincerely hope this helps. If you find yourself in trouble with something along your way (even later, with the data source in place) you should post your message in the newsgroup, to a bigger audience, guaranteing quicker and best of all different responses. Best regards. Denis Hung wrote: > > Hi: > > I have gone by the books for the setup of the CLI through the books, but I > cannot understand the different setup in SETNET. Please can you help out... > > Thanks > Denis > ----- Original Message ----- > From: Paulo Silva <psilva@informix.com> > Newsgroups: comp.databases.informix > To: Denis Hung <denis@intnet.mu> > Sent: Wednesday, May 19, 1999 6:05 PM > Subject: Re: Connection between Windows and Infromix Online on Unix > > > > > > >Denis Hung wrote: > >> > >> Hi: > >> > >> I want to connect from windows based systems to an Informix Online > database > >> found on Unix. What do I need to install from the online Engine CD and > how > >> do I configure the connection. I want to develop applications using > Visual > >> Basic, but talking to Informix online. > >> > >> Thanks. > >> Denis > > > > > >You need to install Informix-Cli for Windows from the IDS CD (provided > >you have a recent _7.xx_ version) to be able to create an ODBC data > >source on your PC, but since you want to develop with Visual Basic, you > >should contact your local Informix Office and try out Informix Data > >Director For Visual Basic (DDVB). You will be amazed with what it can do > >for you (It really assists you in creating Database-Oriented > >Applications) > > > >__________________________________________________________ > >Paulo Silva mailto:psilva@informix.com > >Consultant/Trainer phone : +351 1 412 89 40 > >Informix Software Portugal fax : +351 1 410 84 37 -- __________________________________________________________ Paulo Silva mailto:psilva@informix.com Consultant/Trainer phone : +351 1 412 89 40 Informix Software Portugal fax : +351 1 410 84 37

Hi... >SetNet32 is a utility to configure the environment needed for several >client-side applications (from Informix), defining variables used on >displays, connection types, formats, Global Language Support, editors, >and so on... >Options: x=??? (substitute the instance name for the ???) Why this "x=<servername"? What it does? []ao LEO Cardoso ---