Informix Online 956 Error
Contents |
Technote (troubleshooting) This document applies only to the following language version(s): English Problem(Abstract) Trying to connect to remote database fails with -956 error Resolving the problem PROBLEM When you try to connect to a remote database through dbaccess or an other application you get returned an error informix sql error codes -956: -956 Client client-name is not in /etc/hosts.equiv on the remote host. This operation cannot be completed because
Isam Error Codes
the specified remote computer does not recognize the name of the client computer (the local host, whose name the hostname command returns). Client names are normally informix isam error recorded in the configuration file /etc/hosts.equiv. The rhosts file on the remote computer might also need modification. For more information on these files and the relation between them, try man rhosts on a UNIX system. See the remote host administrator to ensure that the
Informix Isam Error -1105 Codes
client host name is specified in /etc/hosts.equiv file for the remote host. This message appears in versions prior to Version 6.0. -956 Client client-name or user is not trusted by the database server. The desired database server does not consider the client computer or your user ID trusted. Ask the system administrator to include the client computer as a trusted host and/or your user id as a trusted user in the /etc/hosts.equiv file on the server computer or in the .rhosts file in your home directory on the server informix sqlca computer. See the UNIX manual pages on HOSTS.EQUIV(5) for more information. Alternatively, you can explicitly specify your user name and password in the USER clause of a CONNECT statement or in the .netrc file in your home directory on the client computer. See the IBM Informix Guide to SQL: Syntax for information on the CONNECT statement, and the UNIX manual pages regarding NETRC(5) for information on the .netrc file. This message appears with Version 6.0 and later. SCOPE The following products and operating systems are affected: Product Name Product Version(s) Hardware Vendor Operating System IBM Informix Dynamic Serverâ„¢ 7.3 9.4 10.0 All All x can be U, H, or F depending on your operating system. SOLUTION Check the following files on both local and remote sides, verify if they respect the following entries and try the connection again. Local side $INFORMIXDIR/etc/sqlhosts (or $INFORMIXSQLHOSTS file): DBSERVERALIASES_machine_server onsoctcp machine_server serviceA /etc/hosts: IPmachine_server machine_server IPmachine_client machine_client /etc/hosts.equiv: +use
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join
Forms Statement Error Number
Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo
Informix Sqlcode
Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, http://www-01.ibm.com/support/docview.wss?uid=swg21265434 recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Informix solutions http://www.tek-tips.com/viewthread.cfm?qid=575330 Forum at Tek-Tips HomeForumsProject and Data ManagementData Management Programming ToolsInformix solutions Forum 956: Client is not in /etc/hosts.equiv on the remote host. thread404-575330 Forum Search FAQs Links MVPs 956: Client is not in /etc/hosts.equiv on the remote host. 956: Client is not in /etc/hosts.equiv on the remote host. testhandle (TechnicalUser) (OP) 13 Jun 03 06:13 Hi,Trying to select records from different database on the same machine(cctest01) with the error select count(*) from testdb@testdbservername:table1; '956: Client is not in /etc/hosts.equiv on the remote host. 'Following are entries from .rhosts file# Hostnames#cctest01## Aliases#testdbtestdbservername#Any solution please?ThanksJohn Jayaseelan RE: 956: Client is not in /etc/hosts.equiv on the remote host. tungaw2003 (TechnicalUser) 27 Jun 03 06:19 create a file named hosts.equiv on your /etc directory and add the ff:your_remote_machineyour_useror verify your $INFORMIXSERVER if correct. RE: 956: Client is not in /etc/hosts.equiv on the remote host. testhandle (TechnicalUser) (OP) 27 Jun 03 06:34 Thanks for the reply.'your_remote_machin
Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read 06 Sep 13 - http://members.iiug.org/forums/ids/index.cgi/read/26102 IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read 01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read 14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read 3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help informix sql Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read 28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read 10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read 3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read 2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based informix isam error service... Read 28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read 23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read 9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read 22 Mar 12 - developerWorks - Optimizing Informix database access... Read 14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read 1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read 1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read 26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read 24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read 6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read 2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read 1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read 13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read