Benny.Giesbers
New Member
One of our clients wants to get data from their database into Excel sorted on a specific column. Since the installation of OpenEdge 10.1B03, this is causing their Microsoft Query to crash with a 'Socket closed. Server crash likely' error.
The Progress Knowledge Base is very clear about this: It is caused by a bug and the only thing we can do is upgrade to OpenEdge 10.1C. For more details, see ID P129270. Unfortunately, this upgrade is not an option for us at the moment, so we have to look for another solution.
Now we're trying to get the data from their database in a sorted way. The WHERE of our query contains 4 criteria. These 4 fields are in an index where the 5th (and last) field is the field we want to sort on. One would expect that the result of the query is sorted on this 5th field, but that's not the case.
Is there any way to let ODBC sort our data? USE INDEX is not a part of SQL-92, right?
The Progress Knowledge Base is very clear about this: It is caused by a bug and the only thing we can do is upgrade to OpenEdge 10.1C. For more details, see ID P129270. Unfortunately, this upgrade is not an option for us at the moment, so we have to look for another solution.
Now we're trying to get the data from their database in a sorted way. The WHERE of our query contains 4 criteria. These 4 fields are in an index where the 5th (and last) field is the field we want to sort on. One would expect that the result of the query is sorted on this 5th field, but that's not the case.
Is there any way to let ODBC sort our data? USE INDEX is not a part of SQL-92, right?