SQL 2005 Mobile Loading 2003 Cabs

Jun 14, 2006

I am moving a VS 2003 Pocket PC app to VS 2005 and when I deploy the app from Visuyal Studio 2005 two sqlce cabs are deployed (in addition to the sqlce30 ones) namely

sqlce20.dev.ppc.wce4.armv4.CAB

and

sqlce20.ppc.wce4.armv4.CAB.

Now as I have documented in another thread (SQL 2005 Mobile : The file is not a valid database file) this gives me problems when I want to access the database being produced by replication. So I'm trying to eliminate the need for these cab files.

My pocket PC application uses two of my DLLs the first of which is my Business Objects. When I deploy this to my PDA I get the following build output

------ Build started: Project: BO, Configuration: Release Any CPU ------
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Vbc.exe /noconfig

/imports:Microsoft.VisualBasic,System,System.Collections,System.Collections.Generic,System.Data,Sys

tem.Diagnostics /nowarn:42016,41999,42017,42018,42019,42032,42036,42020,42021,42022 /nostdlib

/rootnamespace:MVnet.VS2005CF.MobileSeller.BO /sdkpath:"C:Program FilesMicrosoft Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCE" /netcf /doc:objReleaseBO.xml

/define:"CONFIG="Release",TRACE=-1,_MyType="Windows",PLATFORM="AnyCPU",PocketPC=TRUE"

/reference:"................Program FilesIn The Hand LtdADOCE In The Hand

v1.7RuntimeInTheHand.Data.Adoce.dll","................Program FilesIn The Hand LtdADOCE

In The Hand

v1.7RuntimeInTheHand.Interop.dll",..............VS2005CFReferences
eleaseMVnetApplicati

on.dll,"C:Program FilesMicrosoft Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Data.dll","C:Program FilesMicrosoft

Visual Studio 8SmartDevicesSDK\SQL ServerMobilev3.0System.Data.SqlServerCe.dll","C:Program

FilesMicrosoft Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.dll","C:Program FilesMicrosoft

Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Drawing.dll","C:Program

FilesMicrosoft Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Web.Services.dll","C:Program

FilesMicrosoft Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Windows.Forms.dll","C:Program

FilesMicrosoft Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Xml.dll" /debug:pdbonly

/filealign:512 /optimize+ /out:objReleaseBO.dll

/resource:objReleaseMVnet.VS2005CF.MobileSeller.BO.BO.frmError.resources

/resource:objReleaseMVnet.VS2005CF.MobileSeller.BO.Resources.resources /target:library

AmtechSynchroniser.vb AmtechAP_Board.vb AmtechAP_Circuit.vb AmtechAP_Completion.vb

AmtechAP_Domestic.vb AmtechAP_DomesticPeriodic.vb AmtechAP_DomesticSupplyCable.vb

AmtechAP_EmergencyLightingInspection.vb AmtechAP_FireDetectionCommissioning.vb

AmtechAP_FireDetectionInstallation.vb AmtechAP_FireDetectionServicing.vb

AmtechAP_FireDetectionSystemRevised.vb AmtechAP_FireDetectionVerification.vb AmtechAP_Job.vb

AmtechAP_MinorWorksNIC.vb AmtechAP_Periodic.vb AmtechAP_PeriodicBoardTest.vb

AmtechAP_PeriodicCircuitTest.vb AmtechAP_PeriodicRecommendations.vb AmtechAP_ProtectiveDevice.vb

AmtechAP_StandardRecommendations.vb AmtechAP_VersionInfo.vb AmtechICDBEntity.vb basMain.vb

basSQL.vb cAddress.vb cAnswer.vb cBlockAllocation.vb cBO.vb cCompany.vb cCustomer.vb cCustomerF.vb

cInvoice.vb cInvoiceLine.vb cJob.vb cNote.vb cOrder.vb cOrderF.vb cOrderLine.vb cPaymentLine.vb

cPaymentLineF.vb cPDA_Update.vb cProduct.vb cProductF.vb cProductStock.vb cProductStockF.vb

cQuestion.vb cQuestionAnswer.vb cReceipt.vb cRep.vb cRepF.vb cRepProductPrice.vb

cRepProductPriceF.vb cRepProductStock.vb cRepStockAdjustment.vb cRepStockOrder.vb

cRepStockOrderF.vb cSalesPosition.vb cSalesPositionF.vb cSupplier.vb cType.vb cTypeF.vb cVatCode.vb

cVisit.vb cVisitF.vb Database.vb EntityHelper.vb FleetMindercMakeModel.vb FleetMindercVehicle.vb

frmError.vb GradusGradusReport.vb IEntityForm.vb IManagedForm.vb ISQLInEntity.vb "My

ProjectAssemblyInfo.vb" "My ProjectResources.Designer.vb" PageSelection.vb PDAProduct.vb

Property.vb RDAControl.vb Synchroniser.vb "Web ReferencesFeedBackWSReference.vb" "Web

ReferencesWSPDADBReference.vb"
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(152) :

warning BC42104: Variable 'TableConfig' is used before it has been assigned a value. A null

reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(166) :

warning BC42104: Variable 'ATTable' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(292) :

warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(350) :

warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(400) :

warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(458) :

warning BC42104: Variable 'rstab' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(557) :

warning BC42104: Variable 'rsTab' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(611) :

warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(812) :

warning BC42104: Variable 'CDBSelectSQL' is used before it has been assigned a value. A null

reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(856) :

warning BC42025: Access of shared member, constant member, enum member or nested type through an

instance; qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(952) :

warning BC42104: Variable 'Prop' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1000) :

