Section Access and OLEDB error

[#1]

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.

C

[avinashelite]

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.

[jonathandienst]

Hi

I suggest you post the script that is failing.

Jonathan

[#4]

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;

/*

[avinashelite · Accepted solution]

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.

[#6]

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