I am getting the following error message extracting Data from a PROGRESS DB
[OPENEDGE]Failure getting record lock on a record from table
Has anyone come across this error before, if so how did you go about fixing it?
Perhaps the knowledge base of Progress can help:
I actually figured it out by changing the ODBC Setting in advanced tab, but I will give you the correct answer
Where i can find the properties of ODBC connection?
You can go to Run and type odbcad32
or go to C:\Windows\SysWOW64 and you will find it there.
When you click the icon following screen appears
Choose System DSN
Click on Configure
Actually I have another issue with Column Widths.
In the image above it has an option to Use Wide Character Types
I wonder will this help me avoid updating the SQL Widths and take the extra wide Characters???
I will give it a go now
Actually, I think the READ UNCOMMITTED will resolve the SQL Width issue.
I am no longer getting this issue about the Column Widths since I changed the READ COMMITTED to UNCOMMITTED
Actually, disregard the above.
We still need to run a procedure to change the SQL Widths
Retrieving data ...