Discussion Board for collaboration on QlikView Scripting.
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 *
they another error will follow
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?
Try it using some other path it may work
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
Please check whether the collectible table is there or not
checked same path and the collectibles are there I think the problems is on database
check whether the collectible table is there in Scripting
this was on my script but as you can see it always error
ODBC CONNECT32 TO tax (XUserId is NKaVGaFMYLbB, XPassword is QNQMUYAN);
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",
"basic_sef" as "Colbasic_sef",
tin as Coltin,
qtr2 as Colqtr2,
compro as Colcompro,
"mode" as Colmode,
"time_stamp" as "Coltime_stamp",
PCINum as ColPCINum,
MDINum as ColMDINum,
BINum As ColBINum,
SINum as ColSInum,
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;
Store Collectible into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Collectible.qvd;