Good morning all,
We're experiencing a problem with accessing our IBM i from an SQL server, and I think it might have something to do with our OS upgrade, but I'm not sure how to fix it.
Prior to July 1st we were running a linked server in MS SQL 2008 that worked fine. It would connect to the table on the IBM i and download the data without incident. However, we upgraded to v7.1 on July 5th, and now none of our linked servers to the IBM i will access the data. When the system tries to access the data, it's getting the error message "Cannot process the object "<table name>". The OLE DB provider "IBMDA400" for linked server "<linked server name>" indicates that either the object has no columns or the current user does not have permissions on that object.
We noticed this problem with our Zend server earlier this week and we were able to resolve it by selecting the specific columns in our SQL statement instead of the generic "Select * from <table>" statement. However, with this problem on the SQL server we are selecting specific columns, but it is still failing.
Has anyone experienced this problem and if so, how did you resolve it? Are there specific permissions we need to set to allow the SQL server to access the data now that we're on 7.1?
In terms of the setup for the linked server, here's what we have:
Provider: IBM DB2 for i IBMDA400 OLE DB Provider
Product name: (we put in the IBM i model - E4D) - I don't think this is a significant name (or maybe is it - not sure)
Data Source: (IP address of the IBM i)
Provider String: User Id=<username>;Password=<password>;Default Collection=<Library name for data location>;
Any advice would be most appreciated. :)
Thankee-sai!
/b;
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Brian Piotrowski
Manager - I.T.
Simcoe Parts Service, Inc.
Ph: 705-435-7814 x5995
Fx: 705-435-5029
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
http://www.simcoeparts.com<
http://www.simcoeparts.com/>
Please consider the environment. Don't print this e-mail unless you really need to.
The information contained in this communication is confidential and intended only for the use of those to whom it is addressed. If you have received this communication in error, please notify me by telephone (collect if necessary) and delete or destroy any copies of it. Thank you!
As an Amazon Associate we earn from qualifying purchases.