Using IBMDA400 OLE DB driver to create linked server in MSSQL, need help translating data from CCSID 65535
I have installed Client Access (7.1) on our MS SQL 2014 server. I am using the IBMDA400 OLE driver to create a linked server to DB2 database one the iSeries. When I run a select statement on the data in a table a couple of fields are legible but most did not translate.
The fields that translate properly are ccsid 37 the ones that did not are ccsid 65535.
I have read several posts and tried putting various translation options in the Provider string. It seems as soon as I add add any additional string other than the "Default Collection = xxx" in the provider string the connection test fails.