Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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.
I've tried all the possible variants - using CONNECT, CONNECT32 or CONNECT64 - all of them crash when using OLEDB
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