Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Database Connection Issue

Hi All!

This time, im consulting about database connections.

Lets suppose that i have an application that use some odbc or oledb connection to a database and i run the refresh of this application on a bat file.

Sometimes, some refresh freeze on the load in the connection time. So, sometimes, the procces remains paused because the connection was not successfull.

The problem its that, i cannot permit that those procces keeps stopped because other procces must run.

So, the question is, theres any way to check if some procces have some connection problem and stop it?

Thanks for all!

Germán

17 Replies
rbecher
MVP
MVP

I presume this will not occur with the OLE DB Provider (instead of ODBC)..

- Ralf

Astrato.io Head of R&D
Not applicable
Author

Thanks Ralf... i'll try it!

rbecher
MVP
MVP

I have downloaded it here:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=14839

- Ralf

Astrato.io Head of R&D
Not applicable
Author

Yes... thanks for this... i tryed many connectors... in fact...

Not applicable
Author

Hey Ralph, so I'm attempting to connect to the FoxPro tables, and I'm able to create the connection based off your example. I can then read the table, but it does not pull in any data. And I know for sure that ther is some there as I can open the table and see data. What could I be missing?

Here is my script.

OLEDB CONNECT32 TO [Provider=VFPOLEDB.1;Data Source=C:\Users\Public\Documents\MFHS\Abra\Abra\Data;Mode=Share Deny None;Extended Properties="";User ID="";Mask Password=False;Cache Authentication=False;Encrypt Password=False;Collating Sequence=MACHINE;DSN="";DELETED=True;CODEPAGE=1252;MVCOUNT=16384;ENGINEBEHAVIOR=90;TABLEVALIDATE=3;REFRESH=5;VARCHARMAPPING=False;ANSI=True;REPROCESS=5];

employees:

LOAD a_empno,

a_hours;

SQL SELECT *

FROM HATTRAN;

rbecher
MVP
MVP

Unfortunately this is not working anymore with my newest QlikView versions v10 SR4 and v11 SR1 on 64bit. It is just crashing qvconnect.exe

So, I started to use our QlikView JDBC Connector (http://bit.ly/A98Sdi) with the HXTT DBF driver (http://bit.ly/K7uNkT) which runs very smoothly now..

- Ralf

Astrato.io Head of R&D
Not applicable
Author

Yeah, it was just crashing the qvconnect.exe for me too. But then I through in your modified script at it pulled the table, but just not any data.

Alex Peasley

Business Intelligence Architect

Core BTS

608-661-7769

rbecher
MVP
MVP

Hi Alex,

this is the JAVA runtime config:

config1.png

this is the JDBC driver config:

setup_dbf.png

This is the QV script connect:

connect_foxpro.png

Just contact me directly if you have any question: ralf.becher@tiq-solutions.de

- Ralf

Astrato.io Head of R&D