Skip to content

ASE 15.7: Create a Remote Server to SAP IQ 16.0

March 12, 2014
  1. Create the remote server entry in the interfaces file; sql.ini (Windows) or interfaces (UNIX).
  2. [myIQServer]
    master=TCP,myIQHost,4091
    query=TCP,myIQHost,4091

  3. Add the remote server

    sp_addserver ‘myIQServer’, ASIQ, myIQHost:4091′

  4. Add the external login (SAP IQ) to be used by the local user (ASE) when connecting the SAP IQ database
  5. sp_addexternlogin myIQServer, myLocalUser, myIQUser, myIQPassword

  6. Verify connectivity using passthrough
  7. 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

Advertisements

From → SAP IQ, Sybase ASE

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: