Oninit cdi / Archive
Talk to an expert →

Error 761 and synonyms

Posted in 1999

Topics: Networking & sqlhosts Configuration, Versions, Editions & End-of-Life

Leo Cardoso — — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Leo Cardoso
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Art S. Kagel
lfcardoso@hotmail.com — — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Art S. Kagel
Leo Cardoso — — source: Informix-list mailing list archive (1991-1998)

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

Glossary