Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

connecting to oracle

Hi All,

I am getting below error when i am trying to connect to oracle using ODBC . I am getting the error after 300 rows are loaded.

No data found

SQL Scriptline:

SQL State:S000

But the same is working fine when i using with crystal reports (ODBC) Connection.

I am not able to connect to OLEDB. I am getting the error as "Provider no longer avilable"

I am using Qlikview SR3.Database- Oracle 11g

4 Replies
Not applicable
Author

Please install QV 9 (SR 7) and load data from database which will work perfectly.

Not applicable
Author

Thanks Vionth .. I am trying it right away

Not applicable
Author

No it is not working

Not applicable
Author

Can you post the script ?  Have you tried it with ODBC ?  In our configuration ODBC is actually faster than OLEDB.