iSeries :: Unable to Locate Schema

Data Source - Unable to Locate Schema


Scenario:

After setting up EBI Data Source we encountered an error when attempting to retrieve database tables.

Issue:

iSeries user is not set-up to allow for SQL Server access.

 
PowerTech Network Security 
All Network Security Groups - Rejected Transactions                                    

Taken  Group           Name       Name         Date     Time   User       Job Number/User/Name       Transaction                 

------ --------------- ---------- ---------- -------- -------- ---------- --------------------------------------------------------

Reject *NOGRP          *SQLSRV    EXECUTE    03/25/15 10:59:37 SHOPPE    885038/QUSER/QZDASOINIT     Server does not supply transa

Reject *NOGRP          *SQLSRV    EXECUTE    03/25/15 11:02:23 SHOPPE    885038/QUSER/QZDASOINIT     Server does not supply transa

Reject *NOGRP          *SQLSRV    EXECUTE    03/25/15 11:02:41 SHOPPE    885038/QUSER/QZDASOINIT     Server does not supply transa

Reject *NOGRP          *SQLSRV    EXECUTE    03/25/15 11:02:58 SHOPPE    885038/QUSER/QZDASOINIT     Server does not supply transa
     

EXTOL pop-up error message:


In EXTOL Business Integrator, a pop-up window is displayed indicate UNABLE TO LOCATE SCHEMA.



Resolution:

iSeries administrator must permit user to have *SQLSRV access, as such in example below.

	                                        Filter Rule Properties            

User        Server ID   Function    Authority   Aud  Msg  Cap  Switch Profile 
QSECOFR     *FTPSERVER  *ALL        *OS400       *    *    *   *NONE          
QSECOFR     *RMTSRV     *ALL        *OS400       *    *    *   *NONE          
QSECOFR     *SQLSRV     *ALL        *OS400       *    *    *   *NONE          
        


By: on
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.