In a TCP/IP based local or wide area network (LAN or WAN) a Strategy Roundtable™ (Adaptive Server Anywhere) client sends out a broadcast message to find the Strategy Roundtable™ (Adaptive Server Anywhere) Database Server. To find the Server, the WAN hardware (routers and the like) must allow a broadcast message to traverse the network from the Strategy Roundtable™ client PC (IP address) to the Strategy Roundtable™ Database Server PC (IP address). In addition, the client needs to be patient enough to wait for the reply.

If you are able to PING the Database Server PC from the Client PC and broadcast messages are enabled, you should increase the default Adaptive Server Anywhere client timeout value of 5 seconds to make sure the client will hang in there long enough to hear a response from the Server. A higher timeout value needs to be set by modifying the Registry entries on the client PC. You need to ammend the data for the value name CommLinks in the Registry to:
CommLinks=tcpip(TO=20).

The CommLinks value is located under the following key(s) in the Registry:
[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\{database name}]
or
[HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\{database name}]

where {database name} = SR, ACME and the names of other databases that may have been created for Strategy Roundtable (Enterprise Edition only). Please be sure to update the CommLinks value for every database entry in the Registry.

If you are able to PING the Database Server PC from the Client PC but broadcast messages are NOT enabled, then you must add the HOST=[server ip address or DNS name] parameter to the appropriate parameter. Please change the data for the CommLinks value name to (using the correct IP address or DNS name of the server):
CommLinks=tcpip(TO=20;HOST=197.75.209.222)

The HOST command tells the Client exactly where to find the Server on the network (via the Server's IP address or DNS name) eliminating the need to send out a broadcast message - which won't make it through the switches and/or routers to the Server.

Both of these TCP/IP communications parameters can be set when you first install (or re-install) Strategy Roundtable.

If you do not know how to find or modify entries in the Registry, you can:

1. Uninstall and then re-install Strategy Roundtable (the installation software can be found in the ..\Gryphon_Systems\Sr_Server\client-install-set folder on the database server) and be sure to enter the IP address or computer name of the database server after (on the next page of the installation prompts) selecting the TCP/IP network communication protocol;
2. Call your Help desk (if your company has one);
3. Get help from the appropriate PC support person; or
4. Call us to walk you through the process.

Please call us or send us an e-mail if you haven't found what you need in these Support FAQs or the Product FAQs.