warning BC42025: Access of shared member, constant member, enum member or nested type through an

instance; qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1004) :

warning BC42025: Access of shared member, constant member, enum member or nested type through an

instance; qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1009) :

warning BC42104: Variable 'nCol' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1020) :

warning BC42104: Variable 'CDBSelectSQL' is used before it has been assigned a value. A null

reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1078) :

warning BC42104: Variable 'oProp' is used before it has been assigned a value. A null reference

exception could result at runtime.
vbc : warning BC42206: Maximum number of warnings has been exceeded.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Board.vb(231) : warning

BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Circuit.vb(239) :

warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Completion.vb(812) :

warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Domestic.vb(543) :

warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_DomesticPeriodic.vb(606

) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_DomesticSupplyCable.vb(

284) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_EmergencyLightingInspec

tion.vb(362) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths.

A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionCommission

ing.vb(270) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths.

A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionInstallati

on.vb(268) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A

null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionServicing.

vb(609) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A

null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionSystemRevi

sed.vb(293) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths.

A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionVerificati

on.vb(277) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A

null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Job.vb(340) : warning

BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_MinorWorksNIC.vb(314) :

warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Periodic.vb(619) :

warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_PeriodicBoardTest.vb(22

7) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_PeriodicCircuitTest.vb(

239) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_PeriodicRecommendations

.vb(181) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A

null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(113) : warning

BC42105: Function 'Version' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(176) : warning

BC42105: Function 'RepLogOn' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(443) : warning

BC42105: Function 'ExecuteSQL_ReturnIdentity' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(513) : warning

BC42105: Function 'InitialiseServiceOrderLines1' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(585) : warning

BC42105: Function 'GetVisit1' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(656) : warning

BC42105: Function 'GetCustomer1' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(728) : warning

BC42105: Function 'GetProduct1' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(798) : warning

BC42105: Function 'GetDataSet' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(868) : warning

BC42105: Function 'GetScalar' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1012) : warning

BC42025: Access of shared member, constant member, enum member or nested type through an instance;

qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1134) : warning

BC42104: Variable 'oCMD' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1176) : warning

BC42104: Variable 'oCMD' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1217) : warning

BC42104: Variable 'oCMD' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(238) : warning

BC42105: Function 'SelectSQL' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(342) : warning

BC42105: Function 'InsertSQL' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(404) : warning

BC42105: Function 'UpdateSQL' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(460) : warning

BC42104: Variable 'Prop' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(522) : warning

BC42104: Variable 'Prop' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(634) : warning

BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(847) : warning

BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(959) : warning

BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(1083) : warning

BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOFleetMindercMakeModel.vb(116) :

warning BC42104: Variable 'CurrentMake' is used before it has been assigned a value. A null

reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOFleetMindercMakeModel.vb(116) :

warning BC42104: Variable 'NewMake' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOFleetMindercVehicle.vb(132) :

warning BC42104: Variable 'V' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOGradusGradusReport.vb(39) :

warning BC42105: Function 'DisplayName' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOGradusGradusReport.vb(64) :

warning BC42105: Function 'CurrentSection' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(341) : warning

BC42105: Function 'ProductTypeInList' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(419) : warning

BC42104: Variable 'WhereSQL' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning

BC42104: Variable 'SelectSQL' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning

BC42104: Variable 'StockSQL' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning

BC42104: Variable 'CategoryValue2' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning

BC42104: Variable 'ProductSupplierJoinSQL' is used before it has been assigned a value. A null

reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(748) : warning

BC42107: Property 'SelectSQL' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(791) : warning

BC42107: Property 'CountSQL' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(850) : warning

BC42107: Property 'Products' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPageSelection.vb(8) : warning

BC40055: Casing of namespace name 'bo' does not match casing of namespace name 'BO' in file

'C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Board.vb'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOSynchroniser.vb(213) : warning

BC42104: Variable 'ErrorInfo' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcBO.vb(217) : warning BC42107:

Property 'AmtechDBPath' doesn't return a value on all code paths. A null reference exception could

occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcBO.vb(582) : warning BC42104:

Variable 'TableName' is used before it has been assigned a value. A null reference exception could

result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCompany.vb(848) : warning

BC42024: Unused local variable: 'Setting'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCustomer.vb(924) : warning

BC42104: Variable 'SaveCurrentVisit' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCustomer.vb(974) : warning

BC42105: Function 'GenerateInvoices' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCustomerF.vb(419) : warning

BC42104: Variable 'WhereSQL' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcJob.vb(411) : warning BC42105:

Function 'InvoicedVisitWithNoPO' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcJob.vb(449) : warning BC42104:

Variable 'V' is used before it has been assigned a value. A null reference exception could result

at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcOrderF.vb(7) : warning BC40056:

Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.PhoneAPI' doesn't contain

any public member or cannot be found. Make sure the namespace or the type is defined and contains

at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcOrderF.vb(9) : warning BC40056:

Namespace or type specified in the Imports 'MVnet.VS2005CF.MobileSeller.WebServices' doesn't

contain any public member or cannot be found. Make sure the namespace or the type is defined and

contains at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestion.vb(202) : warning

BC42105: Function 'RootQuestions' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestion.vb(212) : warning

BC42105: Function 'Questions_ForCompany' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestionAnswer.vb(238) : warning

BC42105: Function 'AnswersForQuestion' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestionAnswer.vb(244) : warning

BC42024: Unused local variable: 'sSQL'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestionAnswer.vb(254) : warning

BC42105: Function 'AnswersForQuestion_IncludeUserAnswers' doesn't return a value on all code paths.

