Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server CE / July 2008

Tip: Looking for answers? Try searching our database.

Getting and Installing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jp2msft - 17 Jul 2008 17:01 GMT
I am a Software Developer, and I love the idea of using SQL Server CE instead
of Microsoft Access; however, I seem to run into the problem of not being
able to find the place to download it from! Is it contained in a single file?
Is it SQL Server CE or 2005 Mobile? I found the Modile Edition SDK, but does
this include SQL CE?

Next comes the question of how to install it: We have SQL Server 2000 and
SQL Server 2005 here at work, and they require an Administrator to install
them because it is rather complicated. Is there a place that summarized how
to install SQL CE (after I find it)?

Once I've got an app running that uses SQL CE, is anything special required
to install that app on someone's machine that does not already have SQL CE
installed? This process was very simple using MS Access, but I want to find
out how to do it using SQL CE.

Thanks.
Paul G. Tobey [eMVP] - 17 Jul 2008 17:07 GMT
www.microsoft.com/downloads.  Search on "SQL Compact 3.5".  The first two
items are the ones that you'd want, one for the PCs and one for Windows
Mobile/Windows CE devices.

I don't quite follow the install question.  You can install it on a Windows
CE-based device, like your Pocket PC.  To do that, you generally install it
on the PC that connects to the device with ActiveSync or Windows Mobile
Device Center (if you have Vista).  The next time you connect the device,
the right stuff will be downloaded to it and installed.  You can also
install it on your PC for use on the PC (a separate install).  When you do
that, it's just available for us; there's no service that runs it; it's
simply connected to your program code that uses it.

I suppose that you could either include the pieces in the install for your
application or include the whole installation package and fork off to it
from your application's installer.

Paul T.

>I am a Software Developer, and I love the idea of using SQL Server CE
>instead
[quoted text clipped - 19 lines]
>
> Thanks.
jp2msft - 17 Jul 2008 17:31 GMT
Hi Mr. Tobey,

Thanks for the links!

As for installs, I'm looking to get away from MS Access for our WinForms,
but we don't want an IT guy to have to install SQLCE every time someone wants
to install one of our small apps.

Are there just a few files that could be included? It looks like SQLServerCE
3.1 is small (1,777 KB) and I could attach this to the Setup file, but then
our uses would be left to run the SQL setup on their own.

Our uses typically don't want to mess with databases - that's why they come
to us in the first place! :)

> www.microsoft.com/downloads.  Search on "SQL Compact 3.5".  The first two
> items are the ones that you'd want, one for the PCs and one for Windows
[quoted text clipped - 38 lines]
> >
> > Thanks.
Paul G. Tobey [eMVP] - 17 Jul 2008 17:40 GMT
You're using it in a way that's not what I do.  I'm a Windows CE guy.  We
build devices, not desktop applications.

That said, SQLServerCE 3.1 is not for your desktop computer; it's strictly
for Windows CE-based devices, and won't do anything for you as far as
replacing Access as the database in your desktop Windows programs.  SQL
Compact 3.5 has two versions, as I said, one for Windows CE devices, and a
compatible one for desktop Windows devices.  As Ginny said, you just need
the DLLs put in some suitable location; there is no service, just calls from
your program that create, add to, remove from, and query a database file.

Paul T.

> Hi Mr. Tobey,
>
[quoted text clipped - 65 lines]
>> >
>> > Thanks.
Ginny Caughey MVP - 17 Jul 2008 17:13 GMT
You don't even have to "install" SQL Compact (the current product name) if
you don't want to. All that's really required is copying the DLLs you need
if you want to involve a formal installation required admin rights:
http://msdn.microsoft.com/en-us/library/aa983326.aspx

You can download it here:
http://www.microsoft.com/sql/editions/compact/downloads.mspx

---

Ginny Caughey
Device Application Development MVP

>I am a Software Developer, and I love the idea of using SQL Server CE
>instead
[quoted text clipped - 19 lines]
>
> Thanks.
jp2msft - 17 Jul 2008 17:34 GMT
Thanks Ms. Caughey. I do appreciate it! That was what I was looking for. :)

> You don't even have to "install" SQL Compact (the current product name) if
> you don't want to. All that's really required is copying the DLLs you need
[quoted text clipped - 32 lines]
> >
> > Thanks.
William Vaughn (MVP) - 17 Jul 2008 17:34 GMT
I expect that you would benefit from my EBook "Hitchhiker's Guide to SQL
Server 2005 Compact Edition". See www.hitchhikerguides.net FMI.

> I am a Software Developer, and I love the idea of using SQL Server CE
> instead
[quoted text clipped - 19 lines]
>
> Thanks.

Signature

