SQL CE basics

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi All,

I am not new to SQL and using SQL queries, however I am new to Windows CE and using SQLCE 3.5. I have so far managed to install it and I can add it to my operating system using platform builder and the component catalog.

I have read a few things in the online books but nothing really provides any clear examples with native win32 code. I'm struggling to find sources that explain:

1. Can I just copy an .sdf file to the device? Or is it .mdf? Or do I create one on the fly from my program.
2. Opening/closing a database.
3. Reading/writing queries to the database.

I tried including:

#include <sqlce_oledb.h>
#include <sqlce_err.h>

but compile complains that it cannot find sqlce_oledb.h. Not sure what I have to do to get the compiler to find the .h file.


Basically I'm just looking for a "getting started" guide for SQL CE 3.5 and native Win32 programming.

I actually intend to access the database from real-time programs, but I need around 10000 data points so someone suggested using SQL CE instead of CEDB or EDB. Does that sound suitable or not?

All I really need to store is 10000 booleans and 10000 ints, maybe I should just use an array? But the problem is it may be accessed by multiple processes at the same time...and it needs to survive a power cycle. I guess I could routinely write everything to a simple txt file.

I'm very new to Windows native so bit of a steep learning curve there. Not sure what the "preferred" way of doing things is.


Thanks
.

Relevant Pages

  • File Ownership failing for Domain Accounts
    ... I am having a consistent problem on several instances of SQL 2005 setting ... the ownership of database files to a windows user. ... Right-click on any user database, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL web application fails at login. Need help.
    ... >to open a connection to the database, ... >SQL authentication). ... >>from console and windows applications. ... >>and windows applications can run the SQL tables. ...
    (microsoft.public.sqlserver.programming)
  • Re: Ecrypting a database
    ... Windows comes with a native file/folder encryption, ... account would need access to the database to unencrypt the ... >> I have a SQL database which will only be accessed only ...
    (microsoft.public.sqlserver.security)
  • Re: Sql Server Login
    ... firstly I was under the impression SQL authenticaiton will be better ... But now I know windows authentication is recommended. ... Now my application is ready and talking to this database in MSDE. ...
    (microsoft.public.sqlserver.msde)
  • Announcement - GMP SQL Query 2005
    ... inc. has released a lightweight SQL ... Query tool that works with any database or flat file that can be accessed ... via UDL and a data provider. ... Windows 2000 Server ...
    (microsoft.public.sqlserver.tools)