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: 
Not applicable

ODBC connection to Progress db

Hi,

We are attempting to read data from a Progress database using 'DataDirect 4.30 32-BIT OpenEdge SQL v10.0B' driver.

Initially we got some rows to load (8k from a possible 32+K, Excel loads 32k fine), we limited this to a single column and still only 8k from a possible 32k loaded.

Now we have another error "Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 4294757280, ErrorMsg: [DataDirect][ODBC OPENEDGE driver][OPENEDGE]Lock table is full. (7870)"

Can anyone provide any information on connecting and retrieving data from a progress database?

Thanks


4 Replies
Not applicable
Author

after further testing we have found that some tables will read and others will not..

erichshiino
Partner - Master
Partner - Master

Hi, richardconey

I'm not sure if this is your problem but many people have problems with field lenghts in progress.

There are some details here http://community.qlik.com/message/205020#205020

Basically, in the table definition there is a lenght of your fields but this lenghts don't need to be respected by the database, i.e. if your field is 30 characters long, it is possible to write a 50-char string.

The drivers cannot work properly under these conditions and you receive erros or only part of the tables.

There is a progress tool ( dbtools) to fix this problem.

Again, you might find more info in the link

Hope this helps,

Erich

Not applicable
Author

thanks but I do not believe this is a field length issue as I get limited results returned when I select 1 field from the table. Excel loads the records fine

Anonymous
Not applicable
Author

It is most likely your ODBC connection. If you google on the last part of your error "Lock table is full 7870" you will come across this article:

ODBC error - "LOCK TABLE IS FULL 7870"???! | ProgressTalk.com

...which educates on ODBC Default Isolation Levels. Your's is probably set to READ COMMITTED and you need it to be READ  UNCOMMITTED.

-- stocker