MS SQL Server ODBC - Invalid Descriptor Ind

Author

Invalid Descriptor Ind

Saqib Saleem

2005-11-12, 3:23 am

I am using Crystal Reports 8.0 in Visual Basic 6.0 With SQL Server 7.0.

When I pass the parameters to the report to see the results the following
error message appears

"ODBC Error : [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index"

Can anyone help me.

Saqib

ziran lin

2005-11-18, 3:23 am

Looks like a SQLGetData error

This artical may helps
http://msdn.microsoft.com/library/d...-us/odbc/htm/od
bcusing_sqlbindcol.asp
....
There are a number of restrictions on using SQLGetData. In general, columns
accessed with SQLGetData:

Must be accessed in order of increasing column number (because of the way
the columns of a result set are read from the data source). For example, it
is an error to call SQLGetData for column 5 and then call it for column 4.
Cannot be bound.
Must have a higher column number than the last bound column. For example,
if the last bound column is column 3, it is an error to call SQLGetData for
column 2. For this reason, applications should be careful to place long
data columns at the end of the select list.

Sponsored Links