How to make a local database

[amiga500]

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.

 

[Paul G. Tobey [eMVP]]

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.

 

[amiga500]

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?

 

[Paul G. Tobey [eMVP]]

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]

Your previous message says I should use SQLCeEngine and use SQLServerCE
on the actual PocketPC. I don't know how to do either of them. Please,
do you know a tutorial link where it teaches the person how to use
SQLCeEngine and how to setup SQLServeCE on the pocketPC? Thanks in
advance.

 

[Guest]

I just did a Google search for "sql mobile tutorial" and the #1 response
looks very, very good.


--
Chris Tacke
OpenNETCF Consulting
Managed Code in the Embedded World
www.opennetcf.com
--

Your previous message says I should use SQLCeEngine and use SQLServerCE
on the actual PocketPC. I don't know how to do either of them. Please,
do you know a tutorial link where it teaches the person how to use
SQLCeEngine and how to setup SQLServeCE on the pocketPC? Thanks in
advance.

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.

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.

messagenews:[email protected]...

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.

 

[Ginny Caughey [MVP]]

You can use SQL Server Management Studio (but not the version that comes
with SQL Express) or Visual Studio 2005 to create SQL Mobile databases. You
can also create them programmatically as Paul suggested.

 

[Paul G. Tobey [eMVP]]

SQLCeEngine is a class which 5 seconds worth of work in the help on your end
would have found. It has methods for creating new databases.

Paul T.

Your previous message says I should use SQLCeEngine and use SQLServerCE
on the actual PocketPC. I don't know how to do either of them. Please,
do you know a tutorial link where it teaches the person how to use
SQLCeEngine and how to setup SQLServeCE on the pocketPC? Thanks in
advance.

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.

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.

messagenews:[email protected]...

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.

 

[amiga500]

I thank you all for your very fast reply, patience and understanding. I
have solved my problem thanks to you guys. Appreciate it big time. I
sometimes think you guys should be paid for this ^_^

SQLCeEngine is a class which 5 seconds worth of work in the help on your end
would have found. It has methods for creating new databases.

Paul T.

Your previous message says I should use SQLCeEngine and use SQLServerCE
on the actual PocketPC. I don't know how to do either of them. Please,
do you know a tutorial link where it teaches the person how to use
SQLCeEngine and how to setup SQLServeCE on the pocketPC? Thanks in
advance.

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.
message
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.
message
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.