Don,
Perhaps you need to make sure you are establishing the correct location of the ODBC source itself. For example, in our application we allow the user to dictate at runtime the name of the ODBC DSN to use for the application. Then in our reporting routing, we loop through all the subreports in a report and set the ODBC server as follows:
oSubreport = oCrystalReport.OpenSubreport(aSubreports[i])
FOR EACH oTable IN oSubreport.Database.Tables
oTable.SetLogonInfo(cODBCDataSource)
ENDFOR
Hope that helps.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer