>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 >>