ARL import fails with "Error = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not find stored procedure 'sp_describe_first_result_set'"
ARL import fails with "Error = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not find stored procedure 'sp_describe_first_result_set'"
Summary
ARL import fails with "Error = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not find stored procedure 'sp_describe_first_result_set'"
Symptoms
Environment:
FNMPCompliance database is SQL Server 2008 to 2012
SQL Server Client Tools 2016 ( ODBC Driver 13 for SQL Server ) is installed on FlexNet Manager application server
ARL import fails with "Error = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not find stored procedure 'sp_describe_first_result_set'"
Cause
ARL import uses bcp.exe command. A Database Engine Stored Procedure 'sp_describe_first_result_set' was called implicitly by bcp.exe command. But this stored procedure is supported from SQL Server 2012.
Resolution
Uninstall SQL Server Client Tool 2016 and Install SQL Server Client Tool between version 2008 R2 to 2012 on FlexNet Manager application server.
