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"

[#1]

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"

[maxgro]

did you install/configure the odbc driver for oracle (and oracle client) on the server?

[#3]

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

[#4]

Yes odbc driver is installed and configured on the server as well as the Oracle client

[#5]

Hi Michael, I will have a look at the OLEDB Oracle client thanks Frank

[partenope]

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

[maxgro]

and the same connection does it works in a reload from the oracle server?

[#8]

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;

[#9]

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.

[#10]

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