Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rustyfishbones
Honored Contributor 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

Tags (3)
1 Solution

Accepted Solutions

Re: ODBC Failed

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
7 Replies

Re: ODBC Failed

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
Honored Contributor II

Re: ODBC Failed

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
Honored Contributor II

Re: ODBC Failed

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
Honored Contributor II

Re: ODBC Failed

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
Contributor III

Re: ODBC Failed

Hi Allan,

Where i can find the properties of ODBC connection?

Regards

Rohit

rustyfishbones
Honored Contributor II

Re: ODBC Failed

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
Honored Contributor II

Re: ODBC Failed

Actually, disregard the above.

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

Regards

Alan

Community Browser