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.5k5407241050
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: 785 times

last updated: 13 Apr '19, 12:52