topic Re: ODBC Failed in QlikView

ODBC Failed

rustyfishbones — Wed, 01 Oct 2014 10:25:48 GMT

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

Re: ODBC Failed

Gysbert_Wassenaar — Wed, 01 Oct 2014 10:43:35 GMT

Perhaps the knowledge base of Progress can help:

knowledgebase.progress.com/articles/Article/8168

knowledgebase.progress.com/articles/Article/P12158

Re: ODBC Failed

rustyfishbones — Wed, 01 Oct 2014 11:15:17 GMT

Thanks Gysbert,

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

Thanks

Re: ODBC Failed

rustyfishbones — Wed, 01 Oct 2014 11:17:48 GMT

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

Re: ODBC Failed

rustyfishbones — Wed, 01 Oct 2014 11:22:52 GMT

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

Re: ODBC Failed

rohit214 — Wed, 01 Oct 2014 11:34:21 GMT

Hi Allan,

Where i can find the properties of ODBC connection?

Regards

Rohit

Re: ODBC Failed

rustyfishbones — Thu, 02 Oct 2014 08:02:43 GMT

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

Re: ODBC Failed

rustyfishbones — Thu, 02 Oct 2014 08:03:59 GMT

Actually, disregard the above.

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

Regards

Alan