IBM Support

Error 761 trying to connect

Troubleshooting


Problem

You try to connect to a database server but you see this error: -761 INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES.

Symptom

-761 INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES.

Cause


The INFORMIXSERVER is not set correctly. It is most likely set using uppercase. DBSERVERNAME and DBSERVERALIASES should be set this way:

    The servername may have up to 128 lowercase characters.
    The servername must begin with a letter and can include any printable character, except the following characters:
    • Uppercase characters
    • A field delimiter (space or tab)
    • A newline character
    • A comment character
    • A hyphen, minus, or @ character


Here is an example that could cause the -761 error:
    DBSERVERNAME is set to dbserver01 in the ONCONFIG file.
    You have the INFORMIXSERVER set to DBSERVER01 in your environment or database URL.
    You try to connect and get error -761.

Environment


Resolving The Problem

Enter the INFORMIXSERVER using lowercase only. If your DBSERVERNAME or DBSERVERALIASES configuration parameters use uppercase then change them to lowercase to meet the naming convention detailed in the Cause section of this document.

For JDBC connection information go here:


Format of Database URLs

[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF025","label":"Platform Independent"},{"code":"PF008","label":"DYNIX\/ptx"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF022","label":"OS X"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.0;11.1;11.5;11.7","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSVT2J","label":"Informix Tools"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 January 2022

UID

swg21441243