topic Re: Error but in database! in QlikView

Error but in database!

Wed, 17 Jun 2015 01:08:34 GMT

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

Re: Error but in database!

pokassov — Wed, 17 Jun 2015 07:17:44 GMT

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?

Re: Error but in database!

gautik92 — Wed, 17 Jun 2015 07:22:48 GMT

Try it using some other path it may work

Re: Error but in database!

Wed, 17 Jun 2015 07:24:35 GMT

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

Re: Error but in database!

gautik92 — Wed, 17 Jun 2015 07:27:03 GMT

Please check whether the collectible table is there or not

Re: Error but in database!

Wed, 17 Jun 2015 07:33:57 GMT

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

Re: Error but in database!

gautik92 — Wed, 17 Jun 2015 07:39:26 GMT

check whether the collectible table is there in Scripting

Re: Error but in database!

Wed, 17 Jun 2015 07:46:04 GMT

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;