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

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

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 未命名.JPG

24 Replies
Not applicable
Author

"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.

rbecher
MVP
MVP

Which QlikView and Oracle versions you are using?

Astrato.io Head of R&D
Not applicable
Author

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

rbecher
MVP
MVP

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

Astrato.io Head of R&D
Not applicable
Author

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.

rbecher
MVP
MVP

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

Astrato.io Head of R&D
Not applicable
Author

number  field

rbecher
MVP
MVP

I know , but which precision/scale?

Astrato.io Head of R&D
Not applicable
Author

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

rbecher
MVP
MVP

Same problem on 32bit Connect??

I think it is a bug..

Astrato.io Head of R&D