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
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
Can I synch between a Mobile device using SqlServer Compact and desktop PC running Sql Server Express using Microsoft Synchronization Services?
View 1 Replies View RelatedI want to create an application for home users which runs on their mobile device (smartphone) and their desktop PC and keeps the data synchronized between them. On their desktop I want to run either SSCE or SSExpress. There are so many options in the SSCE literature, which options should I use? How do I synchronize the data?
The literature has so many options I don't know where to start.
I have searched through this forum and the news group
microsoft.public.sqlserver.ce
for this topic. I only find a post from Darren Shaffer and I requested a document.
Unfortunately, there is not a clear example of how to create a mobile database (sdf) on a desktop machine which contains VS 2005 and SQL server 2005 by using Visual Basic 2005.
I am sure a clear example in VB for this problem would help a lot of people. Hence anybody who knows how to perform this task, Please help these people.
Thanks in advance
Talat
We have a product which uses a SQL Mobile Database under Windows CE 5.0. I would like to be able to change the database structure, i.e. add tables, change table structure , etc. On a copy of the database on my PC and them move the restructured database back to a device. I can access the database from Visual Studio 2005. I can edit tables, add tables, but I can't change the name of a column. Does anyone have a solution?
View 4 Replies View RelatedI want to physically move my .SDF file to my desktop and then access this file from VS 2005 VB.NET. Ideally, I would want to access this .SDF file from MS Access 2003 but I undersand this is not possible.
Here are my VS 2005 VB.NET statements....
Dim ConnPPC As New System.Data.SqlClient.SqlConnection("Data Source = C:Documents and SettingsG014436My DocumentsSQL
MobileActMgr6CE.sdf")
Dim mySqlDataAdapter2 As New SqlDataAdapter("select * from T0002_AE_Activity_Entry", ConnPPC)
mySqlDataAdapter2.Fill(myDataSet2)
On executing the last statement(fill)...I get the following error.
function failed: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Does anyone have any suggestions?
I have been able to use MS Sync Services to sync an MDF file & an SDF file (Works great! Very easy!).
What I would like to know is if I could sync an SDF file with another SDF file (making an SDF file a desktop DB and the other a Mobile DB)?
Thanks,
V
VS 2008
SQL 2005 Express
Has anyone had trouble accessing SQL 2000 desktop install over the LAN on SBS 2003?
I cannot access my installation from the same domain, yet when I install it on a machine running something other than SBS 2003 there are no problems.
Everything seems shared correctly, and I have tried loggin on to the remote machine as Administrator with no success.
Any suggestions would be appreciated.
Hi,
I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied." Any ideas? Thanks a lot.
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Imports System.Math
Imports System.Drawing
Imports System
Public Class Form1
Dim strConnection As String = "Server=localhost;Integrated Security=SSPI;database=AdventureWorks"
Dim strQuery As String
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Label1.Text = "Hello, Clicking after."
ReadOrderData()
End Sub
Private Sub ReadOrderData()
Dim queryString As String = "select * from Person.Address where AddressID < '10'"
Using connection As New SqlConnection(strConnection)
Dim command As New SqlCommand(queryString, connection)
connection.Open()
Dim reader As SqlDataReader = command.ExecuteReader()
While reader.Read()
MsgBox(String.Format("{0}, {1}", _
reader(0), reader(1)))
End While
reader.Close()
End Using
End Sub
End Class
Hello Everybody
I want to create SQL server 2005 mobile database on desktop programmatically with some inital data for my application and load it into device. We can create database only in VS2005 server explorer or SQL server 2005 application.
Anybody having this solution for this prob.
Regards
Chikuu
Howdy,
Am trying to find a way to insert/update/delete data in a SQL mobile database on a Windows CE 5.0 device FROM a desktop PC.
This situation is completely stand alone, no network (apart form device/desktop), no GPRS etc etc etc.
I've looked at RDA but i dont believe it fits my app. (pulling data from a 2005 server that doesnt exist doesnt really help me much, push can't be used without a pull which kills the idea.)
The goal is a UI on the desktop that can manipulate data in the SQL mobile Database.
I've tried all i can find/think off in relation to this but to no avail.
My latest attempt has been using the simplest method possible (using a VS wizard datasource to the devices DB and tryign to whack that on a form) but this just creates a "Path not found. Check the directory for the database [Path = Mobile Device/ce_swipe/TestDB.sdf".
Hi All:
I need one clarification. Can i use sql server Mobile 2005 and vs 2003 (.NetCF 1.0) for my application.
Thanks
Vamsi
Does SQL Server 2000 CE 2.0 work on Windows Mobile 2003?
Thank you,
Ken Carlino
ServiceMaster
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
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.
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.
Dear All,
i have a question abt winCE 4.2 and SQL server CE.
i am using VB.net of Visual Studio 2005
My platform is using a PDA with winCE 4.2 and SQL server CE. The Host program is using dbf files on desktop side.
I got a problem of how to sync / read the sql CE data from a windows application.
so, i wanna ask,
1. any method to access the data from winCE data by windows application? or can i convert the sdf file to windows readable files? or any others?
2. Can i use a MDB to sync with SQL server CE?
can i synchronize the mobile device which has a SQL Server CE database with the Access database on the desktop?
last question,
3. is that windows CE .net 4.2 not support pocket access (cdb) anymore?
please help me out
Long story short -
Have two C# applications - one WinForms desktop app, the other a WinForms smart device app. Both use SQL Server Compact CE 3.5 to store data locally. Both work just fine.
Now the desktop app needs to open and update the .SDF file that is stored on the Windows Mobile device. (Device will be docked via USB.)
What format would the path to the .SDF look like that the WinForms application would need to specify in order to open it?
Thanks for reading.
Hi,
I am developing a windows application that needs to communicate with a remote SQL server 2005 database. Server allows remote connections and MSDTC service also running. Do I need to run MSDTC service on the client machine where I use desktop application ? any ideas ? It's throwing some error like
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact
that under the default settings SQL Server does not allow remote connections.
But my SQL Server allows remote connection, and I am able to do a select statement.
But when I insert/update anything, it's throwing this error. I guess some problem with MSDCT. Anybody have any idea ?
This code...
string Path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
// Create the connection fConnection = new SqlCeConnection("Data Source ="" + Path + "\TreeNotes.sdf" ;Password ="abcd1234";");
fConnection.Open();
...works on my device, but on my computer it gives SqlCeException with message:
The database file cannot be found. Check the path to the database. [ File name = Program FilesTreeNotesTreeNotes.sdf ]
I've tried all sorts of things, but the computer just can't find the database. I've even tried putting a copy of the database into...
C:Program FilesTreeNotesTreeNotes.sdf...hoping that the computer will find it there.
What am I missing?
I'm planning a Pocket PC / Windows Mobile application, but I'm a bit confused on which mobile database I should start development with. I've read about SQL CE, SQL Everywhere, and SQL Mobile. Should I be using SQL Server CE 3.1 for my Pocket PC application? The database will be preloaded with data at design time with read-only information, and will be a "private" installation for a single user application.
My main concern is that the solution can be installed on PPC 2002, 2003 and Mobile 2005.
Am I on the right track?
Thanks,
Jordan
i installed the MSDE2000A on server and i tried to connect from client machine through vb Application using connection string. Server anad client are in LAN. but Some systems able to connect and some systems are unable to connect.
i am getting the error:
"SqlServer does not exist or access denied "
for non connected machines.
the server is listening from these machines. but not connecting to MSDE.
can anyone give me solution what may be the cause.
Hello
I want to merge replicate my mdf to two PocketPCs running Windows Mobile 5.0/SQL Server Mobile and PocketPC 2003 SE/SQL Server CE 2.0. I've got SQL Server 2000 installed on a Windows Server 2003 machine. I've followed this guide: http://www.codeproject.com/database/MergeReplication.asp, but now I don't know how to add SQL Server Mobile/CE to the list of subscribers after creating the publication. I'm really lost. Does anyone know of an easy step by step guide.
Thanks!
Rudi
Hi there,I sincerely hope that someone out there can help. I have twoinstances of the SQL 2000 Desktop Engine running. One is on my localmachine for development and the other is on another machine on ournetwork which is the production environment. I have built an Access2003 front end application which connects to this database. Thisworks fine locally, as you would expect. I successfully installed thedatabase on the production machine and am able to connect to it viaAccess 2003 (using the Data Link Properties window) and from thirdparty database manager software (similar to Enterprise Manager). I amnot able to to connect to the database via my application.I am using the "sa" account with a strong password. This is myconnection string:strConnection = "Provider=sqloledb;DataSource=server02;UserId=sa;Password=strong;Initial Catalog=Test"The error I'm getting is:"Connection cannot be used to perform this operation. It is eitherclosed or invalid in this context."The connection string is the only thing that changes in my code when Iswitch from my local to my production database. Is there some reasonthat I can't use the "sa" account in this fashion that I'm not awareof? I'd rather not use integrated security for simplicity's sake asthis is a small, internal application. Also, I would have thoughtthat if that was the issue, I couldn't use "sa" at all, even locally.I'm going to post to the Access group as well but thought someone heremight have some advice to offer as well.Thanks,Barb
View 2 Replies View Related
HI,
i have one instalation file of SQL CE 2.0 named setup.exe ,i installed that in my desktop it works well.i could not install the same file inside the pocketPC.Can any one give me some information about how to get the installation file of SQL CE 2.0 and how to install that in real pocketPC.Thanks in advance.
Best Regards
Ihsan
How I can conect to SQL server mobile database using visual fox pro 9.0.
Is there ODBC driver for SQL server mobile?
Hi all!!
As I said in a previous post, I am replicating information from SQL Server 2000 to SQL Mobile in my iPaq.
The test scenario was that I connect my iPaq to my laptop with Active Sync and to the server via LAN. This is working just fine.
My problem is that I need to replicate information from home to the server, but with a modem connection. I have my user and password, and if I access the mobile agent URL from the laptop via modem, it works fine (http://server/SqlMobile/sqlcesa30.dll), but I can't access from my iPaq.
Is there any additional config to the server or the iPaq that needs to be done so I can see the Mobile Agent?
Thanks in advance!
Jerry
Hello,
I try to connect the SQL Server from the mobile device.
my connection string is:
string conn_str = "Server= 10.0.0.11;Database=theDB005;uid=bahadir;pwd=abcd;Trusted_Connection=false;";
when i try to open the connection I get SqlException,altough the 10.0.0.11 machine is reachable.. is not allowed to access a remote sql server with ip?
Thanks in advance.
Hi,
I'm writing a windows application using VB.NET 2005 that must connect to Pocket PC via ActiveSync to read data from SQL Server CE. This is my code:
Dim cnn As New SqlCeConnection
cnn.ConnectionString = "Data Source =Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf"
cnn.Open()
But I get the following error:
The path is not valid. Check the directory for the database. [ Path = Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf ]
Any help would be greatly appreciated!
Leila
I have a working Pocket PC 2003 app that uses RDA to exchange data with SQL Server 2000. I'm attempting to port it to a Windows CE 5.0 device. (I'll be porting to Mobile 5 in the near future, but the gadget I have at the moment is CE).
I installed SQL Server 2005 Mobile Edition on the computer running IIS according to package directions, and used the wizard to set up a virtual directory with sscesa30.dll.
The directory I was previously using with sscesa20.dll is still there, and still works.
I set up the virtual directory to use basic authentication without SSL. (I know that's not advisable). I have confirmed that I can reach the URL using the username and password I supplied to the wizard.
When I try to pull data I get the following:
------------------- SQL CE Exception
Error Code: 80004005
Message : An error has occurred on the computer running IIS. Try restarting the IIS server.
Minor Err.: 28022
Source : Microsoft SQL Server 2005 Mobile Edition
I have tried restarting IIS without effect. Any clues?
I'm seeking suggestions on how to go about encrypting a database connection string in the compact framework. It's something that I thought would be relatively straight forward as I've accomplished it without much difficulty in the full framework, but I'm stuggling to find a solution.
I've been trying to implement a solution using public/private key asymmetric encryption using the RSA provider. I've essentially been trying to encrypt the connection string once on my development machine so that I can include both the encrypted connection string value and public key in either code or an external file. I'd then keep the private key out of harms reach. The problem I've encountered in doing this is that that RSA provider seemingly only allows new "in session" keys to be generated and I can't figure out a way of importing a public key from a file or other similar means.
I found the following code which is meant to allow a key to be retrieved from a signed assembly or an SNK file, which I've converted to VB but haven't been able to get working:
http://www.topxml.com/-NET-XML-System-XML/re-2963_Get-RSA-Public-key-from-Assembly-or-SNK-File.aspx
After the code seems to successfully prepare the CspParameters from an SNK files, I get an unspecified error when executing ImportParameters on the RSA provider.
I'd imagine this to be a common requirement, but haven't been able to find much information specific to the compact framework on the web. Any guidance would be much appreciated.
Thanks,
Steve
Hi, everyone! I have a small problem.
It consists in:
1. I'm trying to connect to database on my Pocket PC within Visual Studio 2005 (C#)
Connection string looks like this:
SqlCeConnection1.ConnectionString = "data source = '\storage card\mobiluser.sdf'";
But when i'm deploying it to Pocket PC the error "An error message cannot be displayed because an optional resource assembly containing it cannot be found" appears.
2. When I'm doing te same on Pocket PC Emulator everything is normal.
Off course, I have the .sdf file on Pocket PC which is placed to Storage Card into root directory.
If anyone knows where I get a mistake, help me please!
Thanks for your help!