A sql.ini file entry has the form:
[SERVERNAME]
service_type=driver,address secmech=mechanism1,...,mechanismn
where:
SERVERNAME is an alias by which Open Client or Open Server recognizes which sql.ini entry to read. SERVERNAME must begin with a letter (ASCII a-z, A-Z); can contain letters, numbers, and underscores only; and have a maximum of 11 characters.
service_type specifies the type of connection.
For Windows, the options for service_type are:
“master” for a master line, which is used by server applications to listen for client queries.
“query” for a query line, which is used by client applications to find servers.
The master line and the query line of a sql.ini entry contain identical information. dsedit creates both types of lines for each entry. The resulting entry can be used by both clients and servers.
driver is the name of the network driver to use for the connection. A list of network drivers are:
Driver |
Description |
|---|---|
NLWNSCK |
Winsock TCP/IP driver |
NLMSNMP |
Named Pipes driver |
NLNWLINK |
SPX/IPX driver |
address is the network address for the specified server. The format of the address information depends on the network protocol used for the connection. The options for address are:
Protocol |
Format(s) |
Examples |
|---|---|---|
TCP/IP |
Two formats: 1. computer_name,port_number 2. ip-address port_number |
TEST,8877 130.214.30.25,8877 |
Named Pipe |
pipe_name: “\pipe” is a required prefix to all pipe names. Server pipes can only be local. (Local) \pipe\sql\query (Remote) \\computer_name\pipe\sql\query |
|
IPX/SPX |
Three formats: 1. server_name 2. net_number,node_number,socket_number 3. server_name, socket_number |
TEST 16,1,83BD TEST,83BD |
DECnet |
Four formats: 1. area_number.node_number,object_name 2. area_number.node_number,object_number 3. node_name,object_name 4. node_name,object_number |
1.23,SQLSERVER1 1.23,214 COLLIN,OBJECT_222 COLLIN,214 |
“secmech” is the identifier used to list the security mechanisms that a server supports. The “secmech” line is optional.
See “Security mechanisms” for more information about the secmech line.
mechanism1,..., mechanism are the security mechanisms that a server supports. You can specify multiple security mechanisms by using a comma (“,”) as a separator.
A security mechanism is listed as its object identifier. An object identifier is a globally unique series of numbers that maps to the local name for a security mechanism in the global object identifiers file.
See “The objectid.dat file” for more information about object identifiers.
