topic Re: use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000 in QlikView

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

Wed, 11 May 2011 03:14:39 GMT

When I user ''OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;User ID=fbi_dw;Data Source=mic133] (XPassword is DORLQTRMITccWcBHBDZOXGC);'' to connect oracle .I reload again ,my date has someting error. how to solve it

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

ashfaq_haseeb — Wed, 11 May 2011 08:06:12 GMT

While loading data from oracle database, try to use date conversion functions.

Hope that helps

Regards

ASHFAQ

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

jonathandienst — Wed, 11 May 2011 09:40:53 GMT

Something like this:

MyTable:
LOAD Num(MYVALUE) AS MYVALUE

....;

SQL SELECT MYVALUE

FROM MYTABLE;

Wrapping numerical values with NUM will remove the trailiing zeroes which are causing the problem.

Jonathan

Re: use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

rbecher — Wed, 11 May 2011 09:56:57 GMT

I presume you're selecting from an Oracle view?

Just use Number format Integer.

- Ralf

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

Wed, 11 May 2011 11:18:42 GMT

Please give me some example，，thank you very much！

Regards

wsw19870908

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

Wed, 11 May 2011 11:18:59 GMT

Please give me some example，，thank you very much！

Regards

wsw19870908 wsw19870908

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

Wed, 11 May 2011 11:19:31 GMT

Please give me some example，，thank you very much！

Regards

wsw19870908 wsw19870908

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

rbecher — Wed, 11 May 2011 11:29:11 GMT

Can you upload an example app or the SELECT statement?

- Ralf

Re: use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

Wed, 11 May 2011 11:41:47 GMT

@TIQView - Ralf Becher 编写:
Can you upload an example app or the SELECT statement?
- Ralf

This is an example

Re: use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

rbecher — Wed, 11 May 2011 12:10:25 GMT

Do you know if "FBI_DW"."DIM_CALENDAR" is a table or view?

In the Oracle ODBC setting (haven no OLEDB yet) is an option Bind Number as Float, is this checked?

In the meantime you can adjust number formats in the QlikView document settings:

added second picture

Re: use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

Wed, 11 May 2011 13:01:04 GMT

"FBI_DW"."DIM_CALENDAR" is a table 。 now I use OLEDB beacuse it’s more faster。I used to connecting ODBC is ok。BUT now I have to use OLEDB.Do you have any other way to solve this problem, beacuse we have a lot of table and qvw,it will take us a lot of time.

Re: use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

rbecher — Wed, 11 May 2011 13:17:32 GMT

Which QlikView and Oracle versions you are using?

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

Thu, 12 May 2011 00:37:49 GMT

my QlikView versions is QlikView x64 10.00.8935.7 SR2，and

Oracle versions is oracle 10.2.0.1.0。

Windows Server 2003 Service Pack 2 for x64 Editions

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

rbecher — Thu, 12 May 2011 08:09:59 GMT

Is there a different behavior if you're using 32bit connect?

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

Thu, 12 May 2011 08:50:57 GMT

Hi, if I connect with oracle provider for oledb some field is 'fixed to 14 decimals ' in number format settings ,This is not what I want.

but I connect with microsoft oledb provider for oracle some field is 'number 14 precision ' in number format settings ,this is ok.

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

rbecher — Thu, 12 May 2011 09:02:07 GMT

What is the data type of those problem fields in Oracle?

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

Thu, 12 May 2011 09:10:31 GMT

number field

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

rbecher — Thu, 12 May 2011 09:26:29 GMT

I know , but which precision/scale?

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

Thu, 12 May 2011 09:30:49 GMT

it‘s only number。we are not define precision/scale。

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

rbecher — Thu, 12 May 2011 09:50:56 GMT

Same problem on 32bit Connect??

I think it is a bug..