Dear friends,
I am facing this very unusual issue.
I have one select query which is retrieved from PROGRESS database in VB6 application using ODBC Recordset object (rsData)
the connection string is something like this
Provider=MSDASQL.1;Extended Properties="DRIVER={MERANT 3.60 32-BIT Progress SQL92 v9.1D};UID=XXX;PWD=XXX;DB=XX;PORT=XXX;HOST=XYZ.ABC.COM;FILEDSN=C:\DSN\ODBC\XXX.dsn"
Cursor Type :adOpenForwardOnly
Lock Type :adLockReadOnly
Then there is one statement as rsData.sort "xxx"
the select query works fine and it also gets the result.
but sometimes it gives the following error at statement rsData.sort "xxx"
[Datadirect-Technologies][ODBC PROGRESS driver]Error in row.
It happens for sometime and suddenly it works perfectly fine after 2-3 hours or sometimes even earlier.
I cant figure out whats going on here.
your suggestions would be highly appreciated.
Thank you.
Kedar
I am facing this very unusual issue.
I have one select query which is retrieved from PROGRESS database in VB6 application using ODBC Recordset object (rsData)
the connection string is something like this
Provider=MSDASQL.1;Extended Properties="DRIVER={MERANT 3.60 32-BIT Progress SQL92 v9.1D};UID=XXX;PWD=XXX;DB=XX;PORT=XXX;HOST=XYZ.ABC.COM;FILEDSN=C:\DSN\ODBC\XXX.dsn"
Cursor Type :adOpenForwardOnly
Lock Type :adLockReadOnly
Then there is one statement as rsData.sort "xxx"
the select query works fine and it also gets the result.
but sometimes it gives the following error at statement rsData.sort "xxx"
[Datadirect-Technologies][ODBC PROGRESS driver]Error in row.
It happens for sometime and suddenly it works perfectly fine after 2-3 hours or sometimes even earlier.
I cant figure out whats going on here.
your suggestions would be highly appreciated.
Thank you.
Kedar