Setting up Sybase IQ to Connect to the ASE Server

Follow these steps to query Adaptive Server Enterprise data.

1. Add an entry to the Sybase IQ interfaces file:

   jones_1207
   master tcp ether jones 4101
   query tcp ether jones 4101

2. Create the user to connect to ASE:

   GRANT CONNECT TO tst IDENTIFIED BY tsttst
   GRANT dba TO tst

3. Log in as the added user to create the 'asejdbc' server class and add external login:

   isql -Utst -Ptsttst -Stst_iqdemo
   CREATE SERVER jones_1207 CLASS 'asejdbc' USING 'jones:4101/tst_db'
   CREATE EXISTING TABLE billing_iq AT 'jones_1207.tst_db..billing_txt' 
   SELECT * from billing_iq

   status				name          telno
   ------    -----------   -----
   D         BOTANICALLY   1
   B         BOTANICALL    2
   (2 rows affected)