Re: OLE Access v6.1 vs. v7.1

On 14-Jul-2016 08:39 -0500, Brian Piotrowski wrote:

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.
<<SNIP>>

Re possibility of "no columns": Verify the data in the SYSCOLUMNS catalog VIEW [for that TABLE name, or more generally, such as noting almost no data for user libraries] and\or issue the request to check the status of the System Database Cross Reference (*DBXREF) using the *CHECK capability of the Reclaim Database Cross Reference (RCLDBXREF). IIRC there was a defect that, for lack of some PTFs being applied on the older release, that upon upgrade to v7r1 [IBM i 7.1] would delete and recreate a DBXref file [which would be logged in the history, for the period of the upgrade] and likely the effect would be visible by review the creation date of the file if the history is not available; the loss of the file QADBIFLD in QSYS, for example, would lose tracking for all database-file-columns.