A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcRepF.vb(354) : warning BC42104:

Variable 'oRep' is used before it has been assigned a value. A null reference exception could

result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(905) : warning BC42105:

Function 'PopulateComboFromRepProductCategories' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(917) : warning BC42025:

Access of shared member, constant member, enum member or nested type through an instance;

qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(967) : warning BC42024:

Unused local variable: 'sValue'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1228) : warning

BC42104: Variable 'nCol' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1300) : warning

BC42104: Variable 'PaymentsSplit' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1318) : warning

BC42104: Variable 'NoSignaturesSplit' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1336) : warning

BC42104: Variable 'CancellationsSplit' is used before it has been assigned a value. A null

reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1356) : warning

BC42104: Variable 'NotesColonSplit' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1413) : warning

BC42105: Function 'VisitResultCodes' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisit.vb(12) : warning BC40056:

Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.MVnetApplicationVB' doesn't

contain any public member or cannot be found. Make sure the namespace or the type is defined and

contains at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisitF.vb(8) : warning BC40056:

Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.PhoneAPI' doesn't contain

any public member or cannot be found. Make sure the namespace or the type is defined and contains

at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisitF.vb(9) : warning BC40056:

Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.MVnetApplicationVB' doesn't

contain any public member or cannot be found. Make sure the namespace or the type is defined and

contains at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisitF.vb(10) : warning BC40056:

Namespace or type specified in the Imports 'MVnet.VS2005CF.mobileseller.WebServices' doesn't

contain any public member or cannot be found. Make sure the namespace or the type is defined and

contains at least one public member. Make sure the imported element name doesn't use any aliases.
BO -> C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOinReleaseBO.dll
------ Deploy started: Project: BO, Configuration: Release Any CPU ------
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL

ServerMobilev2.0System.Data.Common.dll'
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL

ServerMobilev2.0wce400ARMV4sqlce20.ppc.wce4.armv4.CAB'
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL

ServerMobilev2.0wce400ARMV4sqlce20.dev.ppc.wce4.armv4.cab'
Deploying 'C:DevVS2005CFReferences
eleaseMVnetApplication.dll'
Deploying 'C:Program FilesIn The Hand LtdADOCE In The Hand v1.7RuntimeInTheHand.Interop.dll'
Deploying 'C:Program FilesIn The Hand LtdADOCE In The Hand

v1.7RuntimeInTheHand.Data.Adoce.dll'
Deploying 'C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOinReleaseBO.dll'
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 1 succeeded, 0 failed, 0 skipped ==========


which as you can see is bringing in the two cabs.

Is there an easy way to determine what exactly requires these two cabs?

I strongly suspect that it's a third party stuff from ADOCE which I'm using to access access databases on the PDA.

View 5 Replies


ADVERTISEMENT

VS2005sp1 Deploys SqlServer Mobile 3.0 Instead Of Compact Edition CABS

Jan 23, 2007

Hello

installed:

VS2005 Sp1

SSCE31VSTools-ENU.exe

SQLServerCE31-EN.msi



When creating mobile project in VS2005 it automaticaly adds reference to System.Data.SqlServerCe,



version: 3.0.3600.0

path: C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDK\SQL ServerMobilev3.0System.Data.SqlServerCe.dll



instead of: C:Program FilesMicrosoft SQL Server Compact Editionv3.1SDKinwce400System.Data.SqlServerCe.dll

version: 3.0.5300.0



When creating desktop solution I don't have this problem.



Please help!

Thanks

View 5 Replies View Related

Sql Server Mobile 2005 And VS 2003

Apr 17, 2007



Hi All:



I need one clarification. Can i use sql server Mobile 2005 and vs 2003 (.NetCF 1.0) for my application.



Thanks

Vamsi

View 5 Replies View Related

Loading Data In SQL Mobile 2005 From The Server Side And Not On The Handheld

Mar 31, 2006

Hello,

We are in need of some help around the use of SQL Server 2005 Mobile Edition.

The problem comes in when we have to import a large list of equipment ID€™s into the database.

The way that things work today is that the database only runs on the handheld computer, so we are having to process a large amount of data on the handheld therefore taking a lot of time.

If there were a way to have a €œseed€? database on the server side (running on Windows Server 2003 or similar) and import all of this data on the server side it would be more efficient and require less time.

Once the data was imported on the server side we can simply transfer this seed database down to the handheld

Could you please throw some light on the above queries.

Thanks in advance.

Jeeves



View 1 Replies View Related

Loading SQL Server 2005 Standard On Windows Web Edition 2003

Jan 16, 2008

Has anyone done this? If so, how? I saw the systems requirement pages and web edition is not listed as as supported OS, but it's what we have. TIA.

View 1 Replies View Related

SQL Server 2000 CE 2.0 On Windows Mobile 2003

Jan 28, 2008

Does SQL Server 2000 CE 2.0 work on Windows Mobile 2003?

Thank you,

Ken Carlino
ServiceMaster

View 6 Replies View Related

SQL Mobile Query Hangs PPC 2003 Device

Mar 11, 2006

I've written a query to pull data from a SQL Mobile database which seems to completely hang the device when I run it (I waited several minutes before warm-starting). Yes, it's a bit complex, but it works fine on the desktop version--completes pretty much instantly.

Are there any limits to SQL Mobile that might prevent me from writing such a query? There are not very many records in any of the tables (all are <20, except one which is ~2500).

Here is the query:

------------------------------------code---------------------------

