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 ONCONFIG1 file.
You have the INFORMIXSERVER set to DBSERVER01 in your environment or database URL.
You try to connect and get error -761.
1The ONCONFIG environment variable points to the name of the IDS configuration file. The file resides in $INFORMIXDIR/etc (Unix) or %INFORMIXDIR%\etc (Windows).
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:
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"ARM Category":[{"code":"a8m500000008coBAAQ","label":"Connectivity"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"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"}}]
Was this topic helpful?
Document Information
Modified date:
10 October 2022
UID
swg21441243