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.

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?

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