SELECT oi.ProductID, g.GenusName, Species.SpeciesName, f.FormName, f.Abbr, sz.Sizes, su.SizeUnits, su.Abbr, pa.PackageName, pa.Abbr, oi.NumRequested, oi.NumProvided

FROM OrderItems oi

JOIN Products p ON p.ProductID=oi.ProductID

JOIN Varieties v ON p.VarietyID = v.VarietyID

JOIN Genus g ON v.GenusID=g.GenusID

JOIN Species ON v.SpeciesID=Species.SpeciesID

JOIN Grades gr ON gr.GradeID=p.GradeID

JOIN Form f ON gr.FormID=f.FormID

JOIN SizeUnits su ON gr.SizeUnitsID=su.SizeUnitsID

JOIN Sizes sz ON gr.SizeID = sz.SizeID

JOIN Packages pa ON p.PackageID=pa.PackageID

WHERE oi.OrderID=3

------------------------------------------code---------------------------------------

Any ideas? Thanks in advance.

-Kevin

View 6 Replies View Related

SQL Mobile In Pocketpc 2003 Se Desktop Connection

Aug 2, 2006

Hi

I'm developing a pocketpc 2003 application with visual studio 2005. It has a sql server mobile sdf file call datos.sdf.

I need to create a Windows Desktop application and i need to connect it when pocketpc is connected to desktop with activesync.

Any ideas or links with some code samples?

I have installed sql sever everywhere but i don't understand how i can do that connection.

Thanks

View 3 Replies View Related

SQL Server Mobile With Visual Studio 2003

Jan 2, 2006

I've recently noticed the availability of SQL Server Mobile, and would
like to take advantage of some of the new features, however, I'm
currently using Visual Studio 2003. The requirements state that Visual
Studio 2005 is required, but I was wondering if anyone has had any
success getting it to work with VS 2003?



I hope that I can do this with VS 2003, but if VS 2005 will be
required, I'd like to clear up a few issues before asking my workplace
to fork out more money for the upgrade:


What have your experiences been like in getting clients to
upgrade from SQL Server CE to SQL Server Mobile? I've seen some
postings regarding problems with specific devices which seem a bit
worrying, but I was wondering how easy it was in general.


Does SQL Server Mobile really do a good job of reclaiming wasted
space? Using SqlCeEngine's Compact method has caused problems due to
the required storage space to perform the operation.


The documentation states that using SQL Server 2000 with SP3A is
supported, but I was wondering if anyone has any experience with this?

Thanks in advance,

Adrien.

View 6 Replies View Related

SQL Server Mobile 2005 Merge Replication Problem On Windows Mobile 5.0

Aug 8, 2006



Dear ppl,

I am writing an application for a device (MDA Pro T-Mobile) having Windows Mobile 5.0 using

-MS .NET Compact Framework 2.0 SP-1
-SQL Mobile 2005.
-VS 2005 .NET

The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object.

"SQL Server Mobile encountered problems when opening the database."

repl.AddSubscription(AddOption.CreateDatabase);
repl.Synchronize();

I don't understand why I am having this error. It does create the database on AddSubscription() method but it is failing opening the database on Synchronise(). I have also tried uninstalling and then reinstalling all the SQL Mobile components in the following order.

-sqlce30.wce5.armv4i.cab
-sqlce30.repl.wce5.armv4i.cab
-sqlce30.dev.ENU.wce5.armv4i.cab

However, when i run this application on a device(Dell X50 AXIM) with Pocket PC 2003, it runs fine creating the database and sysnchronising it.

The target platform for the project is Windows Mobile 5.0 Pocket PC SDK.

Does any one have any clue what could be the problem ?

Regards
Nabeel

View 6 Replies View Related

SQL Mobile 2005 Replication - SQL Mobile DLL Could Not Be Loaded - Error 28559

Jun 15, 2006

I am migrating a pocket PC application from VS 2003 to VS 2005 and a few weeks ago I hit the following problem when replicating

A SQL Mobile DLL could not be loaded. Reinstall SQL Mobile. [ DLL Name=sqlceca30.dll]

Scanning forums for help I saw that other people had had this problem and one

http://www.eggheadcafe.com/aspnet_answers/NETFrameworkCompactFramework/Feb2006/post25814466.asp

suggested that this problem could be circumvented by getting the replication object early and then continuously using the same object for subsequent replications.

I did this and it works a lot better now but ever so often I get another error which is

Native Error 28559 SQL Mobile encountered problems when opening the database

My only option at this point is to stop and start the application which cures the problem.

View 4 Replies View Related

Problem Using SQL Server Mobile 2005 With Windows Mobile 5 Application

Mar 23, 2006

Hello,

I am developping a non-managed C++ application for PocketPC using a SQL Server mobile database.

The application is compiled for PocketPC 2003 and uses SQL Server Mobile v2. I use Visual Studio 2005. But I need to compile the application for Windows Mobile 5.0 devices. So I installed the WM5 SDK and had the WM5 into my project configuration.

The "ssceoledb.h" which I include incluses the "transact.h" file. But my problem is that this file is only provided with the PocketPC 2003 SDK and not in the WM5 SDK.
So I cannot use the WM5 configuration project with SQL Server. I also tried with the last SQL Server Mobile 2005 (ie v3.0) and the "ssceoledb30.h" also includes "transact.h".

Did I miss something to install ?
Do you know how I can resolve the problem ?

By advance, thank you for any answer.

--
Gregoire

View 9 Replies View Related

Win 2003 X64 + SQL 2005 &< Win 2003 32 + SQL 2000?

Jul 23, 2005

