topic Re: OLEDB Connection string missing out values when ODBC works fine with the same extract file. in QlikView

OLEDB Connection string missing out values when ODBC works fine with the same extract file.

matthewp — Fri, 15 Jun 2018 08:03:18 GMT

OLEDB Connection string missing out values when ODBC works fine with the same extract file.

I have a simple extract file with 1 query:

QUALIFY *;

MyQVTable:
LOAD *;

SELECT * FROM MyTable;

STORE MyQVTable INTO $(vQVDDirectory)\MyQVTable.qvd;

DROP table MyQVTable;

If I use the OLEDB connection string:

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=USERNAME;Data Source=SERVER;Extended Properties=""] (XPassword is PASSWORD);

It doesn’t return ALL my data but it does if I use ODBC

ODBC CONNECT TO [SERVER;DBQ=SERVER] (XUserId is USERNAME, XPassword is PASSWORD);

Re: OLEDB Connection string missing out values when ODBC works fine with the same extract file.

sateesh_genre — Fri, 05 Jun 2020 22:47:16 GMT

Is your issue solved ? We are also facing same issue in oracle

Re: OLEDB Connection string missing out values when ODBC works fine with the same extract file.

hmjason7 — Tue, 25 Aug 2020 10:40:35 GMT

Has someone solved this? I also have the same issue

Re: OLEDB Connection string missing out values when ODBC works fine with the same extract file.

racer25 — Tue, 25 Aug 2020 11:35:29 GMT

Had something similiar to this before and discovered it was actually a data issue rather rather than anything to do with Qlikview. Can I suggest you get a look at the raw data and see if you can learn whats odd between missing data and included data. Wwe found the missing data was too many decimal places so we fixed the data.

Re: OLEDB Connection string missing out values when ODBC works fine with the same extract file.

hmjason7 — Tue, 25 Aug 2020 12:40:39 GMT

I've checked the raw data and it doesn't seem to be related 😞

Re: OLEDB Connection string missing out values when ODBC works fine with the same extract file.

racer25 — Tue, 25 Aug 2020 13:44:49 GMT

Can I ask how you checked this data? Just throwing out that some tools might be using ODBC to connect to your data and it might still look the same. MS Access and Toad for me the data looked the same but SQL Query looked different. I'm know DBA but hoping the pointer might help.

Re: OLEDB Connection string missing out values when ODBC works fine with the same extract file.

sateesh_genre — Tue, 25 Aug 2020 17:50:45 GMT

Thanks for the reply.

Actually OLE DB is working fine in production server with the same app and same tables.Issue is with development server.

Re: OLEDB Connection string missing out values when ODBC works fine with the same extract file.

sateesh_genre — Tue, 25 Aug 2020 17:51:19 GMT

Issue is not resolved