Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
Master II
Master II

ODBC Failed

Hi All,

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?

Regards

Alan

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Perhaps the knowledge base of Progress can help:

knowledgebase.progress.com/articles/Article/8168

knowledgebase.progress.com/articles/Article/P12158


talk is cheap, supply exceeds demand

View solution in original post

7 Replies
Gysbert_Wassenaar

Perhaps the knowledge base of Progress can help:

knowledgebase.progress.com/articles/Article/8168

knowledgebase.progress.com/articles/Article/P12158


talk is cheap, supply exceeds demand
rustyfishbones
Master II
Master II
Author

Thanks Gysbert,

I actually figured it out by changing the ODBC Setting in advanced tab, but I will give you the correct answer

Thanks

read_uncommitted.png

rustyfishbones
Master II
Master II
Author

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

rustyfishbones
Master II
Master II
Author

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

Regards

Alan

rohit214
Creator III
Creator III

Hi Allan,

Where i can find the properties of ODBC connection?

Regards

Rohit

rustyfishbones
Master II
Master II
Author

Hi Rohit,

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

2014-10-02_0859.png

Choose System DSN

2014-10-02_0900.png

Click on Configure

2014-10-02_0900_001.png

rustyfishbones
Master II
Master II
Author

Actually, disregard the above.

We still need to run a procedure to change the SQL Widths

Regards

Alan