I may not be the best forum for this post, however I believe some onecan still help me or direct me somewhere else.I'm finding that win 2003 x64 and SQL 2005 CTP is slower than win 2003and SQL 2000.Machine A: Opteron 2.2 (248) w/ 2 cpus. 8GB memory. SCSI disk array.Windows Enterprise 2003 x64 final release. SQL Server 2005 enterpriseCTP.Machine B: Opeteron 2.2 (248) w/ 2 CPUs. 4GB Memory. IDE Drives.Windows Server 2003 (32bit) and SQL Server 2005 (standard).I'm using Cognos' DecisionStream as the ETL tool (32bit). I have theidentical job on both machines. Machine A is slower to do my nightlybuild (1h 20m) vs. Machine B (50m).I've done no tweaking of the databases. I Used SQL 2005's studio tocopy the database from Machine B to Machine A.The only major difference is the O/S and SQL, the machines are samespeed, however Machine A has twice the memory and faster disk; so Iwould expect it to be faster.Can anyone think of smoking guns I might be missing?TIA

View 2 Replies View Related

SQL Server 2005 Mobile Edition ANd SQL Server CE - SHould I Have Uninstalled Mobile First ?

Sep 16, 2007



Hi:

When I try and connecto to SQL CE I always get an invalid operation exception. I"m afraid that I did not follow the proper install for Orcas Beta 2. I can't remember if I was supposed to uninstall SQL Mobile 2005 first or not.

All I know is when I try and use my SQL CE I can't connecto to a DB / sdf file ?

Any help would be appreciated I"m just starting to use SQL CE.

thanks
mark

View 2 Replies View Related

How Do I Measure Bandwith Usage For Merge Replication SQL 2005 To Sql Server Mobile 2005?

Jan 24, 2007

Hi,

Is there any way to measure bandwith usage during merge replication between sql server 2005 and sql server mobile 2005 running on a cradled wm5 mobile device.

Attaching the windows performance monitor to the network connection established over usb would work although I was wondering if there was something specific for this case integrated into Sql server 2005 / sql server mobile 2005 / Sql server management studio / third party tools that i could use ?

thnx,

pdns.

View 4 Replies View Related

SQL Server Standard 2005, SQL Mobile 2005 Data Encryption Issues

Jul 26, 2007

Hi,

I have a central database server that is runnning on SQL 2005 standard edition and Windows server 2003 standard as OS.

I realise that I can use SQL statements to encrypt and decrypt the data inside the standard SQL.

However, how do I read and write the data via an web application coded in C#.net and is also running on the same machine?

Another issue is, I need to replicate some of the data in this SQL standard over to a SQL mobile running on a mobile device running on Windows CE 5.0.

The mobile device also needs to read and write data to the encrypted data via a C#.net application.

Question is, with all these requirements to be met, can I use AES? I know that AES is not available on Windows XP and Windows Server 2000 and I cant find AES in the .net compact framework.

how do i go about ensuring security? how do I ensure that the symmetric key is the same both on the SQL standard and SQL mobile?

thank you.

View 7 Replies View Related

RAPI CopyFileToDevice Slow After Switch From Mobile 2005 To Compact 2005

Sep 12, 2007

I have a windows forms application that runs on my PC that populates a SQL Server Compact 2005 database and then transfers that .sdf file to my mobile device. The communication between the mobile device and PC is done using the Desktop RAPI class from OpenNetCF (http://www.opennetcf.com/FreeSoftware/DesktopCommunication/tabid/90/Default.aspx)

Anyway, I was previously using SQL Server Mobile 2005 and my populated .sdf was around 1.7 MB and I could transfer it to my mobile device in a minute. Once I switched to SQL Server Compact 2005, the transfer process began taking 3 minutes with a 1.5 MB .sdf file. The SSCE also got bloated more easily so I added in the Compact operation each time after I fully populate the SDF to keep the file size at 1.5 MB, but even then it still takes 3 minutes.

I've done a few tests where I simply switch between the two database versions and that simple switch of the version changes the transfer time. I am dumbfounded trying to figure out what the cause might be. Since it is just a file transfer, why would the version even matter unless somehow SSCE is really not compacting and lying about its actual size.

Has anyone run into anything similar to this or may have any ideas what might be going on?

Thanks.

View 3 Replies View Related

SQL Server 2005 Management Studio Only Can Connect To 2005 Mobile Edition?

Jan 9, 2007

hi,

I have some SQL CE database .sdf file on my handheld, and I was trying to connect to that file via SQL Server 2005 Management Studio, and it does not work. I am wondering if there is any good tool that I can use on desktop to connect to sqlce .sdf database file on my handheld?

Thanks.

View 1 Replies View Related

Help Needed In Merge Replication, SQL Server 2005 Mobile Edition And VC# 2005

Apr 10, 2008

I have written following code in my application

I just want to display all the data of a Single table into a Data Grid, I know that we can drag and drop the table on to a form and datagrid is generated, but here I want to retrive those values through my code, how should i do that

I am getting following errors while running the program
Error 1) Error No. 28037, MS SQL Server 2005 Evrywhere Edition
Error: A request to send data to the computer running IIS has failed. For more information see HRESULT
Error 2) Error No. 0, SQL Server 2005 Evrywhere Edition ADO.Net Data Provider
Error: The specified table does not exist [ JobLists ].

Can anybody please tell me, where I went wrong ??? In this code anywhere else????

Note: While adding a Data Source of SQL Server 2005 Mobile Edition, I have added that .sdf file into my project, thats why I have written the Data Source as : .DbFile.sdf



@"Data Source = .DbDotNetCF.sdf";


The code is as follows:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;

