SERVER.MAP File

This system file helps establish an interface between Thoroughbred products and other databases, or enables new or existing applications to share data across a network:

For an overview of how the SERVER.MAP file works with the TS DataServer for Oracle product,

please refer to the SERVER.MAP File section.
For an overview of how the SERVER.MAP file works with the TS Network DataServer product,

please refer to SERVER.MAP File.
For an overview of how the SERVER.MAP file helps establish an interface and connection between

Thoroughbred products and ODBC-compliant databases, please refer to the SERVER.MAP File section.
For an overview of how the SERVER.MAP file works with the TS DataServer for MS SQL Server

product, please refer to the SERVER.MAP File section.
For an overview of how the SERVER.MAP file works with the TS DataServer for MySQL product,

please refer to the SERVER.MAP File section.

TS DataServer for Oracle

The SERVER.MAP file helps establish the interface between Thoroughbred products and ORACLE databases. It establishes a relationship between a two-character server ID used by Thoroughbred products and ORACLE servers.

If the file does not exist, you can create it as a simple ASCII file. If SERVER.MAP is not located in the current directory, the system searches the /usr/lib/basic directory, which is the default.

Entries in the SERVER.MAP file are formatted in the following way:

server-ID:{host-name|TCP/IP-address}[:TCP/IP-port][:data-source]

server-ID: is a two-character ID that refers to a server.
:: separates the server-ID from the data-source.
host-name: is the host name of the server system.
data-source: is the name of an alternate database to connect to. If not present, it defaults to "LocalServer".

When the Thoroughbred client and the database server reside on the same physical system, you can specify a loop-back address.

TCP/IP-address is the TCP/IP address of the server.

When the Thoroughbred client and the database server reside on the same physical system, you can specify a loop-back address.

:: separates the host-name|TCP/IP-address from the TCP/IP-port.
TCP/IP-port: is the TCP/IP port number. The default is 5673.

Specify a value to avoid conflict with another TCP/IP process that requires the default port number. The specified port number will be used by the transport protocol layer of TCP/IP to deliver the packet data to the requested application.

Examples of entries in the SERVER.MAP file follow:

OR:server1:5673
OR:198.189.167.20:5673

In the first line, the server-ID is OR, the host-name is server1, and the TCP/IP-port is 5673. The default has been specified as the value of the TCP/IP-port parameter.

In the second line, the server-ID is OR, the TCP/IP-address is 198.189.167.20, and the TCP/IP-port is 5673. The default has been specified as the value of the TCP/IP-port parameter.

Note: Comments beginning with # in position 1 are allowed in SERVER.MAP file. Lines that do not contain a colon are considered comments.

For more information on the SERVER.MAP file, please refer to TS DataServer for Oracle documentation.

TS Network DataServer

The SERVER.MAP file helps to enable new or existing applications to share data across a network. It establishes a relationship between a two-character server ID used by Thoroughbred applications and the server system.

If the file does not exist, you can create it as a simple ASCII file. If SERVER.MAP is not located in the current directory, the system searches:

/usr/lib/basic directory, for UNIX/Linux, or
C:\WINDOWS for Windows or C:\WINNT for Windows NT.

Entries in the SERVER.MAP file are formatted in the following way:

server-ID:{host-name|TCP/IP-address}[:TCP/IP-port][:PARENT][:SECURE]

server-ID: is a two-character ID that refers to a server.
:: separates the server-ID from the host-name.
host-name: is the host name of the server system.
TCP/IP-address: is the TCP/IP address of the server.
:: separates the host-name|TCP/IP-address from the TCP/IP-port.
TCP/IP-port: (optional) is the TCP/IP port number. The default is 5680.

:: separates the TCP/IP-port from optional keywords.
PARENT: (optional) is a keyword designating a server as the host for TS Network Basic.
SECURE: (optional) is a keyword specifying that secure communications with the server are required.

Examples of entries in the SERVER.MAP file follow:

S1:server1:5680
S2:198.189.167.20:5680
S3:mainserver::SECURE

In the first line, the server-ID is S1, the host-name is server1, and the TCP/IP-port is 5680. The default has been specified as the value of the TCP/IP-port parameter.

In the second line, the server-ID is S2, the TCP/IP-address is 198.189.167.20, and the TCP/IP-port is 5680. The default has been specified as the value of the TCP/IP-port parameter.

