Crystal Reports – Invalid Argument provided. Failed to open a rowset. Error in File Invalid argument for database

At first thought it ran OK in Crystal not when called from program.

Then checked that it ran from the program on the Crystal developer machine OK.

So runs OK on developer’s machine not on particular user’s machines.

Hence error with ODBC. Changed developer machine ODBC to use from SQLNCLI to SQL Server Native Client 10.0 i.e. SQLNCLI10 and then went to report and “Set Location” for the newest table, the report then worked on all machines