INVALID DESCRIPTOR INDEX ODBC SQL SERVER DRIVER DOWNLOAD
But the exception handling is very poor. Close ; Insert a breakpoint on line 4. This way you get the full stacktrace and you can learn about the line number where this problem occurred. Q The information in this article applies to: Therefore, if the Text fields are not the last columns in the table, a call to SQLGetData results in the following error message:
|Date Added:||26 August 2017|
|File Size:||11.12 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Developing Multithreaded Applications Slow Chat: The solution I have found is: You can find the line number in the 1st line of the stacktrace.
There are various ways in which this scenario can manifest: Order in the table definition doesn’t matter. Reading columns out of sequence.
At what line exactly is it been thrown? Compile descrjptor run the application in debug mode. A SQLException with the message “Invalid descriptor index” is usually obtained when you read the result set incorrectly. Consider a table which has 5 columns:.
Invalid Descriptor Index calling SQLGetData
I’m afraid, some JDBC drivers will require you to read columns in order, starting at the first column. Close ; Insert a breakpoint on line 4. I doubt the exception is thrown by one of the lines in the posted code.
If possible please reply me on my email address, which is tejas.
Tepken Vannkorn invaliid 3 3 7. I think you can send a bill to Microsoft for finding a bug. Results 1 to 3 of 3 Thread: Name as abookName, soldItems. Email Required, but never shown.
Therefore, if the Text fields are not the last columns in the table, a call to SQLGetData results in the following error message: Post as a guest Name. GetFieldValue operation failed on field 7.
‘Invalid Descriptor Index
Dexcriptor will occur if you’re trying to get the resultset variable value in the index value of 0. Place your varchar max and or varbinary max fields at the end of your select Query.
Try to place your text and image columns at the end of select list. You may have to register or Login before you sescriptor post: Shashika Fernando 66 5. The time now is Sign up or log in Sign up using Google.
This way you get the full stacktrace and you can learn about the line number where this problem occurred. Q The information in this article applies to: That’s the way some drivers have been written; you cannot skip any columns when reading the resulting result set, as the drivers are actually reading a stream and converting objects in the stream to descriptpr of the JDBC types.