Error 761 and synonyms
Leo Cardoso got error 761 (INFORMIXSERVER does not match DBSERVERNAME or DBSERVERALIASES) when creating a synonym for a table in a database on a second server, on IDS 7.22 TC1 under NT4 SP3. Art S. Kagel said each server must be in the other's sqlhosts, each service in /etc/services, and each host in /etc/hosts on both machines. Leo said that was already done and the error persisted. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi all,
When I send this DDL in SERVER1 :
'create synonym syntable_s2 for database@SERVER2:table',
Informix gave me error 761- INFORMIXSERVER does not match either
DBSERVERNAME or DBSERVERALIASES.
INFORMIXSERVER is set for SERVER1, how can I make this synonym to
another server...
IDS 7.22 TC1, NT4 SP3
Thanks...
LEO Cardoso
---
Leo Cardoso wrote:
>
> Hi all,
>
> When I send this DDL in SERVER1 :
>
> 'create synonym syntable_s2 for database@SERVER2:table',
>
> Informix gave me error 761- INFORMIXSERVER does not match either
> DBSERVERNAME or DBSERVERALIASES.>
> INFORMIXSERVER is set for SERVER1, how can I make this synonym to
> another server...
>
> IDS 7.22 TC1, NT4 SP3
>
> Thanks...
> LEO Cardoso
>
> ---
In order for remote synonyms to work each of the servers MUST be
defined in each other's sqlhosts file, each service MUST be declared
in /etc/services on both machines, and each server's host machine MUST
be listed in the /etc/hosts file on both machines.
Art S. Kagel
hi, > > 'create synonym syntable_s2 for database@SERVER2:table', > > Informix gave me error 761- INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES. > > IDS 7.22 TC1, NT4 SP3 > In order for remote synonyms to work each of the servers MUST be > defined in each other's sqlhosts file, each service MUST be declared > in /etc/services on both machines, and each server's host machine > MUST be listed in the /etc/hosts file on both machines. Already done and the 761 error persist... another tip? :) Thanks LEO Cardoso --- --== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.---
Hi...
>> When I send this DDL in SERVER1 :
>> 'create synonym syntable_s2 for database@SERVER2:table',
>> Informix gave me error 761- INFORMIXSERVER does not match either
>> DBSERVERNAME or DBSERVERALIASES.
>In order for remote synonyms to work each of the servers MUST be
>defined in each other's sqlhosts file, each service MUST be declared
>in /etc/services on both machines, and each server's host machine MUST
>be listed in the /etc/hosts file on both machines.
Don't know! :) Another good tip?
[]ao and thanks again
LEO Cardoso
---