Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Error but in database!

My database has already connected but why is this happening?

SQL##f - SqlState: S1000, ErrorCode: 4294947068, ErrorMsg: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Access denied (Authorization failed) (7512)

SQL SELECT *

FROM PUB.collectible

they another error will follow

Untitled.png

7 Replies
pokassov
Valued Contributor

Re: Error but in database!

Hello! As I can see the problems is you cant read this table due your rights: "Access denied"

Can you read data from this table using the same user and another client?

gautik92
Valued Contributor III

Re: Error but in database!

Try it using some other path it may work

Not applicable

Re: Error but in database!

why is that it cant read the table? what happen?
I try it in other client but the result is always the same.

btw, thanks for answering. hope you help me

gautik92
Valued Contributor III

Re: Error but in database!

Please check whether the collectible table is there or not

Not applicable

Re: Error but in database!

checked
same path and the collectibles are there
I think the problems is on database

Untitled.png

gautik92
Valued Contributor III

Re: Error but in database!

check whether the collectible table is there in Scripting

Not applicable

Re: Error but in database!

this was on my script but as you can see it always error

ODBC CONNECT32 TO tax (XUserId is NKaVGaFMYLbB, XPassword is QNQMUYAN);

Collectible:

LOAD pin as Colpin,

    "prop-type" as "Colprop-type",

    "user_id" as "Coluser_id",

    remarks as Colremarks,

    todate as Coltodate,

    "prev-assess" as "Colprev-assess",

    "curr-assess" as "Colcurr-assess",

    year,

    qtr,

    "basic_sef" as "Colbasic_sef",

    tin as Coltin,

    "penalty-bal",

    qtr2 as Colqtr2,

    "disc-bal",

    compro as Colcompro,

    "mode" as Colmode,

    "time_stamp" as "Coltime_stamp",

    PCINum as ColPCINum,

    MDINum as ColMDINum,

    BINum As ColBINum,

    SINum as ColSInum,

    Parcel,

    PType as ColPType,

    RPUNum as ColRPUNum,

    OwnerNum as ColOwnerNum,

    Basic as ColBasic,

    SEF as ColSEF,

    AssmtCount as ColAssmtCount,

    "Rev-Yr" as "ColRev-Yr",

    IdleTax as ColIdleTax;

SQL SELECT *

FROM PUB.collectible;

Store Collectible into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Collectible.qvd;

Community Browser