Invalid Descriptor Index

Problem

Receiving the following error:
“SQLGetDataA Failed: Invalid Descriptor Index”

Cause

This error occurs when blob fields (e.g., text, ntext, varchar(max)) are not placed as the last fields in the SQL query.

Solution

Ensure that all blob, text, ntext, and similar fields are placed at the end of the query in the source SQL.

Example

Set the source type to SQL and structure your query like this:

SELECT NormalField1, NormalField2, BlobField
FROM TableName;

This ensures compatibility and prevents the “Invalid Descriptor Index” error.

Video Tutorial

Watch our detailed video tutorial on resolving this issue and structuring queries correctly.