IBMDA400 provider and linked server

[Guest.Visitor]

nobody replied, however here is the answer: http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q270119&

[Guest.Visitor]

We are using the above provider to talk to an AS400 from a .NET application. We are calling stored procedures written on the AS400. This works great for queries and updates. We then set up a SQL Server linked server as a 'gateway' to the AS400 (and other data stores) and everything still works great, except for UPDATES. We are unable to do do UPDATES when going through a linked server on SQL Server. We can do UPDATES when calling the AS400 directly from the .NET application and not going through SQL Server. We want to use SQL Server as our gateway so the calling clients have no idea of the data source, all they know is they go through SQL Server for data access. "The OleDB Provider IBMDA400 indicates that the object has no columns" is the error. Again, we only get this when going through a linked server on SQL Server. Anyody have any ideas on this one?

[Guest.Visitor]

Thanks for posting the followup, Greg! Brian