I want to set up an ODBC connection between our AS400 mainframe and MS Excel 2002. I Installed Rumba Office 7.1 with al the nescessary drivers. My problem is that I can cannect when I have domain admin rights. When I connect using a domain user account I get an error in Excel "driver not capable. SqlSetConnectOption Driver's SQLSetConnectAttr failed communication link failure. APPC primary RC=Comm_subsystem_not_loaded".
Anybody any ideas?