2659117 - Creating a proxy table may fail due to connecting to a wrong remote server - SAP ASE

• When trying to create a proxy table, it may fail and the error message indicates that ASE fails to connect to a different remote server from the specified remote server.
• In the following example, isql connects to "TOKYO" local server and tries to create a proxy table pointing to "OSAKA" remote server.
  However, ASE shows an error message which indicates that ASE fails to connect to "NAGOYA" remote server.

% isql -Usa -Ppassword -STOKYO
1> use testdb
2> go
1> create existing table test_table1 (
2> col1 int,
3> col2 char(20),
4> col3 varchar(30)
5> )
6> external table
7> at 'OSAKA.testdb.dbo.test_table1'
8> go
Msg 4002, Level 14, State 1:
Server 'NAGOYA', Line 1:
Login failed.
Msg 11206, Level 16, State 1:
Server 'TOKYO', Line 1:
Unable to connect to server 'NAGOYA'.
1>

SAP Adaptive Server Enterprise 15.7

proxy, create existing table, CIS, 11206, 4002 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To