topic Re: 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" in QlikView

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"

Wed, 02 Jul 2014 14:43:44 GMT

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"

Re: 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 — Wed, 02 Jul 2014 14:51:17 GMT

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

Re: 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"

Wed, 02 Jul 2014 15:05:59 GMT

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

Re: 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"

Wed, 02 Jul 2014 15:10:24 GMT

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

Re: 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"

Wed, 02 Jul 2014 15:11:40 GMT

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

Re: 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"

partenope — Wed, 02 Jul 2014 15:16:58 GMT

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

Re: 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 — Wed, 02 Jul 2014 15:23:42 GMT

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

Re: 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"

Wed, 02 Jul 2014 15:29:11 GMT

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;

Re: 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"

Wed, 02 Jul 2014 15:44:32 GMT

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.

Re: 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"

Wed, 02 Jul 2014 19:55:02 GMT

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

Re: 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"

Wed, 02 Jul 2014 20:04:23 GMT

Hi Frank,

but this is not "works as designed".

The rreport with direct discovery should be able to work with access as well.

If not there are some configuration issue.

How looks like your server environment (publisher, QVS, WebServer)?

Do you query the Database you are quering with the direct discovery as well on "default" QlikView scrip way

"Load *; SQL select .... from <db> where ....".?

Regards

Michael

Re: 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"

Thu, 03 Jul 2014 08:41:30 GMT

Guys, It is working in access point. changed connection from ODBC to Oracle OLEDB provider.

Thanks

Frank

Re: 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"

Thu, 03 Jul 2014 08:49:57 GMT

Re: 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"

partenope — Thu, 03 Jul 2014 12:41:03 GMT

Hi Frank!

It's my fault!

I did not understand the real issue!

I misunderstood the sentence "Dose Direct Connect work in Acces Point"! Obviously, the only case in witch you can have the connection error on Access Point could be using DIRECT statement!

Enjoy with Qlik!

Re: 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"

Thu, 03 Jul 2014 12:56:49 GMT

thanks anyway

Re: 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"

partenope — Thu, 03 Jul 2014 13:25:04 GMT

Michael Krauß,

thanks for the clarification!