Can u tell me how can we connect to sql server mobile database that resides on the mobile

Posted Date: 13 Jul 2009 Posted By: sumesh.v.k Member Level: Silver Points: 1 Responses: 2

hi

i created one pocket pc application to save data into database.the data is successfully saved in the sql server mobile database that resides on the mobile device.

now i want to retrieve the records stored on the mobile device in windows application.i connected the mobile device to my pc.

i used the following connection string to connect to sql server mobile database from windows application.

con = New SqlCeConnection("Data Source=\Program Files\InventoryTransactionSystem\DB_Inventory.sdf")
con.Open()

but it shows the following error message

The path is not valid. Check the directory for the database. [ Path = \Program Files\InventoryTransactionSystem\DB_Inventory.sdf ]

can u tell me how can we connect to sql server mobile database that resides on the mobile duvice from a windows application?

Responses

Author: Malleswar 14 Jul 2009

Member Level: Gold

Rating:

Points: 2

Hi Sumesh,

May I know your application requirement? Becuase this is not the general way to update the data to main database from mobile database.

Either you can Merge replication or webservice to update your main database.

Step by Step: Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005 (Merge replication)

http://msdn.microsoft.com/en-us/library/aa454892.aspx

Regards,
Malleswar

Author: sumesh.v.k 15 Jul 2009

Member Level: Silver

Rating:

Points: 2

thanks

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : Sharepoint document library in mobile web application
	Previous : Uploading image in mobile app
	Return to Discussion Forum
	Post New Message
	Category: Smart Devices

Related Messages

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use