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)