Problem:

Data for the application is in more than one SQL Server Named Instance.  How can Acu4GL access tables in multiple named instances?

Solution:

There are four things you must do to enable Acu4GL to successfully access multiple SQL Server named Instances:

1. Set MSSQL as the default in the Runtime configuration file:

     DEFAULT_HOST MSSQL

2. Set the default connection in the Runtime configuration file to one of the named instances:

     A_MSSQL_DEFAULT_CONNECTION SERVERNAME\INSTANCE1

3. Set file aliases in the Runtime configuration file for accessing tables in the other instances, using the Named Instance port number in the fully qualified table name. Something like:

     MYTABLE SERVERNAME,nnnn.DATABASENAME.DBO.MYTABLE

     (that is servername comma port number with no spaces)

Note that if you are using version 9.2.5 or later you can use the Named Instance name in this format ‘SERVERNAME\INSTANCE1’ but you must add the following to your Runtime configuration file:

     A_MSSQL_STRIP_PATH_INFO OFF

This has implications for disk files that relay on FILE_PREFIX so be sure to read the documentation on it.

4. The Acu4GL stored procedures must be installed in each named instance that will be accessed.