>>SELECT fca.id_num AS [Id Number], >> CAST(fca.sequence * 6 AS VARCHAR) + ' MONTH' AS [Description], >> fca.datesent AS [Sent To Cati], >> fcm.fudate AS [Received From Cati] >> FROM \\MyServer\g$\filestosurveyunit\followup\followup_sent_to_cati_all AS fca >> LEFT OUTER JOIN \\MyServer\g$\filesfromsurveyunit\followup\followup_from_cati_main AS fcm ON fca.id_num = fcm.ident >> WHERE fca.id_num = ? >>>>
>>System.InvalidOperationException: Fill: SelectCommand.Connection property has not been initialized. >> at System.Data.Common.DbDataAdapter.GetConnection3(DbDataAdapter adapter, IDbCommand command, String method) >> at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) >> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) >> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) >> at DataAccess.DBUtility.cls_soph_db_util.get_data_set(String str_select) in C:\Progs\Regards\RegardsDesktop\DataAccess\cls_soph_db_util.vb:line 688 >> at DataAccess.DBUtility.clsParticipantInformation.GetDataSetByParticipantId(String strParticipantId, String strSQL, DataSet& dsData, enConnectionStringFolder oFolder, String& strErrMsg) in C:\Progs\Regards\RegardsDesktop\DataAccess\clsParticipantInformationDbOps.vb:line 411 >>>>
>SELECT fca.id_num AS [Id Number], >> CAST(fca.sequence * 6 AS VARCHAR) + ' MONTH' AS [Description], >> fca.datesent AS [Sent To Cati], >> fcm.fudate AS [Received From Cati] >> FROM "\\MyServer\g$\filestosurveyunit\followup\followup_sent_to_cati_all.dbf" AS fca > LEFT OUTER JOIN "\\MyServer\g$\filesfromsurveyunit\followup\followup_from_cati_main.dbf" AS fcm ON fca.id_num = fcm.ident > WHERE fca.id_num = ?>