ASE 15.7: Create a Remote Server to SAP IQ 16.0

[Former Member]

1. Create the remote server entry in the interfaces file;  sql.ini (Windows) or interfaces (UNIX).

[myIQServer]

master=TCP,myIQHost,4091

query=TCP,myIQHost,4091

2. Add the remote server

sp_addserver 'myIQServer', ASIQ, myIQHost:4091'

3. Add the external login (SAP IQ) to be used by the local user (ASE) when connecting the SAP IQ database

sp_addexternlogin myIQServer, myLocalUser, myIQUser, myIQPassword

4. Verify connectivity using passthrough

connect to myIQServer

select @@version

@@version

------------------------------------------------------------------------------

Sybase IQ/16.0.0.653/131122/P/sp03/Sun_Sparc/OS 5.10/64bit/2013-11-22 01:16:26

1 record(s) selected [Fetch MetaData: 0ms] [Fetch Data: 0ms]

[Executed: 12/03/2014 2:00:20 PM] [Execution: 2ms]

disconnect from myIQServer

This document has previously been published in my personal blog at ASE 15.7: Create a Remote Server to SAP IQ 16.0 | ARBIME