SQL Server with linked server to IBM i 7.1

[arrow483]

I am trying to setup a MS SQL Server with a Linked Server to IBM i. I have done this before no problem, but it doesn;'t seem to like SQL 2012. This is the error I am getting. I have already checked permissions, logon, passwords - all look good. Suggestions to what I am missing?




Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

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

The OLE DB provider "IBMDA400" for linked server "AS400" reported an error. Access denied.
Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "IBMDA400" for linked server "AS400". (Microsoft SQL Server, Error: 7399)

For help, click: http://go.microsoft.com/fwlink?ProdN...9&LinkId=20476

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

[arrow483]

Re: SQL Server with linked server to IBM i 7.1

OK. I found a ingress setting in the provider. I now get the connection, and can select data. But data comes in hex or unreadable characters in the char fields, decimals work fine. EBCDIC to ASCII issue?

[arrow483]

Re: SQL Server with linked server to IBM i 7.1

Turns out the source file is CCSID 65535 and so never converts. I have to copy the data to a "normal" file CCSID=37 then it works ok.