Re: CLI
Posted in 1997
There is an even easier answer. Don't use service names. Just enter the
same (unused) service number in both the sqlhosts on the server and in
the CLI setup. You don't have to have sys admin access to get
connectivity with Informix.
You may also have to create a .rhosts file on the server under the home
directory of the logon used by CLI. In this file enter the host name
(or IP) of the desktop and give this file the permissions of 600 and the
owner should be the owner of the home directory.
Peter Wang wrote:
> According to the error message, you should check whether the service
> name =
> "wase" has been defined in /etc/services on both client(windows 95)
> and =
> server platform, and check also the path name set up for tcp/ip
> program on =
> your PC (Client).
> _________________
> _________________________________________________________=
> ____
> From: Thuc Nguyen on Thu, 12 Jun 1997 06:05
> Subject: CLI
> To: informix-list@rmy.emory.edu
>
> Hi...
>
> I am running Online 7.22 on HP-UX 10.22 with Informix-CLI 2.50,
> Windows Access 97 and Windows 95 on my PC.
>
> I have tried many different things to get it working.
> The error message:
>
> [INTERSOLV][ODBC Informix driver][Informix]Cannot locate whse
> service/tcp service in /etc/services.
>
> [INTERSOLV][ODBC Informix driver][Informix] Unknown error message
> 11004
>
> /usr/informix/etc/sqlhosts info:
>
> whse onipcshm warehous warehous
> whse_soc onsoctcp warehous whse>
> /etc/services info:
>
> whse 1526/tcp
>
> /usr/informix/etc/onconfig.whse info:
>
> SERVERNUM 91
> DBSERVERNAME whse
> DBSERVERALIASES whse_soc
> NETTYPE ipcshm, 1, 20, CPU
> NETTYPE soctcp, 1 , 20, NET>
> INFORMIX CLI 2.50
> ODBC Data Source Administrator
> In the User DSN information:
>
> Data_Source Name: Information-Services
> Description: whse information
> Database Name: whse
>
> then the next step was Advanced buttion I clicked on.
>
> In the Advanced button info:
>
> Database List: warehouse system
> Default User Name: thucn
> Host Name: warehous (our machine name)
> Service name: whse
> Server name: whse_soc
> Protocol Type: onsoctcp
>
> The Sysstem DSN is same info as User DSN.
>
> In the File DSN menu,
>
> "logon to Informix 7.2"
>
> database name: whse (our database name is whse)
> host name: warehous
> user name: thucn
> password: ********
>
> then the next step was option button I clicked on
>
> Service name: whse
> Server name: whse_soc
> Protocol type: onsoctcp
>
> The error message I got above at the top of this message.
>
> I tried whse instead of whse_soc as server name and warehous
> instead of whse as a service name but the result was same.
>
> Before I upgraded to Windows 95 from Windows 3.11 but the CLI 2.50
> was same, it worked well..
>
> Thanks in advance for your response!
>
> Thuc
>
> ------------------ RFC822 Header Follows ------------------
> >Received: by yes.optus.com.au with SMTP;12 Jun 1997 06:04:59 U
> >Received: from happy.optus.com.au (firewall-user@happy.optus.com.au =
>
> >[203.13.126.9]) by proxy.optus.com.au (8.8.3/8.8.3) with ESMTP id
> GAA16768 =
> >for <peter_wang@yes.optus.com.au>; Thu, 12 Jun 1997 06:00:18 +1100
> >Received: by happy.optus.com.au; id GAA00500; Thu, 12 Jun 1997
> 06:02:08 =
> >+1000 (EST)
> >Received: from mail.mel.aone.net.au(203.12.176.157) by
> happy.optus.com.au =
> >via smap (3.2)
> > id xma000458; Thu, 12 Jun 97 06:01:19 +1000
> >Received: from rmy.rmy.emory.edu (rmy.rmy.emory.edu [170.140.97.4])
> by =
> >mail.mel.aone.net.au (8.6.13/8.6.11) with ESMTP id GAA04631 for =
> ><peter_wang@yes.optus.com.au>; Thu, 12 Jun 1997 06:01:02 +1000
> >Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1)
> id =
> >NAA01983 for informix-list-out; Wed, 11 Jun 1997 13:25:01 -0400 (EDT)
>
> >Message-Id: <s39e891c.040@email.utcourts.gov>
> >X-Mailer: Novell GroupWise 4.1
> >Date: Wed, 11 Jun 1997 11:18:18 -0600
> >From: Thuc Nguyen <thucn@email.utcourts.gov>
> >To: informix-list@rmy.emory.edu
> >Subject: CLI
> >Mime-Version: 1.0
> >Content-Type: text/plain
> >Content-Disposition: inline
> >Sender: informix-list-owner@rmy.emory.edu
> >Reply-To: Thuc Nguyen <thucn@email.utcourts.gov>
> >X-Informix-List-Id: <list.14917>