BCP in SQL Server 2008 : can not find stored procedure 'sp_describe_first_result_set'

Question

My .bcp file was out from SQL Server 2016.

When I attempted bcp in SQL Server 2008 R2, an error occurred:

SQLState = 37000, NativeError = 2812
Error = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not find stored procedure 'sp_describe_first_result_set'

Can anyone give me some idea?

Answer 1

There's a potentially similar issue described on Connect here: Attempt to use BCP 2016 to export from SQL 2008 or earlier fails with obscure error message.

Try downloading the Windows ODBC driver.

Answer 2

I changed my location to bcp.exe at version 110 and ran ok

cd  C:\Program Files\Microsoft SQL Server\110\Tools\Binn
cp <commands>

Answer 3

It's funny but

bcp "$db$..$table$" out $file$.csv -c -t\t -T -S $server$

fails with the error.

SQLState = 37000, NativeError = 2812
Error = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not find stored procedure 'sp_describe_first_result_set'.

But this works OK:

bcp "select * from $table$" queryout $file$.csv -d $db$ -c -t\t -T -S $server$

Server is sql 2008, and client is Version: 13.0.1601.5.