__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205  (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________

jp2msft - 17 Jul 2008 18:26 GMT
I bought your book some time ago.

In short, it takes too long to read through it before I can find anything out.

How about writing a summary book?

Tell you what: How about dropping all the acronyms (like AFAIK, HTH, LOL).
It just isn't what I want in  a professional book. The ones listed I know,
but there are others I don't.

I didn't like your book.

> I expect that you would benefit from my EBook "Hitchhiker's Guide to SQL
> Server 2005 Compact Edition". See www.hitchhikerguides.net FMI.
[quoted text clipped - 22 lines]
> >
> > Thanks.
Martin - 19 Jul 2008 09:20 GMT
Hmmmm nice response to people who are reaching out trying to help you

>I bought your book some time ago.
>
[quoted text clipped - 39 lines]
>> >
>> > Thanks.
jp2msft - 20 Jul 2008 15:16 GMT
Martin:

Mr. Vaughn did nothing to help. He only stated "buy my book."

For what it's worth, I have had several times that Mr. Vaughn has responded
with this comment alone. After a while, I bit the bullet and bought his $70
book, and it has done nothing to answer any of my questions.

Still, every time I post a question about using SQL, he gives this generic
answer without answering anything.

Personally, I don't see where he is trying to help. It looks to me like he
is using this forum as free advertisement for his book. Since this is a
thread that I started, I feel justified in posting my personal feelings about
his book.

> Hmmmm nice response to people who are reaching out trying to help you
Paul G. Tobey [eMVP] - 21 Jul 2008 16:50 GMT
There's "reasonable" and there's "productive" and, in this case, I think
you'll find that posting what was a reasonable review of the book will
probably prevent you from actually getting any help.  It's like speaking up
in a class to say that, "Professor, your area of research is stupid."  It
might *be* stupid, but it's not a great idea, if you need help with your
homework, to annoy the person who can, presumably, provide the help.  In
this case, who would want to jump in and try to help you, if your response
is likely to be "Hey, that's a dumb idea!"?

Remember that *everyone* here is a volunteer; no one is paid to provide this
support.  Some of us do this while long compiles are running or while some
automated test is running in our real job, while others make their living
providing consulting services or maybe even writing books or running Web
sites.  I think it's perfectly reasonable, if someone has a book and if they
think that the answer to a given question is in there, to post a pointer to
it.

Paul T.

> Martin:
>
[quoted text clipped - 16 lines]
>
>> Hmmmm nice response to people who are reaching out trying to help you
William Vaughn (MVP) - 21 Jul 2008 17:49 GMT
I say "The answer is in the book" when I think the answer is in the book.
Sometimes I'm wrong. Sometimes the reader does not agree with the approach
or does not take the time to read past the index before making a judgment.
My books (all 12 of them) are written based on questions I get in class, in
sessions, from my customers and from these newsgroups. The last (paper) book
I wrote took almost three years to write--time I could have used elsewhere.
These books pay about $2 each in royalties and last about 18 months on the
shelf before being dubbed as obsolete. If you think a technical author
suggesting you buy his or her book to make a JK Rowlings fortune, you're
sadly mistaken.  If you look at my reviews (and discount the reviews where
the reader did not like my humor) a number of them said they were not only
helpful but a significant contribution to forwarding their career--they do a
lot less to forward mine.

I don't write these books as a full-time job or to get rich but because I
want to help developers. No, they won't help everyone because the books are
all focused on one narrow aspect of the technology. If your problem is
outside that range, no, they might not help. However, if you're missing the
fundamentals (as is sometimes the case here) all too often only books or
formal courses will help get your skills up to speed. This way you will be
able to understand the more complex aspects of the technology--or even some
of the simple points.

As Mr. Tobey said, I, like many others here on these newsgroups and forums
volunteer our time (what's left of it) and only suggest our books, blogs and
other publications when we think we have answered the question in great
detail in our books or when the DVD that comes with the books have a
pertinent example. We also do this because we don't want to waste our time
answering the same question for the thousandth time or don't have the time
to provide the four hours of fundamentals training some questioners clearly
need. You might be a world-class expert on your subject and need a fine
point clarified. You might be a rank beginner and not know a COM object from
a RJ11 plug or your skills might be somewhere in between. That said, without
a bit more tact and courtesy to those who are simply trying to help, you
won't get very far. Don't bother replying. I have blacklisted your name as
you clearly don't need my help.

__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205  (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
Martin - 24 Jul 2008 09:55 GMT
I know you guys are volunteers, I have received valuable answers to
questions I had, and when I was stuck, on a number of occaisions and I am
very grateful for that.

>I say "The answer is in the book" when I think the answer is in the book.
>Sometimes I'm wrong. Sometimes the reader does not agree with the approach
[quoted text clipped - 41 lines]
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> ____________________________________________________________________________________________
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.