namespace DeviceApplication1
{
public partial class Form1 : Form
{
string filename = @".DbDotNetCF.sdf";

private DataSet dsJobLists;

public Form1()
{
InitializeComponent();
}

private void DeleteDB()
{
if (System.IO.File.Exists(filename))
{
System.IO.File.Delete(filename);
}
}

private void Sync()
{
SqlCeReplication repl = new SqlCeReplication();

repl.InternetUrl = @"http://localhost/WebsiteDotNetCF/sqlcesa30.dll";
repl.Publisher = @"RAHU";
repl.PublisherDatabase = @"DotNetCF";
repl.PublisherSecurityMode = SecurityType.NTAuthentication;
repl.Publication = @"PubDotNetCF";
repl.Subscriber = @"SubDotNetCF";
repl.SubscriberConnectionString = @"Data Source='" + filename + "';Max Database Size=128;Default Lock Escalation =100;";
try
{
if (!System.IO.File.Exists(filename))
{
repl.AddSubscription(AddOption.CreateDatabase);
}
repl.Synchronize();
}
catch (SqlCeException ex)
{
DisplaySQLCEErrors(ex);
}
finally
{
repl.Dispose();
}


// Display Same Data In Another DataGrid : dataGrid1
SqlCeConnection cn = new SqlCeConnection(@"Data Source='" + filename + "'");

SqlCeDataAdapter daJobLists = new SqlCeDataAdapter("SELECT JobListsID, JobID, PersonID FROM JobLists", cn);
if (dsJobLists == null)
{
dsJobLists = new DataSet();
}
try
{
dsJobLists.Clear();
daJobLists.Fill(dsJobLists, "JobLists");
dataGrid1.DataSource = dsJobLists.Tables["JobLists"];
}
catch (SqlCeException ex)
{
DisplaySQLCEErrors(ex);
}
}

private void DisplaySQLCEErrors(SqlCeException ex)
{
for (int i = 0; i < ex.Errors.Count; i++)
{
MessageBox.Show("Index #" + i.ToString() + ""
+ ex.Errors.Source + ""
+ "Error: " + ex.Errors.Message,
"Error No. " + ex.Errors.NativeError.ToString());
}
}

private void Form1_Load(object sender, EventArgs e)
{
Sync();
DeleteDB();

if (DbDotNetCFDataSetUtil.DesignerUtil.IsRunTime())
{
// TODO: Delete this line of code to remove the default AutoFill for 'dbDotNetCFDataSet.JobLists'.
this.jobListsTableAdapter.Fill(this.dbDotNetCFDataSet.JobLists);
}
}
}
}



I have created a merge replication correctlly( I suppose, there were no errros)
Please help

Your help will be appriciated

View 1 Replies View Related

VS 2005/SQL Server2005 - Direct Connection From Win Mobile Emulator To Desktop SQL Server 2000 Or 2005

Aug 10, 2007

Hello Everyone,

I'm trying to connect to Desktop SQL Server 2000 from Windows mobile PC Emulator (VS 2005). I need a direct connection using connection string to SQL Server 2000 through local wireless network without IIS.

Bellow is the code that I use. After executing this code I get an error on line Conn.Open(). Error says SQL Server does not exist or access denied.
SQL is un and running, and I can log in using SA username from the desktop. Even if I chance IP for another SQL server in my connection string I still get the same error. There is no firewall of any kind running.


Dim connectionSTR As String = "Persist Security Info=False;Integrated Security=False;Server=192.168.0.202,1433;initial catalog=MyDB;user id=sa;password=;"

Dim Conn As SqlConnection

Conn = New SqlConnection(connectionSTR)

Conn.Open()


If Conn.State = ConnectionState.Open Then
MessageBox.Show("Open")
End If


About my environment: SQL Server 2000 is running on Desktop PC with Windows XP SP2. Application which I need to connect to SQL Server is in Visual Studio 2005. I execute the application in Windows Mobile PC Emulator and try to connect to SQL Server from emulator.

Your advice and help is very appreciated

Thank you

Ika


View 3 Replies View Related

SQLCe Errors When Doing Developing A SQL Mobile Application With Visual Studio 2005 And SQL Server 2005 Tutorial

Feb 26, 2008

I'm attempting to use RDA to synchronize a pocket pc emulator with SQL Server 2005 database by following tutorial http://msdn2.microsoft.com/en-us/library/aa454892.aspx, which uses AdvWorksMobile database that comes with SQL Server 2005.

When get to testing of "To test application features " ( step 4 of the merge replication setup lab ), I am receiving SQLCe Exception errors.

ORIGINALLY, I was able to deploy an application and view the local database on the emulator, but once I clicked "InitSinc" button, I received an error.

"Failure to connect to SQL Server with provided connection information. SQL Server does not" exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.
Found this error listed in Server Agent Errors log http://technet.microsoft.com/en-us/library/ms172357.aspx, but it wasn't very helpful since it doesn't provide any suggestions on fixing the problems.

I am brand new to SQL CE Server , mobile programming and .NET framework in general so please bare with me



All the connections / security settings, etc that were set up were taken from a tutorial so I am not sure what SQLCeServer is complaining about. Reading up on the error on the web didn't help, it all pointed to making sure that the snapshot folder had correct permissions set up. I verified that MACHINENAMEUISR_MACHINENAME guest user had Read rights to the database so I don't think that piece is the problem. Otherwise ,Merge publication has been setup in Microsoft SQL Server Management Studio by following the tutorial.


I am trying to run this sync on my home pc so there should be no issues with any user permissions


I have IIS installed


