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]

  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

    Sybase IQ/ 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


From → SAP IQ, Sybase ASE

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: