polybase converting to ANSI

[Former Member]

Hi
I am trying to ease integration between reporting ms sql server 2019 and sybase anywhere 17 ticket-master server.
I set up a linked server connection and a polybase connection, I would prefer to use polybase.

Here is my poly-base connection

CREATE EXTERNAL DATA SOURCE [TicketMaster] WITH (
    LOCATION = N'odbc://externalserver.com:50459'
    , CONNECTION_OPTIONS = 'DRIVER={SQL Anywhere 17};
    Host=externalserver.com:50459; 
    Provider = ''SAOLEDB.17'';
    ServerName= <servername>;
    DatabaseName=<databasename>;'
    , CREDENTIAL = [PolyFriend2]
    )

while I can create external tables my TSQL gets converted to ANSI,
SELECT TOP (1000) *

FROM [polygrab].[dbo].[ExtEvent_test]

Cannot execute the query "Remote Query" against OLE DB provider "MSOLEDBSQL" for linked server "(null)". 105082;Generic ODBC error: [SAP][ODBC Driver][SQL Anywhere]Syntax error near 'limit' on line 3 .