Re: How to make a local database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have no idea how SQL Enterprise manager for windows works. You create new
databases by following my instructions from the previous message...

Paul T.

<amiga500@xxxxxxxxx> wrote in message
news:1165341326.871185.203260@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
But how do you make your own .sdf file though? Is SQLServeCE similiar
to the SQL Enterprise manager for windows, but it is local and for
pocketPC, allowing one full power to make their own tables?

On Dec 5, 12:46 pm, "Paul G. Tobey [eMVP]" <p space tobey no spam AT no
instrument no spam DOT com> wrote:
Look at the classes in System.Data.SQLServerCE. To create a new
database,
look at SqlCeEngine. The other classes are pretty self-explanatory when
used in combination with the help. Obviously, SQLServerCE has to be on
the
device...

Paul T.

<amiga...@xxxxxxxxx> wrote in
messagenews:1165339245.612816.62130@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hello,

I am sorry about the earlier question I guess I did not reword it
correctly. I want to make a local database in my pockPC where I can
read and write to the tables locally in my PocketPC. I know the
SQLComand, SQLConnection, etc are not for local databases they are
designed to access the SQL Server, I also know the SQLCe is designed
for mobile hand held communication and website/server communication.
Does anyone know a link for a tutorial, etc that will teach me how to
make/access a local server in my pocketPC so I can add data into the
local table, update data into the local table, etc? Thanks in advance.
My boss (manager) tells me that the whole reason they made SQLCe is for
that purpose, if so, is there a tutorial to teach me to make a local
SQL server. I also don't know how to make .sdf file? Where would I be
able to do that? Thanks in advance.



.

Relevant Pages

  • Re: Dllhost.exe Memory leaks
    ... Good for Paul. ... If you are finding your IIS server crashing out of the blue and are ... your Access Databases if the sites that are going off line without notice. ... "doug" wrote in message ...
    (microsoft.public.inetserver.iis)
  • Re: Undo Access Runtime???
    ... instructions on the screen to complete the installation". ... I had no instructions at all but all my databases (still "under ... construction") were adapted so now I maybe have a version on my ...
    (microsoft.public.access.setupconfig)
  • Re: How to make a local database
    ... It has methods for creating new databases. ... Paul T. ... SQLCeEngine and how to setup SQLServeCE on the pocketPC? ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: How do you add user tips on documents and databases?
    ... >> Word to these databases. ... >> instructions be inserted somehow into the Access ... >follow question or reply in the newsgroup and not by e- ...
    (microsoft.public.word.docmanagement)
  • Re: How do you add user tips on documents and databases?
    ... on Monday setting up the databases to have tips based on ... >would need to be done in the Access form. ... >approach is to format instructions in a color, ... >follow question or reply in the newsgroup and not by e- ...
    (microsoft.public.word.docmanagement)