I did NOT have SQL Server Agent running in management studio at this time


I am trying to run this tutorial on an XP machine, which is my regular home PC so I dont think there are any special networking settings to consider


I am able to hit http://localhost/AdvWorksMobile/sqlcesa30.dll from my pc OK, but when I try to hit it from a cradled emulator ( after replacing "localhost" with "MACHINE_NAME" ), Internet Explorer on the emulator gives me a "Cannot Connect With Current Settings" error message. This part wasn't part of tutorial but decided so not sure if I am supposed to be able to hit it from my emulator..so I am not sure if the fact that I can't hit it is related to the problem.
AFTER STARTING SQL SERVER AGENTin Microsoft SQL Server Management Studio, I killed the application, and after relaunching it, it hits "The Specified table does not exist [Vendor]" error. This time it doesn't even launch first - that is I dont even get to pressing "InitSinc" button. Debugger is showing that this error is hit on the following line in AdvWorksMobile.AddWorksDataSetTableAdapters

int returnValue = this.Adapter.Fill(dataTable);

I am not sure why the errors changed on me after starting SQL Server Agent.
What can I do to fix this connection problem?

Thank you so much for your help!

Irina


View 3 Replies View Related

Difference Between SQL Mobile 2005 And SQL Compact 2005

May 24, 2007

Hello,

Could someone give me the difference between "Sql Mobile 2005" and "Sql Compact 2005".
At first I thought they were the same, that this was just something of the change in naming the server has had the last months.
My first guess was that Mobile would be the new one, but I have 'accidently' downloaded the Compact and what seems the System.data.SqlServerCE.dll is newer.

So is there a difference?
If yes, what are they.
If not, is the "compact" then the latest version and the name to be used (since on the site only "mobile" is mentioned).

Best regards,
Ike Casteleyn

View 6 Replies View Related

SQL Mobile 2005 Merge Replication With SQL 2005 X64

Jan 10, 2006

I am having trouble with getting Merge Replication up with a new SQL 2005 x64 Server.  I already have it running smoothly with SQL 2005 Mobile and SQL 2000, but I want to migrate the backend to SQL 2005.

There is a front end server running IIS 6.0 on Windows 2003 x86 Standard (Server A) with SSL required and Basic Authentication set as the only authentication method (default Domain and Realm are also set).  The backend server is running SQL 2005 x64 Standard on Windows 2003 x64 Standard (Server B).  The mobile devices are running Windows Mobile 5.0 with SQL 2005 Mobile (Client).

From both a standard Windows XP workstation (IE) and the Client (PIE) I can browse to the HTTPS site on port 444 for the sqlcesa30.dll on Server A and get a response in normal and ?diag modes.  The ?diag gives success in all but the 8.0 Database Reconciler (I didn't install the SQL 2000 replication components on Server A, my understanding is they should not be needed).  Sql Server Module Versions are as follows: sqloledb.dll - 2000.86.1830.0, 9.0 replrec.dll - 2005.90.1399.0, 9.0 replprov.dll - 2005.90.1399.0, 9.0 msgprox.dll - 2005.90.1399.0.

The publication on Server B is enabled for Web Synchronization and the Snapshop Agent has run.  There are no reported errors on that side.

Since I ran into issues getting synchronization to run I have opened up permissions fairly wide in this test environment.  The PAL and the Database both have the user I am attempting to sync with listed (I am using the Administrator account in the test domain).  I have opened full rights on the Snapshot share on Server B to Everyone (both NTFS ACL on the directory and the Share permissions).  The virtual directory on Server A containing the sqlcesa30.dll has also been opened very wide, and the Application Pool does have access to it.

The Client is running a custom C#.NET 2005 application.  With the exception of changes to set the application to sync with the Server A/B duo instead of the production servers, this application is identical to the code currently being used in production with SQL 2000 Standard.

The persistent error that I am getting from the Client being thrown by SQL 2005 Mobile when I attempt to sync is "An instance of the SQL Server Reconciler error object cannot be created.  Try reinstalling the replication components."

SQL 2005 Mobile components on Server A are set to Logging Level 3 but not returning any errors that I can see to troubleshoot with.  All replication components appear to be installed and operational, although I have re-installed them.

Besides the obvious question of how to solve the error listed above, is there an issue with am x85 front end IIS 6.0 server talking to an x64 back end SQL 2005 server for merge replication over HTTPS with Windows Mobile 5.0 clients running SQL 2005 Mobile?

Based on everything I have read off the MSDN Forums, MSDN articles, BOL, log files, and web searches it seems like I should have an operational synching topology, however clearly I have missed something because I have yet to get a successful subscription through to the publication.

Any insight/enlightenment would be greatly appreciated, this seems to be a very narrow and specific area of replication and mobility and information is relatively sparse from my experience so far.

Thanks!

 

 

View 5 Replies View Related

Xml To Sql 2005 Loading

Jun 19, 2007

Hi,

I'm dealing with loading xml data into sql 2005 relational tables

We are trying to do with C# class objects, what would be the better method to follow to load C# entity objects with xml data.



Xml has a complex 6 level heirarchy and with huge amounts of data.



please help.



-Thanks

Shiva

View 6 Replies View Related

SQL 2005 Mobile Vs .NET CF 2.0 SP1?

Sep 22, 2006

Hi. I'd like to try a hand at SQL 2005 Mobile.

I've installed sqlce30.ppc.wce5.armv4i.CAB on an HP iPaq 1950 Pocket PC, provided by the Microsoft SQL Server 2005 Mobile Edition Device SDK, http://www.microsoft.com/downloads/details.aspx?FamilyId=5BD8ABAA-5813-4DB3-B23A-24551DE2ECC1&displaylang=en

When I tried to interact with it, I got an error message that the .NET Compact Framework 2.0 was missing on the pocket PC.

So I installed the .NET CF v2.0 SP1 found at http://www.microsoft.com/downloads/details.aspx?familyid=0c1b0a88-59e2-4eba-a70e-4cd851c5fcc4&displaylang=en and it updated both the local machine and the Pocket PC.

However, now when I use my local SSMS to talk to the SQL Server Mobile Engine, I keep getting the error:

Microsoft SQL Server 2005 Mobile Edition and/or .NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding. (SQL Server Mobile Edition ADO.NET Data Provider)

(Now I know I can communicate with the Pocket PC because I browse out to it first)

Am I missing something more fundamental, or does this not work with a non-RTM framework?

View 1 Replies View Related

SQL CE 2.0 And SQL Mobile 2005

May 10, 2006

Hi,

I would like to know if we can install both versions of mobile SQL (SQL CE 2.0 and SQL Mobile 2005) on the same PDA. I know that two versions of CF .Net can be installed.

Indeed, I have an old CF .Net 1.3 application connecting to a SQL CE 2.0 database and a new one using CF 2.0 and SQL Mobile 2005. The first one will be migrated but in the future ... Meanwhile, the customer wants to run the two applications without any code modification.

Is it technically possible ? Is it recomended ?

Thanks in advance for your answers.

View 1 Replies View Related

Loading Huge XML To SQL Server 2005

Jan 13, 2008

Hi,
 I am using VS2003 and SQL Server 2005. I will get the huge size xml from the web service. I need to load this xml to sql server 2005 table as records.
I got below solution from microsoft site. Load XML to Dataset and from Dataset to SQL Server 2005.
Note   If you call ReadXml to load a very large file, you may encounter slow performance. To ensure best performance for ReadXml, on a large file, call the DataTable.BeginLoadData method for each table in the DataSet, then call ReadXml. Finally, call DataTable.EndLoadData for each table in the DataSet.
Any other better solution is there to load huge XML to SQL server 2005?

View 1 Replies View Related

Loading Data From Xml To Sql Server 2005

Aug 13, 2007

Please find the code below (which I am using).
1)
CREATE TABLE rssFeeds( feedXML XML)
SELECT * FROM RSSFEEDS
DECLARE @xmlDoc XML
SET @xmlDoc = ( SELECT * FROM OPENROWSET ( BULK 'C:Test.xml', SINGLE_CLOB ) AS xmlData)

