Exploratory Community

When importing data from MS SQL Server, "Invalid descriptor index" error is raised

#1

When importing data from MS SQL Server, the “Invalid descriptor index” error is raised like below.

Error in result_fetch(res@ptr, n) : nanodbc/nanodbc.cpp:3069: 07009: [Microsoft][ODBC SQL Server Driver]Invalid descriptor index

This could happen when you use an older ODBC driver. If this happens, please install the latest ODBC driver

https://www.microsoft.com/en-us/download/details.aspx?id=56567

And update your connection to use the ODBC driver

1 Like