i am developping a little app that retrieves an XML file, located on a remote server (http://xxxx.com/myfile.xml) This file is relatively big, and it contains a big list of geolocations with other informations that i need to use for my app. So i read this file remotely once and insert it into a little SqlCE file (database.sdf) So If I n...
I have this sql ce database which I would like to convert to SQL 2008 because I want it to be accessible through the network. I am using SQL 2008 express; and VB9. Any idea? ...
I started using a Sql Compact version of my DB and during the development it occured that the DB needs to be accessible over the network. Cause I wasn't able to find a way to share the SDF file over net without replication I need to import it into SQL Server 2008 (Express). Any Ideas? ...
Here at work we want to access the data inside a .sdf file generated in a PDA with SQLServer Mobile Edition. We use the SqlJDBC4 packet for JDBC but can't get into the server. We know it's running because we can telnet into it, but from the Java code we just get once and again that we can't connect to server. We use this connection Stri...
My database must be updated at arbitrary intervals, manually, with new info to put on standart tables that don't require structural modifications. one app will update the database. Another app, the one I will distribute (to friends and family only, but doesn't require any security feature to it, like encrypting the database) will read th...
When I try adding a new data source to my project I get a prompt saying "The connection you selected uses a local data file that is not part of the current project. Would you like to copy the file to your project and modify the connection?" This sounds rather obscure to me, as I'm new to VB.NET and programming non-script apps in general...
What do I need to open sdf database in Visual Studio's 2008 server explorer? I've installed Microsoft SQL Server Compact Edition 3.5 but Visual Studio seems to be unaffected by that installation. ...
I have 4 SQL Server 2005 db's that I want to move to SQL CE. I know I cannot keep the SProcs,Views, and Functions(Differences Between SQL Server Compact and SQL Server) but I would like to keep everything else. I have tried this app, SQL Server to SQL Server Compact Edition Database Copy but it errors out on me. I have the source and ...
We have an Office Addin that uses Sql CE with the usual DBConnection to a *.sdf in the filesystem ('C:/...etc...'). When we start two copies of the application having the Sql CE-augmented Office Addin (testing what a user might do by mistake) the Sql CE database becomes corrupted and the Office Addin can no longer access its data. It...
Hi, i'm using NHibernate with Sdf database. In my hibernate.cfg.xml file i've set: <property name="hbm2ddl.auto" value="update"/> But this does not seem to work at all. "Update" attribute should make NHibernate generate missing tables and columns during application launch, but it does not happen. If i want missing tables geenrated I...
I need to generate a SQL update command in a *.sdf file. The *.sdf file is deployed using Visual studio. I am looking to generate a script which fills in a table the maximum number of records which is about 2MBytes. any ideas for how I can do this i.e. connect remotely to the database and script filling in the database with a dummy rec...
C# WinForms .Net 3.5 to SQL CE 3.5 on Mobile 6.1 Device I'd like to make a connection from a desktop application to a SDF database on my Windows Mobile device while it's connected via ActiveSync. Visual Studio lets me create a Data Connection to my device. The connections tests OK and I can view the data in the database using Visual S...
Hi, I'm trying to insert a local database cache template to a Visual Studio web application, but the template is not available. If i create a Winodws forms application, the template is available. How can i add this to the web application? I need to create an sdf of my database. thanks ...
I have a SDF file (compact framework dbase) only for reading... Is any way to embed as RESOURCE ??? and read it directly from EXE, without extract it!?????? ...
I see in some of the SL literature that SL4 (and possibly older versions) allow for file access on the local machine. Would it be possible, then, to install SQL Server Compact on the client machine, and have an SDF file that the Silverlight app could read? Or I guess, rather, have the Silverlight app talk to a .Net DLL that's reading...
I need a tool that show me the differences between two .sdf files. Is there something I can download or do I have to write some code? ...
I am developing an application for Windows Mobile 6 using an emulator. When I try to open the database connection to the SDF file it is throwing an exception that it is not able to connect or find the file. My questions are: Where on the mobile device is the SDF file supposed to be deployed? Does the SDF file get automatically deploy...
I have created a sdf database in a mobile application. Now I want to synchronize that database to a sql server database. How it is possible? Please help......... ...
HI, I am trying to save some data to my .sdf file using a LinqToSql object. I have a table as follows - PersonId int not null pk forename nvarchar(4000) surname nvarchar(4000) Birthdate DateTime IsMale bit Biography nvarchar(4000) I am inserting a value into all fields apart from the PersonId column (set to identity, increment). I a...
I am trying to learn how to bind my simple database (.sdf) to a combobox. I created a dataset with my tables in it. I then dragged a table from the DataSource onto my control. There are no build warnings/errors, and when it runs, the ComboBox is empty. <UserControl x:Class="OurFamilyFinances.TabItems.TransactionTab" xmlns="http...