Has anyone successfully linked to AS400 data using the SQLGateway and ODBC. I have tested the ODBC driver using MSExcel to query the AS400 data and this worked with no problems. I set up the same driver using SQL Gateway in Cache Configuration Manager and then tried to link to the data through SQL Manager but instead of seeing the datatables, I get an Error #5532. Any ideas?
TIA Hadi Kanan
