Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QV10: Critical problem QvConnect64.EXE and QvConnect32.EXE!

Hello!
Have found a real critical for me problem in QvConnect.
Optimising my requests to my MSSQL DB I've found a problem in QvConnect.
I often use creating of temp tables in my apps on v.9, using next code:
SQL Select a, b, c into #tmp from table1;

And in the version 9 it works perfectly, thow in v.10 both QvConnect32 and QvConnect64 crash:
Problem signature: Problem Event Name: APPCRASH Application Name: QvConnect32.EXE Application Version: 10.0.8709.5 Application Timestamp: 4caf116f Fault Module Name: QvConnect32.EXE Fault Module Version: 10.0.8709.5 Fault Module Timestamp: 4caf116f Exception Code: c0000005 Exception Offset: 00019a4e OS Version: 6.1.7600.2.0.0.274.10 Locale ID: 1033 Additional Information 1: 0a9e Additional Information 2: 0a9e372d3b4ad19135b953a78882e789 Additional Information 3: 0a9e Additional Information 4: 0a9e372d3b4ad19135b953a78882e789


5 Replies
Qlik_Trigg
Employee
Employee

I dont know if it will immediately fix the problem but you dont seem to be using the IR (initial release) version of QV10. Your build number (8709) is behind the IR build (8715). You may want to download the IR and retry.

Are you running a 32 or 64 bit version of QV?

Do you have a 64 bit or a 32 bit driver for MSSQL?

Regards

John Trigg

QlikView Product Manager

Not applicable
Author

No, 8715 also crashes.

I'm running 64bit version of QV.

ummm... didn't understood about driver...

I've found that using ODBC connect everything works fine, thow using OLEDB crashes the QvConnect. Wrote this to my local support, they told me that they succesfully reproduced this bug and will write a message to QlikTech about it.

Qlik_Trigg
Employee
Employee

If you are running a 64 bit qlikview and only have a 32 bit driver for MSSQL, then you would use QVConnect32 for that connection in the script. Otherwise if you have a 64 bit driver, you dont need to specify Connect64 for the MSSQL connection.

Not applicable
Author

I've tried all the possible variants - using CONNECT, CONNECT32 or CONNECT64 - all of them crash when using OLEDB

Not applicable
Author

Hi,

Is there any solution to use QvConnect32/64.exe from an external program, we want to use it from "QlikView Visual Script Generator" in order to propose same functionalities that in QlikView.

Would be great if we can have some documentation on how to use these exe's

John