SQL Server - Function request not Supported

Description

The "Function request not supported" error is a SQL Server error that occurs when the SQL Server drivers are missing or the wrong SQL Server drivers are installed on the system.

Discussion

If the server does not have the correct drivers when querying a SQL Server database, the following error can occur:

Function requested is not supported

This error occurs when the required drivers for SQL Server are not installed. This often occurs when the drivers that are installed are older than the version of SQL Server that is running. For example, the Date type does not exist in any version of SQL Server prior to SQL Server 2008. If the ODBC drivers installed on a system are older than the version of SQL Server installed, an error can occur when doing a SQL query that includes Date fields. This issue manifests as a "Function request is not supported" error in a Grid or UX Component populated from a SQL Server database.

To correct the problem, the drivers for communicating with the SQL Server database need to be updated on the server running the Alpha Anywhere Application Server:

1. Download the ODBC driver for your database from Microsoft. As of this writing, the following drivers are available:

SQL Server Version
Client Driver
2017,2019

ODBC Driver 17 for SQL Server

2016

ODBC Driver 13 for SQL Server

2014

ODBC Driver 11 for SQL Server

2012

SQL Server Native Client 11.0

2008

SQL Server Native Client 10.0

2005

SQL Native Client

Older Versions

SQL Server

2. Install the drivers on the server running Alpha Anywhere.

3. Test your application.

It is recommended to install the ODBC drivers Microsoft recommends for your version of SQL Server.

See Also