In the third line, the server-ID is S3, the host-name is mainserver. This is a secure connection using the default TCP/IP-port.

For more information on the SERVER.MAP file, please refer to TS Network DataServer documentation.

Thoroughbred Basic ODBC Client Capability

The SERVER.MAP file helps establish the interface and connection between Thoroughbred products and ODBC-compliant databases. It is located in the Thoroughbred root directory. If the file does not exist, you can create it as a simple ASCII file.

Entries in the SERVER.MAP file are formatted in the following way:

server-ID:data-source

server-ID: is a two-character ID that refers to a server.
:: separates the server-ID from the data-source.
data-source: is the data source name specified to Microsoft Windows.

Valid data source names can contain the letters A through Z, the letters a through z, and the digits 0 through 9. Data source names are case-sensitive.

Assuming that server-ID has been specified as S1 and data-source as NewSource, you can specify the following valid entry in the SERVER.MAP file:

S1:NewSource

For more information on the SERVER.MAP file, please refer to the Thoroughbred Basic ODBC Client Capability Customization Supplement.

TS DataServer for MS SQL Server

The SERVER.MAP file helps establish the interface between Thoroughbred products and MS SQL Server databases. It establishes a relationship between a two-character server ID used by Thoroughbred products and MS SQL Servers.

Entries in the SERVER.MAP file are formatted in the following way:

server-ID:{host-name|TCP/IP-address}[:TCP/IP-port][:data-source]

server-ID: is a two-character ID that refers to a server.
:: separates the server-ID from the data-source.
host-name: is the host name of the server system.
data-source: is the name of an alternate database to connect to. If not present, it defaults to "LocalServer".

When the Thoroughbred client and the database server reside on the same physical system, you can specify a loop-back address.

TCP/IP-address is the TCP/IP address of the server.

When the Thoroughbred client and the database server reside on the same physical system, you can specify a loop-back address.

:: separates the host-name|TCP/IP-address from the TCP/IP-port.
TCP/IP-port: is the TCP/IP port number. The default is 5674.

Examples of entries in the SERVER.MAP file follow:

MS:server1:5674
MS:198.189.167.20:5674

In the first line, the server-ID is MS, the host-name is server1, and the TCP/IP-port is 5674. The default has been specified as the value of the TCP/IP-port parameter.

In the second line, the server-ID is MS, the TCP/IP-address is 198.189.167.20, and the TCP/IP-port is 5674. The default has been specified as the value of the TCP/IP-port parameter.

Note: Comments beginning with # in position 1 are allowed in SERVER.MAP file. Lines that do not contain a colon are considered comments.

For more information on the SERVER.MAP file, please refer to TS DataServer for MS SQL Server documentation.

TS DataServer for MySQL

The SERVER.MAP file helps establish the interface between Thoroughbred products and MySQL databases. It establishes a relationship between a two-character server ID used by Thoroughbred products and MySQL servers.

Entries in the SERVER.MAP file are formatted in the following way:

server-ID:{host-name|TCP/IP-address}[:TCP/IP-port][:data-source]

server-ID: is a two-character ID that refers to a server.
:: separates the server-ID from the data-source.
host-name: is the host name of the server system.
data-source: is the name of an alternate database to connect to. If not present, it defaults to "LocalServer".

When the Thoroughbred client and the database server reside on the same physical system, you can specify a loop-back address.

TCP/IP-address is the TCP/IP address of the server.

When the Thoroughbred client and the database server reside on the same physical system, you can specify a loop-back address.

:: separates the host-name|TCP/IP-address from the TCP/IP-port.
TCP/IP-port: is the TCP/IP port number. The default is 5675.

Examples of entries in the SERVER.MAP file follow:

MY:server1:5675
MY:198.189.167.20:5675

In the first line, the server-ID is MY, the host-name is server1, and the TCP/IP-port is 5675. The default has been specified as the value of the TCP/IP-port parameter.

In the second line, the server-ID is MY, the TCP/IP-address is 198.189.167.20, and the TCP/IP-port is 5675. The default has been specified as the value of the TCP/IP-port parameter.

Note: Comments beginning with # in position 1 are allowed in SERVER.MAP file. Lines that do not contain a colon are considered comments.

For more information on the SERVER.MAP file, please refer to TS DataServer for MySQL documentation.

From the Customization and Tuning Guide: System Files, version 8.9.1. Open this page in the PDF