topic ODBC read failed in QlikView

ODBC read failed

Tue, 12 Feb 2013 12:34:06 GMT

Hello all,

Upon trying to load data from a server using the ODBC connector and store the data into a qvd file.

'ODBC CONNECT32 TO [Visual FoxPro Database'

i get the same error message at exactly the same amount of data 46,263

'ODBC read failed

TICHERCA:

SQL SELECT * FROM ticherca'

'Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: 22003, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Visual FoxPro Driver]Error: Column 38 ( reducere )'

Is there a permission issue somewhere? Or a driver issue?

Please share your thoughts.

Thank you,

Bogdan

Re: ODBC read failed

alexandros17 — Tue, 12 Feb 2013 12:40:01 GMT

There can be two main reasons:

1) the driver not updated (but you can exclude this reason if other similar queries run)

2) the query returns fields with the same name

let me know

Re: ODBC read failed

Tue, 12 Feb 2013 12:53:43 GMT

Hey Alexandros,

I have 42 databases set up in a similar way and I am trying to get the information from all of them and afterwards concatenate the info into one bigger table.

I have only 1 server from which I can extract the data properly. When I try to connect to a different one, that is the error message that I get.

Re: ODBC read failed

alexandros17 — Tue, 12 Feb 2013 12:57:50 GMT

Try to define ODBC in a different way for each database, when you are in qlik, any time you use a table in a DB you have to change the ODBC connection. Probably you yet do this, otherwise let me know

Re: ODBC read failed

Tue, 12 Feb 2013 13:21:43 GMT

That is what I am doing I set up connections separately and I am trying to get only one table from each server. I seem to get the error message at the same amount of data every time I try to connect to the same server.

Re: ODBC read failed

rbecher — Tue, 12 Feb 2013 13:24:00 GMT

Hi Bogdan,

so, maybe it's a problem in the data itself at this specific record? Have you tried to read the data with another tool?

- Ralf

Re: ODBC read failed

alexandros17 — Tue, 12 Feb 2013 13:44:13 GMT

Try to load just one field in the table that gives you errors.

Re: ODBC read failed

Tue, 12 Feb 2013 14:15:51 GMT

Hey guys,

I managed to load the data using OLE DB and it works without any errors. I think I will be using this one. Even though QV crashes on my PC when using OLEDB, on the remote server I am loading the data it seems to be working.

Thanks everyone for your help.

Bogdan

Re: ODBC read failed

NotInMyHouse — Thu, 19 Dec 2019 09:00:41 GMT

Second one was my mistake nice job dude