Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.