DBSERVERNAME Configuration Parameter

Home | Previous Page | Next Page The Database Server > Client/Server Communications > ONCONFIG Parameters for Connectivity >

DBSERVERNAME Configuration Parameter

The DBSERVERNAME configuration parameter specifies a name, called the dbservername, for the database server. For example, to assign the value nyc_research to dbservername, use the following line in the ONCONFIG configuration file:

DBSERVERNAME nyc_research

When a client application connects to a database server, it must specify a dbservername. The sqlhosts information that is associated with the specified dbservername describes the type of connection that should be made.

Client applications specify the name of the database server in one of the following places:

In the INFORMIXSERVER environment variable
In SQL statements such as CONNECT, DATABASE, CREATE TABLE, and ALTER TABLE, which let you specify a database environment
In the DBPATH environment variable

Windows Only

In Windows, the DBSERVERNAME cannot be changed in the configuration file, because the registry stores information about the database server instance under the DBSERVERNAME.

End of Windows Only

The DBSERVERNAME must specify either the dbservername or one of the dbserveraliases. The name must begin with a lowercase letter and can contain other lowercase letters, digits, and underscores. The name should not include uppercase characters, a field delimiter (space or tab), or a new line character. Other characters from the basic ASCII code set are not necessarily reliable. For example, a hyphen or minus sign can create problems and a colon might not work reliably. The @ character is reserved to separate the database from the server (as in dbase@server).