×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hello all,
I am faced with a situation that I can not understand.
We have an excel spreadsheet that do a qwery on an Iseries. With some users it works fine, with other we get the following error:
[IBM][ODBC System i Access Driver][DB2 for i5/OS]SQL0551 - Not authorized to object QZDA07600X in QGPL, type *SQLPKG]
With my user, it works fine so I cloned it. With the clone, I still get the error. The clone as *ALLOBJ but still gets the error.
I even deleted the QZDA07600X SKLPKG since it would get recreated by the system if necessary. I still get the error even if the object do not exist!!!!
I am out of idea.
Here is what I think are the key information:
We are at 7.2
Here is the connection string:
DRIVER={iSeries Access ODBC driver}; XDYNAMIC=0; PKG=QGPL/DEFAULT(IBM),2,0,1,0,512; LANGUAGEID=ENU;DFTPKGLIB=QGPL;DBQ=QGPL CDTAWHSE; SYSTEM=cas800re.cascades.com;
The query is a simple SELECT from a single file
Any help would be appreciated
[cid:image001.jpg@01D1F7D9.2487F9B0]<
http://www.cascades.com/_home>
Denis Robitaille
Chef de service TI - Solution d'entreprise
Infrastructure et opérations
CASCADES CENTRE DES TECHNOLOGIES
412 Marie Victorin
Kingsey falls(Québec) Canada J0A 1B0
Tél : 819 363 6100 Poste :52130
Cell : 819 352 9362
midrange.com
