Tags: client, connect, database, databaseusing, dbaccess, error, ids, ids10, informix, installed, local, mysql, oracle, sample, sql, stores7, trusted, windows

956 client not trusted error with IDS 10.0 on Windows

On Database » Informix

2,522 words with 2 Comments; publish: Mon, 19 May 2008 15:19:00 GMT; (25078.13, « »)

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.informix.todaysummary.com.powerlite)=E2=99=A5 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.

All Comments

Leave a comment...

  • 2 Comments
    • 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?

      #1; Mon, 19 May 2008 15:20:00 GMT
    • 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.informix.todaysummary.com.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.informix.todaysummary.com.powerlite)? is not trusted by the server.'. The state for the

      > error was IX000 and code was -956.

      >

      > 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.

      >

      #2; Mon, 19 May 2008 15:21:00 GMT