Trying to Link Azure server hosted locally to Access (1 Viewer)

[sportsguy]

I used the sql server native 11 ODBC driver, but I can't open any columns with a decimal column type. Is there a different ODBC driver I can use, or any settings, or do I need to set the columns to currenty or long or something Access will recognize? I have set the columns in the security area to Other-> Public, but that doesn't change the outcome.
ODBC Sql Server 17 doesn't load, I haven't tried ODBC Sql Server 13

ERROR
ODBC--Call failed
Restricted Data type Attribute violation (#0)

Thanks in Advance

 

[sportsguy]

Using the CAST function solves the issue. . .