InterSystems support have kindly helped me out. Here's the solution:
Using Cache Configuration Manager -> Advanced Tab -> Input/Output enter a "Network Server" username/password. This gives Cache the appropriate privileges to access the AS/400 server. "Hadi" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 > >
