Set up Adaptive Server Enterprise and Component Integration Services (CIS) to query MS SQL Server through DirectConnect.
For this example, assume that the server name is jones_1207.
mssql
master tcp ether hostname 12530
query tcp ether hostname 12530
sp_configure 'enable cis'
Parameter Name Default Memory Used Config Value Run Value
enable cis 1 0 1 1
(1 row affected) (return status=0)
sp_configure 'cis rpc handling', 1
enable cis 0 0 0 1
(1 row affected) Configuration option changed. The SQL Server need not be restarted since the option is dynamic.
sp_addserver mssql, direct_connect, mssql
Adding server 'mssql', physical name 'mssql' Server added. (Return status=0)
sp_addlogin tst, tsttst
Password correctly set. Account unlocked. New login created. (return status = 0)
grant role sa_role to tst use tst_db sp_adduser tst
New user added. (return status = 0)
use master sp_addexternlogin mssql, tst, chill, chill
User 'tst' will be known as 'chill' in remote server 'mssql'. (return status = 0)
isql -Utst -Ttsttst use test_db create proxy_table billing_tst at 'mssql.pubs..billing' select * from billing_tst
status name telno ------ ----------- ----- D BOTANICALLY 1 B BOTANICALL 2 (2 rows affected)