Like most companies we have a few databases on MS SQL Server. Getting SQL server to talk to our iSeries isn?t a problem, SQL server can update and read tables on the iSeries using ODBC. However, trying to find a way to get the iSeries to talk to SQL Server has always been a problem.
That said, having a quick look at WDSC 7 it looks like you can set up a connection to SQL Server. I haven?t got this working (although I haven?t spent hours banging my head against the screen ? yet).
Before I spend hours/days looking further into this, will this (for example) allow me to request data from SQL Server and pass it back to the iSeries and if so does this work well?
That said, having a quick look at WDSC 7 it looks like you can set up a connection to SQL Server. I haven?t got this working (although I haven?t spent hours banging my head against the screen ? yet).
Before I spend hours/days looking further into this, will this (for example) allow me to request data from SQL Server and pass it back to the iSeries and if so does this work well?
Comment