topic Newbie Issue : ScriptError General ODBC Error in QlikView

Newbie Issue : ScriptError General ODBC Error

Tue, 22 Dec 2009 19:37:45 GMT

Hi ,

I recently downloaded Qlikview in order to evaluate the product for my compagny

i'm currently trying to play with it.

I had built up a ODBC data source on my PC in order to acces to an MS Sql Server 2008 database

I wrote a script on QV in order to download 2 tables in by database

but i have a big issue, it does not work [:(]

ater analysis i discovered that QV is not able ti handle "integer type" colunms

in my database

Here is my script :

ODBC CONNECT TO cngrweb2 (UserId is xxxx, Password is "zzzzz");

SQL SELECT idSubnets as id,
"No_Site" as NoSite,
"vc_ipReseau" as Ip,
"i_NetworkPrefixLength" as Prefix,
"vc_modeAcces" as Mode
FROM ramage.dbo.subnets;

trace ScriptError:$(ScriptError);

LOAD "no_qos",
"libel_qos";
SQL SELECT *
FROM ramage.dbo.qos;

on table ramage.dbo.subnets

idSubnets, No_Site and i_NetworkPrefixLength are integer values

without theses columns the script works fine

any idea ?

Newbie Issue : ScriptError General ODBC Error

Anonymous — Wed, 23 Dec 2009 01:55:53 GMT

The statement "QV is not able ti handle integer type colunms" is factually incorrect. QlikView would be completely useless if this was true.
I suspect that it is ODBC problem. Didn't use ODBC for awhile, used SQL Server 2008 (and older) only with OLEDB. Can't you use OLEDB?

Newbie Issue : ScriptError General ODBC Error

Wed, 23 Dec 2009 14:48:46 GMT

so i changed my ODBC driver and now it works fine

for information :

SQL Server 2000.85.1132.00 (SQLSRV32.DLL) ODBC driver works fine

SQL Server Native Client 10.0 2007.100.1600.22 (SQLNCLI10.DLL) ODBC driver seems to have some issues