Are Sybase datetime fields supported in PolyBase exernal tables?

76 Views Asked by At

I'm working with PolyBase on SQL Server 2022. I have some tables with type "datetime NULL" on Sybase ASE 16.

When declaring an external table e.g.

CREATE EXTERNAL TABLE SYBASESCHEMA.SomeTable
(
    [SomeNiceTime] DATETIME NULL
)
WITH (LOCATION = N'SomeNiceDatabase.dbo.SomeTable', DATA_SOURCE = SYBASE_DS);

I receive an error message like the following one:

105083;The following columns in the user defined schema are incompatible with the external table schema for table 'SomeTable': 'SomeNiceTime' failed to be reflected with the error: 'The detected ODBC SQL_TYPE 11 is not supported for external generic tables.'

Does anyone know how this could be resolved?

0

There are 0 best solutions below