Use the following instructions to connect one client to multiple SQL Server instances:
. ./openlink.sh
[Server Types] DB2 = Informix 5 = Informix 6 = . . . Instance1 = Instance2 =
[Environment SQLServer 2005] FREETDSCONF = /usr/openlink/bin/freetds.conf DSQUERY = SQLSERVER ; Load this section from freetds.conf TDSHOST = host.domain ; Point this to your SQLServer machine TDSPORT = 1433 TDSVER = 8.0 SQLSERVER_CATALOG = Y CURSOR_SENSITIVITY = LOW ; Set to HIGH after loading oplrvc.sql
[Environment Server 1] FREETDSCONF = /usr/openlink/bin/freetds.conf DSQUERY = SQLSERVER ; Load this section from freetds.conf TDSHOST = 192.158.12.121 TDSPORT = 1433 TDSVER = 9.0 SQLSERVER_CATALOG = Y CURSOR_SENSITIVITY = LOW ; Set to HIGH after loading oplrvc.sql [Environment Server 2] FREETDSCONF = /usr/openlink/bin/freetds.conf DSQUERY = SQLSERVER TDSHOST = 192.158.12.121 TDSPORT = 1434 TDSVER = 9.0 SQLSERVER_CATALOG = Y CURSOR_SENSITIVITY = LOW ; Set to HIGH after loading oplrvc.sql
[Development DSN] Driver = /usr/openlink/lib/sql_mt_lt.so ServerType = Instance1 Username = sa ;Password = Database = Northwind Options = -H 192.158.12.121 -P 1433 -V 9.0 FetchBufferSize = 99 ReadOnly = no DeferLongFetch = no JetFix = no Description = connection to Instance1 [Production DSN] Driver = /usr/openlink/lib/sql_mt_lt.so ServerType = Instance2 Username = sa ;Password = Database = pubs Options = -H 192.158.12.121 -P 1434 -V 9.0 FetchBufferSize = 99 ReadOnly = no DeferLongFetch = no JetFix = no Description = connection to Instance2