Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
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

 
					
				
		
 pokassov
		
			pokassov
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
		
			gautik92
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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 
 
					
				
		
 gautik92
		
			gautik92
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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 

 
					
				
		
 gautik92
		
			gautik92
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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);
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;
