topic Slow Oracle ODBC and OLE DB Connections in QlikView

Slow Oracle ODBC and OLE DB Connections

Tue, 23 Jun 2009 22:24:15 GMT

I am currently configuring a new 64-bit server to run the 64-bit version of QlikView Publisher 8.5 and QlikView Developer 8.5. Everything is up and running and seems to be working. However, I am having some difficulty reloading QlikView apps that make use of Oracle OLE DB or ODBC connections.

Whenever I reload an app that contains an Oracle connection, it takes about 7 minutes for the query to start. If there are multiple queries in the app, it takes about 7 minutes between each of the queries plus the time it takes to actually run each query. On our 32-bit server, these queries start immediately.

Am I missing a configuration step with Oracle on my server? Is the server taking too long as there is some sort of delay in authentication? Any ideas on what is causing the delay?

Server Info:

Windows Server 2003 R2 Enterprise x64 Edition (SP2)
Oracle 10.2.0 (64-bit) -- naming methods is handled locally via tnsnames.ora
QlikView Publisher 8.5
QlikView Developer 8.5

Let me know if you need more information.

Slow Oracle ODBC and OLE DB Connections

sicilianif — Wed, 02 Sep 2009 18:30:06 GMT

Jason,

I seem to be having a similiar problem. I am able to run fine, if I run manually, but through the publisher it hangs on the first select. My server info is identical to yours.

Were you able to find a solution?

Slow Oracle ODBC and OLE DB Connections

Wed, 02 Sep 2009 19:38:42 GMT

I ended up contacting QlikTech support and they sent me instructions on how to install/configure Oracle on my 64-bit server. Everything is working great now.

Slow Oracle ODBC and OLE DB Connections

Thu, 10 Dec 2009 20:40:47 GMT

Hi,

Can you please tell us a bit more about what you did in order to solve the problem?
I have the same problem 🙂 on the same config.

Best regards

Slow Oracle ODBC and OLE DB Connections

pablolabbe — Mon, 29 Mar 2010 16:26:47 GMT

Can you tell us what did you do to solve this issue ?

Slow Oracle ODBC and OLE DB Connections

mike_garcia — Mon, 29 Mar 2010 18:04:16 GMT

Yes, Please Share...

Slow Oracle ODBC and OLE DB Connections

Tue, 30 Mar 2010 15:26:28 GMT

QlikTech support provided us a document titled "A QlikView Connection to Oracle's DB using OLE DB, both 32 and x64" that we used to setup the Oracle connections on our server. I recommend that you contact support and request this specific document.

Slow Oracle ODBC and OLE DB Connections

Mon, 16 May 2011 11:34:08 GMT

jasondyer 编写:
QlikTech support provided us a document titled "A QlikView Connection to Oracle's DB using OLE DB, both 32 and x64" that we used to setup the Oracle connections on our server. I recommend that you contact support and request this specific document.

how can I request this specific document？

Slow Oracle ODBC and OLE DB Connections

Mon, 23 May 2011 14:49:58 GMT

You might also like to look at Attunity's connector's to Oracle, annecdotal evidence from the field suggest they are multiple times faster than the native Windows or Oracle connectors. www.attunity.com

Slow Oracle ODBC and OLE DB Connections

danielrozental — Mon, 23 May 2011 15:19:11 GMT

You can see the document here http://es.scribd.com/doc/48674190/2063-A-QlikView-Connection-to-Oracle-1