A_MSSQL_DEFAULT_CONNECTION configuration variable

A_MSSQL_DEFAULT_CONNECTION specifies the name of the server to which the run-time system will connect. This variable is checked only if the DSQUERY environment variable has not been set. If neither DSQUERY nor A_MSSQL_DEFAULT_CONNECTION is set, the server is named localhost. To reference tables in another server, open the file servername.database.owner.table .


Suppose you have two servers, one named TOM and one named HARRY. If most of the tables you want to access are on the server HARRY, you should set:


For those occasions when you want to access the TOM server, you could open the file this way: