topic Section Access and OLEDB error in QlikView

Section Access and OLEDB error

Wed, 27 Aug 2014 13:57:31 GMT

Hi All,

I have been getting an OLEDB error message on a QV Model I am developing; up until now it has been working perfectly. There was a requirement to make the document available to other users with restricted data and therefore I've used Section Access.

With the Section Access the error message occurs, if i take it out it running fine. I use Section Access in other documents without errors; the only difference being my current document pulls directly from an SQL Server while the other models pull from QVDs.

Am I missing a setting i need to change on the document? Has anyone come across this?

Many thanks for an enlightenment and help in advance.

Re: Section Access and OLEDB error

avinashelite — Wed, 27 Aug 2014 14:14:11 GMT

Hi Chirag,

Connecting directly to SQL server will not pose the problem, I think its something else.

Can you please post the Error and script , let me check once.

Re: Section Access and OLEDB error

jonathandienst — Wed, 27 Aug 2014 14:14:36 GMT

I suggest you post the script that is failing.

Jonathan

Re: Section Access and OLEDB error

Wed, 27 Aug 2014 14:25:10 GMT

Hi Avinash,

The script is:

SECTION ACCESS;

LOAD ACCESS,

USERID,

PASSWORD,

ZONE

FROM [xxxAccess Control.xlsx]

(ooxml, embedded labels, table is Sheet1);

SECTION APPLICATION;

STAR IS *;

//********************************************* Connection ************

//=========================================================================

OLEDB CONNECT TO [

// Provider=SQLOLEDB.1;

Provider=SQLOLEDB.1;

Persist Security Info=True;

User ID=sa;

Initial Catalog="XXX"; <== this is our database name

Data Source=DBMaster3;

Use Procedure for Prepare=1;

Auto Translate=True;

Packet Size=4096;

Workstation ID=GBACT-DT218;

Use Encryption for Data=False;

Tag with column collation when possible=False] (XPassword is BZSCNZMGUbbOGWBL);

//********************************************* Company Postcode **********

//=========================================================================

AccountDetailsMap:

Mapping LOAD centre & AccountNumber as test1, Postcode;

SQL SELECT centre, AccountNumber, Postcode FROM dbo.tblCompany;

Re: Section Access and OLEDB error

avinashelite — Thu, 28 Aug 2014 04:26:45 GMT

Hi Chirag,

Script seems to be ok, but you should not use *.

>Star is is not recommended for use in your script, it is supported to maintain existing QlikView applications.

The Star character is not accepted in info load files.
The Start character cannot be used in the key fields, the fields that link tables.

Try use other characters. If you still face any issue please get the snapshot of the script.

Re: Section Access and OLEDB error

Thu, 28 Aug 2014 09:21:47 GMT

That appears to have done the trick! Thank you very much!