- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Qlikview 11 R 5. Does Direct Connect work in Access Point.I can get it to work ok from the client connecting to an Oracle 11 database using ODBC. When I try it from Access Point I get message "Database Connection Failed"
Qlikview 11 R 5. Does Direct Connect work in Access Point.I can get it to
work ok from the client connecting to an Oracle 11 database using ODBC. When I
try it from Access Point I get message "Database Connection Failed"
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
did you install/configure the odbc driver for oracle (and oracle client) on the server?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Massimo Grossi answered you question already.
Just a my point of view to use ODBC connection for Qlikview applications, Best practice in my point of view would be just to use OLEDB connections QlikView Applications. In case of oracle that is the best way to keep it simple.
Regards
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes odbc driver is installed and configured on the server as well as the Oracle client
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Michael, I will have a look at the OLEDB Oracle client thanks Frank
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry Frank,
when, exactly, do you receive the error message?
The Access Point has no interactions with ODBC... The only step in witch QlikView has a connection with ODBC is when you (or the Server Scheduler) make a "reload".
The Access Point is only the web portal where you find and open qlikview document stored on the Server...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
and the same connection does it works in a reload from the oracle server?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi , I get the message when I open the document on Access Point. The document opens ok. When I select on an item from a list box (dimension) it does not refresh the measure values here is the script:-
CONNECT32 TO [jdedev11_fx2dta;DBQ=jdedev11] (XUserId is BAHLFTBPSBZIXQNH, XPassword is DVBVOTBPSBZIXQRL);
SET DirectTableBoxListThreshold = 2000000;
DIRECT QUERY
dimension
C1,
C2,
measure
M1,
M2,
M3
FROM FX2DTA.MV1;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So if you open a document on access point it will not be able to use the direct connect feature to refresh the measures. The direct connect will only work from a Qlikview clent application.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi partenope,
you are right but this changed with introducing QlikTechs Direct Discovery (and that is the issue here).
That will run SQL statements on "execution" time not only on realod time.
In that case the AccessPoint Server (better the one that runs the QVS Services) need a posibility to connect to the DB.
Regards
- « Previous Replies
-
- 1
- 2
- Next Replies »