Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-06-06 06:42 AM

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

6,356 Views
0 Likes
4 Replies
Not applicable
‎2011-06-06 07:31 AM
Author

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

197 Views
0 Likes
Not applicable
‎2011-06-06 07:34 AM
Author

In response to

Thanks Vionth .. I am trying it right away

197 Views
0 Likes
Not applicable
‎2011-06-07 04:57 AM
Author

In response to

No it is not working

197 Views
0 Likes
Not applicable
‎2011-06-07 06:53 AM
Author

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

197 Views
0 Likes