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