Oninit cdi / Archive
Talk to an expert →

-956 client not trusted error with IDS 10.0 on Windows

Posted in 2005

Topics: Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Versions, Editions & End-of-Life

koreilly@emangoe.com — — source: Usenet: comp.databases.informix

Have installed IDS 10.0 on Windows XP. From the local host (that IDS 10.0 is installed on) I can connect to the stores7 sample database using dbaccess and Ilogin executable. When I attempt to connect locally to IDS 10.0 using the esql demo1.ec example program, receive the error message 'Client host or user (prod@powerlite)♥ is not trusted by the server.'. The state for the error was IX000 and code was -956. >From this same Windows host I can recompile the esql demo1.ec example program and connect fine to an IDS 7.3 database server running on another NT server host. The only program change in demo1.ec is 'strcpy(InetLogin.InfxServer, "ol_dell1");' to connect to the NT host. Anyone know what I have to configure on the Windows XP host to resolve this issue? Thanks in advance.

↪ replying to koreilly@emangoe.com
david@smooth1.co.uk — — source: Usenet: comp.databases.informix

well you are connecting as user prod. so I guess create a windows user on the database server machine called prod? login using their password?

↪ replying to koreilly@emangoe.com
Guy Bowerman — — source: Usenet: comp.databases.informix

If you haven't made any changes to demo1.ec it connects with: EXEC SQL connect to 'stores_demo'; This should connect locally as the user you are logged on as. It works for me when logged in to the server directly and via Remote Desktop. How are you logged in? Are you using any SQLHOSTS options in setnet32? Do you have the right INFORMIXSERVER set in setnet32? Guy koreilly@emangoe.com wrote: > Have installed IDS 10.0 on Windows XP. From the local host (that IDS > 10.0 is installed on) I can connect to the stores7 sample database > using dbaccess and Ilogin executable. > > When I attempt to connect locally to IDS 10.0 using the esql demo1.ec > example program, receive the error message 'Client host or user > (prod@powerlite)♥ is not trusted by the server.'. The state for the > error was IX000 and code was -956. > >>From this same Windows host I can recompile the esql demo1.ec example > program and connect fine to an IDS 7.3 database server running on > another NT server host. The only program change in demo1.ec is > 'strcpy(InetLogin.InfxServer, "ol_dell1");' to connect to the NT host. > > Anyone know what I have to configure on the Windows XP host to resolve > this issue? > > Thanks in advance. >

Related threads

Glossary