SQL Server Forum / DB Engine / SQL Server CE / July 2008
Getting and Installing
|
|
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) > ____________________________________________________________________________________________
|
|
|