Another option is to use the NT Registry as a directory service. Review the following Sybase product arrangements before settling on this method:
Adaptive Server Enterprise only – you can deploy an application on multiple clients and enter the network information once in the Registry on the Adaptive Server computer without needing to create and maintain a sql.ini file on every client.
Adaptive Server Enterprise and its bundled applications – the client applications that are bundled with Adaptive Server require a sql.ini file. Even if you are using the Registry for your own applications, you still need to maintain a sql.ini file if users are to connect from any of the Sybase client applications, such as Sybase Central or NetImpact™ Dynamo.
The following instructions create server name keys under the Registry key specified for “ditbase” in libtcl.cfg, in the example in step 2, SOFTWARE\SYBASE\SERVER. It also stores the network information in the keys.
Both the Adaptive Server and client applications look in the Registry for network information before searching the sql.ini file.
You will need both the Open Client/Open Server Configuration and the dsedit utilities.
To use NT Registry as a Directory Service:
Make sure the ocscfg.dat file is in your d:\sybase\bin directory.
Start the OC OS Config Utility.
Select Start/Programs/Sybase/OC OS Config Utility.
Select the Directory Services tab.
Type REGISTRY for the DS Name.
Type LIBDREG for the Directory Service Driver or select it from the drop-down list.
Type \\machine_name:SOFTWARE\SYBASE\SERVER for the Directory Service Ditbase, where machine_name is the name of the computer that stores the network information.
Click OK. The values you entered appear on the Directory Services dialog box.
You can also use a text editor to add the following lines to the libtcl.cfg file:
[NT_DIRECTORY] REGISTRY=LIBDREG ditbase=\\machine_name:SOFTWARE\SYBASE\SERVER
For information about using ocscfg, see the Open Client/Server Configuration Guide for Desktop Platforms.
Select Start/Programs/Sybase/ dsedit.
In the Select Directory Service dialog box, select Registry from the DS Name list, and click OK.
Follow the instructions in “How a client accesses Adaptive Server” for creating server entries using dsedit.