ODBC Failed

[rustyfishbones]

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

[Gysbert_Wassenaar · Accepted solution]

Perhaps the knowledge base of Progress can help:

knowledgebase.progress.com/articles/Article/8168

knowledgebase.progress.com/articles/Article/P12158

[rustyfishbones]

Thanks Gysbert,

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

Thanks

[rustyfishbones]

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]

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]

Hi Allan,

Where i can find the properties of ODBC connection?

Regards

Rohit

[rustyfishbones]

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

Choose System DSN

Click on Configure

[rustyfishbones]

Actually, disregard the above.

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

Regards

Alan