Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

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
Specialist III
Specialist III

Try it using some other path it may work

Not applicable
Author

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
Specialist III
Specialist III

Please check whether the collectible table is there or not

Not applicable
Author

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

Untitled.png

gautik92
Specialist III
Specialist III

check whether the collectible table is there in Scripting

Not applicable
Author

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;