SQL Express Problem

Posts   
 
    
Posts: 1
Joined: 16-Jan-2009
# Posted on: 16-Jan-2009 17:04:29   

Hi

I m using LLB Genpro 2.6 for my one windows application created in vb .net (.Net framework 2.0). I m using SQL Express 2005 to store data.

My connection string is this

<add key="Main.ConnectionString" value="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\bin\Debug\TGDAL\HGDB.MDF;Integrated Security=True;User Instance=True"/>

Now on saving data throgh my window application I am getting this error

SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException was unhandled by user code Message="An exception was caught during the execution of an action query: Invalid object name 'HG.dbo.tblPDQ'.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception." Source="SD.LLBLGen.Pro.ORMSupportClasses.NET20" RuntimeBuild="09112008" RuntimeVersion="2.6.0.0" QueryExecuted="\r\n\tQuery: INSERT INTO [HG].[dbo].[tblPDQ] ([Host_ID], [Opr_DataEntry], [AcctNo], [MRN], [MRN_Source], [ConsentForm1], [ConsentForm2], [Sty_TexGen], [Sty_InflamMarker], [Sty_EarlyMI], [DateOfIntervention], [DateOfInterview], [JTW_pt], [Prc_ACB], [Prc_CP], [Prc_MI], [Prc_Stent], [Prc_Aneurysm], [Prc_CHF], [Prc_Angio], [Prc_StentAngio], [Prc_Valve], [Prc_StableCAD], [Prc_Other], [Prc_PriorHD], [Prc_HDRisk], [DoNotContact_RelSty], [DoNotMail], [DoNotContact_Finding], [DoNotLocate_FU], [DoNotLocate_Rslt], [AdmissionSource], [Birthday], [Gender], [Height], [Weight], [SpokenEnglish], [SpokenSpanish], [SpokenOther], [Interpreter], [InterpreterType], [Race_White], [Race_Black], [Race_AmIndian], [Race_Chinese], [Race_Filipino], [Race_Japanese], [Race_Korean], [Race_Vietnamese], [Race_Hawaiian], [Race_Samoan], [Race_Guamanian], [Race_PacificIslander], [Race_OtherAsian], [Race_Other], [Descent_no], [Descent_Puerto], [Descent_Cuban], [Descent_CentralAm], [Descent_Mexican], [Descent_Other], [Education], [JobType], [Exposure], [Smoke_Status], [Smoke_Pack], [Smoke_Year], [Alcohol_Status], [Alcohol_Amount], [Alcohol_TimeUnit], [DLowSalt], [DLowFat], [DKosher], [DVeget], [DDiabetic], [Marriage], [Living], [Activity], [HH_Diabetes], [HH_Diabetes_Meds], [HH_Diabetes_Hosp], [HH_HBP], [HH_HBP_Meds], [HH_HBP_Hosp], [HH_Cholesterol], [HH_Cholesterol_Meds], [HH_Cholesterol_Hosp], [HH_Stroke], [HH_Stroke_Meds], [HH_Thyroid], [HH_Thyroid_Meds], [HH_Thyroid_Hosp], [HH_HeartD], [HH_HeartD_Meds], [HH_HeartD_Hosp], [HH_HeartAttack], [HH_HeartAttack_Meds], [HH_HeartAttack_Hosp], [HH_HeartAttackMen50], [HH_HeartAttackWomen55], [HH_CongenitalHeart], [HH_CongenitalHeart_Meds], [HH_CongenitalHeart_Hosp], [HH_Seizures], [HH_Seizures_Meds], [HH_Seizures_Hosp], [HH_Consciousness], [HH_Consciousness_Meds], [HH_Consciousness_Hosp], [HH_Cancer], [HH_Cancer_Meds], [HH_OtherCardiac], [HH_OtherCardiac_Meds], [HH_OtherCardiac_Hosp], [HH_SpecificCardiac], [Aspirin_pastMonth], [ChestPain], [Postmenopausal], [HormoneMeds], [Chemotherapy], [Deppress], [Deppress_DT], [Deppress_Med], [Depress_med_specify], [TMC_patient], [TMC_hospital], [Surgery], [BypassSurgery], [BypassSurgery_lt48hr], [BypassSurgery_lt1wk], [BypassSurgery_lt1mo], [BypassSurgery_lt1yr], [BypassSurgery_lt5yr], [BypassSurgery_lt10yr], [BypassSurgery_gt10yr], [Angioplasty], [Angioplasty_lt48hr], [Angioplasty_lt1wk], [Angioplasty_lt1mo], [Angioplasty_lt1yr], [Angioplasty_lt5yr], [Angioplasty_lt10yr], [Angioplasty_gt10yr], [StentPlacement], [StentPlacement_lt48hr], [StentPlacement_lt1mo], [StentPlacement_lt1yr], [StentPlacement_lt5yr], [StentPlacement_lt10yr], [StentPlacement_gt10yr], [Catheterization], [Catheterization_lt48hr], [Catheterization_lt1wk], [Catheterization_lt1mo], [Catheterization_lt1yr], [Catheterization_lt5y], [Catheterization_lt10yr], [Catheterization_gt10yr], [F_HeartAttack], [F_HeartAttack_Time], [F_Strok], [F_Strok_Time], [M_HeartAttack], [M_HeartAttack_time], [M_Strok], [M_Strok_Time], [NoBrotherSister], [NoBrotherSister_HeartAttack], [BSEventUnder60], [NoBrotherSister_Strok]) VALUES (@HostId, @OprDataEntry, @AcctNo, @Mrn, @MrnSource, @ConsentForm1, @ConsentForm2, @StyTexGen, @StyInflamMarker, @StyEarlyMi, @DateOfIntervention, @DateOfInterview, @JtwPt, @PrcAcb, @PrcCp, @PrcMi, @PrcStent, @PrcAneurysm, @PrcChf, @PrcAngio, @PrcStentAngio, @PrcValve, @PrcStableCad, @PrcOther, @PrcPriorHd, @PrcHdrisk, @DoNotContactRelSty, @DoNotMail, @DoNotContactFinding, @DoNotLocateFu, @DoNotLocateRslt, @AdmissionSource, @Birthday, @Gender, @Height, @Weight, @SpokenEnglish, @SpokenSpanish, @SpokenOther, @Interpreter, @InterpreterType, @RaceWhite, @RaceBlack, @RaceAmIndian, @RaceChinese, @RaceFilipino, @RaceJapanese, @RaceKorean, @RaceVietnamese, @RaceHawaiian, @RaceSamoan, @RaceGuamanian, @RacePacificIslander, @RaceOtherAsian, @RaceOther, @DescentNo, @DescentPuerto, @DescentCuban, @DescentCentralAm, @DescentMexican, @DescentOther, @Education, @JobType, @Exposure, @SmokeStatus, @SmokePack, @SmokeYear, @AlcoholStatus, @AlcoholAmount, @AlcoholTimeUnit, @DlowSalt, @DlowFat, @Dkosher, @Dveget, @Ddiabetic, @Marriage, @Living, @Activity, @HhDiabetes, @HhDiabetesMeds, @HhDiabetesHosp, @HhHbp, @HhHbpMeds, @HhHbpHosp, @HhCholesterol, @HhCholesterolMeds, @HhCholesterolHosp, @HhStroke, @HhStrokeMeds, @HhThyroid, @HhThyroidMeds, @HhThyroidHosp, @HhHeartD, @HhHeartDMeds, @HhHeartDHosp, @HhHeartAttack, @HhHeartAttackMeds, @HhHeartAttackHosp, @HhHeartAttackMen50, @HhHeartAttackWomen55, @HhCongenitalHeart, @HhCongenitalHeartMeds, @HhCongenitalHeartHosp, @HhSeizures, @HhSeizuresMeds, @HhSeizuresHosp, @HhConsciousness, @HhConsciousnessMeds, @HhConsciousnessHosp, @HhCancer, @HhCancerMeds, @HhOtherCardiac, @HhOtherCardiacMeds, @HhOtherCardiacHosp, @HhSpecificCardiac, @AspirinPastMonth, @ChestPain, @Postmenopausal, @HormoneMeds, @Chemotherapy, @Deppress, @DeppressDt, @DeppressMed, @DepressMedSpecify, @TmcPatient, @TmcHospital, @Surgery, @BypassSurgery, @BypassSurgeryLt48hr, @BypassSurgeryLt1wk, @BypassSurgeryLt1mo, @BypassSurgeryLt1yr, @BypassSurgeryLt5yr, @BypassSurgeryLt10yr, @BypassSurgeryGt10yr, @Angioplasty, @AngioplastyLt48hr, @AngioplastyLt1wk, @AngioplastyLt1mo, @AngioplastyLt1yr, @AngioplastyLt5yr, @AngioplastyLt10yr, @AngioplastyGt10yr, @StentPlacement, @StentPlacementLt48hr, @StentPlacementLt1mo, @StentPlacementLt1yr, @StentPlacementLt5yr, @StentPlacementLt10yr, @StentPlacementGt10yr, @Catheterization, @CatheterizationLt48hr, @CatheterizationLt1wk, @CatheterizationLt1mo, @CatheterizationLt1yr, @CatheterizationLt5y, @CatheterizationLt10yr, @CatheterizationGt10yr, @FHeartAttack, @FHeartAttackTime, @FStrok, @FStrokTime, @MHeartAttack, @MHeartAttackTime, @MStrok, @MStrokTime, @NoBrotherSister, @NoBrotherSisterHeartAttack, @BseventUnder60, @NoBrotherSisterStrok);SELECT @Haq=SCOPE_IDENTITY()\r\n\tParameter: @Haq : Int32. Length: 0. Precision: 10. Scale: 0. Direction: Output. Value: <undefined value>.\r\n\tParameter: @HostId : String. Length: 50. Precision: 0. Scale: 0. Direction: Input. Value: \"INTELLI-78\".\r\n\tParameter: @OprDataEntry : String. Length: 35. Precision: 0. Scale: 0. Direction: Input. Value: \"INTELLI-78\Administrator\".\r\n\tParameter: @AcctNo : String. Length: 13. Precision: 0. Scale: 0. Direction: Input. Value: \"44\".\r\n\tParameter: @Mrn : String. Length: 25. Precision: 0. Scale: 0. Direction: Input. Value: \"44\".\r\n\tParameter: @MrnSource : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 1.\r\n\tParameter: @ConsentForm1 : String. Length: 25. Precision: 0. Scale: 0. Direction: Input. Value: \"44\".\r\n\tParameter: @ConsentForm2 : String. Length: 25. Precision: 0. Scale: 0. Direction: Input. Value: \"44\".\r\n\tParameter: @StyTexGen : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: True.\r\n\tParameter: @StyInflamMarker : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @StyEarlyMi : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @DateOfIntervention : DateTime. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 01/01/1900 12:00:00 AM.\r\n\tParameter: @DateOfInterview : DateTime. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 01/16/2009 9:30:13 PM.\r\n\tParameter: @JtwPt : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @PrcAcb : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: True.\r\n\tParameter: @PrcCp : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @PrcMi : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @PrcStent : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @PrcAneurysm : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @PrcChf : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @PrcAngio : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @PrcStentAngio : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @PrcValve : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @PrcStableCad : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @PrcOther : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @PrcPriorHd : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: True.\r\n\tParameter: @PrcHdrisk : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @DoNotContactRelSty : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: True.\r\n\tParameter: @DoNotMail : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @DoNotContactFinding : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @DoNotLocateFu : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @DoNotLocateRslt : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @AdmissionSource : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @Birthday : DateTime. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 04/04/1944 12:00:00 AM.\r\n\tParameter: @Gender : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 1.\r\n\tParameter: @Height : Int32. Length: 0. Precision: 10. Scale: 0. Direction: Input. Value: 44.\r\n\tParameter: @Weight : Int32. Length: 0. Precision: 10. Scale: 0. Direction: Input. Value: 44.\r\n\tParameter: @SpokenEnglish : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @SpokenSpanish : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @SpokenOther : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @Interpreter : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @InterpreterType : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @RaceWhite : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @RaceBlack : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @RaceAmIndian : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @RaceChinese : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @RaceFilipino : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @RaceJapanese : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @RaceKorean : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @RaceVietnamese : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @RaceHawaiian : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @RaceSamoan : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @RaceGuamanian : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @RacePacificIslander : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @RaceOtherAsian : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @RaceOther : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @DescentNo : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @DescentPuerto : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @DescentCuban : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @DescentCentralAm : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @DescentMexican : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @DescentOther : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @Education : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @JobType : StringFixedLength. Length: 4. Precision: 0. Scale: 0. Direction: Input. Value: \"\".\r\n\tParameter: @Exposure : String. Length: 50. Precision: 0. Scale: 0. Direction: Input. Value: \"none\".\r\n\tParameter: @SmokeStatus : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @SmokePack : Single. Length: 0. Precision: 24. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @SmokeYear : Single. Length: 0. Precision: 24. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @AlcoholStatus : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @AlcoholAmount : Decimal. Length: 0. Precision: 5. Scale: 1. Direction: Input. Value: 0.\r\n\tParameter: @AlcoholTimeUnit : StringFixedLength. Length: 1. Precision: 0. Scale: 0. Direction: Input. Value: \"\".\r\n\tParameter: @DlowSalt : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @DlowFat : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @Dkosher : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @Dveget : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @Ddiabetic : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @Marriage : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @Living : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @Activity : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @HhDiabetes : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @HhDiabetesMeds : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhDiabetesHosp : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhHbp : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @HhHbpMeds : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhHbpHosp : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhCholesterol : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @HhCholesterolMeds : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhCholesterolHosp : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhStroke : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @HhStrokeMeds : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhThyroid : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @HhThyroidMeds : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhThyroidHosp : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhHeartD : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @HhHeartDMeds : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhHeartDHosp : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhHeartAttack : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @HhHeartAttackMeds : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhHeartAttackHosp : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhHeartAttackMen50 : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhHeartAttackWomen55 : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhCongenitalHeart : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @HhCongenitalHeartMeds : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhCongenitalHeartHosp : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhSeizures : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @HhSeizuresMeds : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhSeizuresHosp : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhConsciousness : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @HhConsciousnessMeds : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhConsciousnessHosp : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhCancer : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @HhCancerMeds : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhOtherCardiac : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @HhOtherCardiacMeds : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhOtherCardiacHosp : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @HhSpecificCardiac : String. Length: 50. Precision: 0. Scale: 0. Direction: Input. Value: \"\".\r\n\tParameter: @AspirinPastMonth : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @ChestPain : Decimal. Length: 0. Precision: 5. Scale: 1. Direction: Input. Value: 0.\r\n\tParameter: @Postmenopausal : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @HormoneMeds : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @Chemotherapy : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @Deppress : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @DeppressDt : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @DeppressMed : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @DepressMedSpecify : String. Length: 50. Precision: 0. Scale: 0. Direction: Input. Value: \"\".\r\n\tParameter: @TmcPatient : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @TmcHospital : String. Length: 50. Precision: 0. Scale: 0. Direction: Input. Value: \"\".\r\n\tParameter: @Surgery : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @BypassSurgery : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @BypassSurgeryLt48hr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @BypassSurgeryLt1wk : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @BypassSurgeryLt1mo : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @BypassSurgeryLt1yr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @BypassSurgeryLt5yr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @BypassSurgeryLt10yr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @BypassSurgeryGt10yr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @Angioplasty : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @AngioplastyLt48hr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @AngioplastyLt1wk : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @AngioplastyLt1mo : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @AngioplastyLt1yr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @AngioplastyLt5yr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @AngioplastyLt10yr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @AngioplastyGt10yr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @StentPlacement : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @StentPlacementLt48hr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @StentPlacementLt1mo : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @StentPlacementLt1yr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @StentPlacementLt5yr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @StentPlacementLt10yr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @StentPlacementGt10yr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @Catheterization : Boolean. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: False.\r\n\tParameter: @CatheterizationLt48hr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @CatheterizationLt1wk : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @CatheterizationLt1mo : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @CatheterizationLt1yr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @CatheterizationLt5y : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @CatheterizationLt10yr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @CatheterizationGt10yr : Int16. Length: 0. Precision: 5. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @FHeartAttack : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @FHeartAttackTime : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @FStrok : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @FStrokTime : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @MHeartAttack : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @MHeartAttackTime : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @MStrok : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @MStrokTime : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @NoBrotherSister : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @NoBrotherSisterHeartAttack : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @BseventUnder60 : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n\tParameter: @NoBrotherSisterStrok : Byte. Length: 1. Precision: 3. Scale: 0. Direction: Input. Value: 0.\r\n" StackTrace: at SD.LLBLGen.Pro.ORMSupportClasses.ActionQuery.Execute() at SD.LLBLGen.Pro.ORMSupportClasses.BatchActionQuery.Execute() at SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.ExecuteActionQuery(IActionQuery queryToExecute, ITransaction containingTransaction) at SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.AddNew(IEntityFields fields, ITransaction containingTransaction) at HGDBORM.EntityClasses.TblPdqEntity.InsertEntity() in E:\HG_ORM\GeneratedCode\EntityClasses\TblPdqEntity.cs:line 711 at SD.LLBLGen.Pro.ORMSupportClasses.EntityBase.CallInsertEntity() at SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.PersistQueue(List`1 queueToPersist, Boolean insertActions, ITransaction transactionToUse, Int32& totalAmountSaved) at SD.LLBLGen.Pro.ORMSupportClasses.EntityBase.Save(IPredicate updateRestriction, Boolean recurse)

Please suggest me what I am missing

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 16-Jan-2009 19:35:19   

Hi Atul,

Are you missing the Initial catalog="databaseNmae" connStr's parameter? This is copied from here:

AttachDBFileName The name of the primary file (include the full path name) of an attachable database. To use AttachDBFileName, you must also specify the database name with the provider string Database keyword. If the database was previously attached, SQL Server does not reattach it (it uses the attached database as the default for the connection).

So could you please try:

<add key="Main.ConnectionString" value="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\bin\Debug\TGDAL\HGDB.MDF; Initial catalog ="HG" ;Integrated Security=True;User Instance=True"/>
David Elizondo | LLBLGen Support Team