2)
INSERT INTO rssFeeds (feedXML) VALUES (@xmlDoc)

I am able to get the contents of xml file into sql server in only one field of Table. Now I am asked to make one table with the schema same as xml file's. How to proceed? Pls let me know some URL for this.

Regards,
Ashish Johri

View 1 Replies View Related

Loading SAS Dataset Into Sql Server 2005

Apr 5, 2008



Hi,


This is an urgent task came up at our i.e. Loading SAS dataset files into Sql Server 2005.

We received the various files generated from SAS from other team. Now we have only .dat files and some .sas files.
Requirment is to load them into SQL server and generate some reports out of the database.
Does any one has done this task previously i.e. SAS dataset into SQL server?

There is any documentation or steps to be followed using SSIS, please adive.

Any help is great appericated.

Thank you
NMohan

View 9 Replies View Related

Connecting To SQL Mobile Within VS-2005

Jun 15, 2006

I am getting an error when I run my project within VS2005. I am
trying to connect to a SQL Mobile (sdf) file thru code using a
connection string. As soon as run my project within the VS2005
environment, I get the following error when the code tries to connect:



"The file is not a valid database file. An internal error has occurred. [,,,Databasename,,]"



The source of the error is: Microsoft SQL Server 2000 Windows CE Edition

Native Error of: 25011

I am am deploying to POcket PC 2003 SE Emulator.



This code worked fine in VS2003 with SQLCE 2.0. But I have now
updated the projects to VS2005 and recreated the database sdf file
within the VS2005 environment.



Could someone please help me ASAP?

Thanks.

View 1 Replies View Related

Installing SQL Mobile 2005

May 9, 2007

It is possible to install the .NET Compact Framework from the desktop with a .msi file.

However, SQL Mobile 2005 seems to require you to know the processor which your mobile device uses - there are only CAB files available to do the install.

Have Microsoft made an MSI file available to make this process easier?

matt.

View 1 Replies View Related

Migrating From 2005 To 2005 Mobile

May 4, 2006

Hello All,

I have a database created on SQL Server 2005 and now I would like to migrate the table structure to a SQL Server 2005 Mobile database. Generating the scripts and running them against the mobile database generates a lot of error that I suppose are caused by not supported features or keywords on the mobile engine.

I would like to know what are the best procedure for doing such migration. Note that this has nothing to do with replicating, since the SQL Server 2005 database will be "discontinued" after the migration.

Thanks in Advance,

Igor Kondrasovas

View 4 Replies View Related

Loading Data From .mdb File Into Sql Server 2005

Aug 15, 2007

I am so new to SQL Server 2005 and just studying.  Saying that...
We use SQL Server 2005 Express edition.  Some one sent me a file (info.mdb) and asked me to load the data in this file in to a table called Products and also asked me to load in another table (ProdCat) where id = 'X05'.
So being not knowing anyting regarding data loading etc, how should I do this and proceed?  The .mdb means its a Access database file?  If that is the case, I dont have Access in my machine and what should I do?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved