Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Why does CREATE EXISTING TABLE proxy_DUMMY AT 'XXX..SYS.DUMMY' fail for a V6 remote server when using DRIVER=SQL Anywhere 17, but it DOES work with DRIVER=SQL Anywhere 16?

AFAIK the same error message is produced for all remote servers up to V9 but works with V10 and up.

All tests were run on 17.0.9.4882.

-- SQL Anywhere 5.5 remote database ddd5 running on Adaptive Server Anywhere 6.0 server ddd6
-- DRIVER=SQL Anywhere 16 works
-- DRIVER=SQL Anywhere 17 throws "The remote table 'XXX..SYS.DUMMY' could not be found" on CREATE EXISTING TABLE

DROP TABLE proxy_DUMMY;
DROP SERVER XXX;
CREATE SERVER XXX CLASS 'SAODBC' USING 'ENG=ddd6; DBN=ddd5; UID=dba; PWD=sql; DRIVER=SQL Anywhere 16;AutoStop=NO;AutoStart=NO;CPOOL=NO';
CREATE EXISTING TABLE proxy_DUMMY       AT 'XXX..SYS.DUMMY'
SELECT * FROM proxy_DUMMY;

dummy_col
0

=====
-- SQL Anywhere 10 remote ddd10
-- DRIVER=SQL Anywhere 16 works
-- DRIVER=SQL Anywhere 17 works

DROP TABLE proxy_DUMMY;
DROP SERVER YYY;
CREATE SERVER YYY CLASS 'SAODBC' USING 'ENG=ddd10; DBN=ddd10; UID=dba; PWD=sql; DRIVER=SQL Anywhere 16;AutoStop=NO;AutoStart=NO;CPOOL=NO';
CREATE EXISTING TABLE proxy_DUMMY       AT 'YYY..SYS.DUMMY';
SELECT * FROM proxy_DUMMY;

dummy_col
0

asked 13 Apr '19, 09:57

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050
accept rate: 20%

edited 13 Apr '19, 09:57

Bottom line: When trying to connect to a V5 remote database running on a V6 server (or probably any 32-bit remote database up to V9) from a 32-bit V17.0.9.4882 database, use DRIVER=Adaptive Server Anywhere 6.0 or DRIVER=SQL Anywhere 16.

For a 64-bit V17 database, use DRIVER=SQL Anywhere 16 (driver versions 10 through 12 will probably work as well).

Never use DRIVER=SQL Anywhere 17... it really doesn't do "backward compatible" or "32-bit" :)

-- This works with Bin32
String: ENG=ddd6; DBN=ddd5; UID=dba; PWD=sql; DRIVER=Adaptive Server Anywhere 6.0

-- This works with Bin32
DSN=ddd6_ddd5 ...using driver Adaptive Server Anywhere 6.0

-- This works with Bin32
String: ENG=ddd6; DBN=ddd5; UID=dba; PWD=sql; DRIVER=SQL Anywhere 16;

-- This works with Bin32
DSN=ddd5_ddd6_16 ...using driver SQL Anywhere 16

-- This fails with Bin32  
String: ENG=ddd6; DBN=ddd5; UID=dba; PWD=sql; DRIVER=SQL Anywhere 17;
The remote table 'p019..SYS.DUMMY' could not be found

-- This fails with Bin32  
DSN=ddd5_ddd6_17 ...using driver SQL Anywhere 17
The remote table 'p018..SYS.DUMMY' could not be found
Note: ODBC Administrator - Test Connection becomes "Not responding"

=====

-- This fails with Bin64
String: ENG=ddd6; DBN=ddd5; UID=dba; PWD=sql; DRIVER=Adaptive Server Anywhere 6.0
Data source name not found and no default driver specified

-- This fails with Bin64
DSN=ddd6_ddd5 ...using driver Adaptive Server Anywhere 6.0
The specified DSN contains an architecture mismatch between the Driver and Application

-- This works with Bin64
String: ENG=ddd6; DBN=ddd5; UID=dba; PWD=sql; DRIVER=SQL Anywhere 16;

-- This works with Bin64  
DSN=ddd5_ddd6_16 ...using driver SQL Anywhere 16

-- This fails with Bin64
String: ENG=ddd6; DBN=ddd5; UID=dba; PWD=sql; DRIVER=SQL Anywhere 17;
The remote table 'p017..SYS.DUMMY' could not be found

-- This fails with Bin64
DSN=ddd5_ddd6_17 ...using driver SQL Anywhere 17
The remote table 'p018..SYS.DUMMY' could not be found
Note: ODBC Administrator - Test Connection becomes "Not responding"
(13 Apr '19, 11:09) Breck Carter
Replies hidden

...but wait, it gets worse; DRIVER=SQL Anywhere Native used to work when connecting from V16 to a V9 remote, but it does not work when connecting from V17 (same bogus "dummy not found" message).

(13 Apr '19, 12:52) Breck Carter
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×56

question asked: 13 Apr '19, 09:57

question was seen: 918 times

last updated: 13 Apr '19, 12:52