Have the following program that pulls a recordset from the AS/400 from Excel. It runs great as long as an ODBC driver is created and referred to for connectivity. However, would like to avoid installing the driver manually on every users PC so tested the following line Con1.Open "Driver={Client Access ODBC Driver (32-bit)};System=XYZ;Uid=ZZZZ;Pwd=ZZZZZ" in lieu of Con1.Open "DSN=USSO;UID=ZZZZ;PWD=ZZZZZ;" 'Connect to AS/400 this connects all right but get a run time error on line rs.Open Cmd1 and the recordset is not being returned. Any ideas would be appreciated.
Code
Code
Comment