Re: Newbie question...Where to start?...(Compact Framework, SQL Server CE)

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



Everybody gets lost on Microsoft's huge site, and most of us use a search
engine like MSN or Google
I second this, Better use word "newbie" and do a google group search

http://groups.google.com/advanced_group_search

you will get lots of threads discussed the topics helping newbie and
few will
really help you to start with.

http://groups.google.com/group/microsoft.public.dotnet.framework.compactframework/browse_thread/thread/dbfd688a5ac7e7fd/a027759622b671b9?lnk=st&q=tons+of+articles+arun&rnum=8#a027759622b671b9

I always feel MSDN is the best book for this,
You can download SQL Mobile books online in this link,
http://download.microsoft.com/download/2/4/8/2482e95d-00fd-4374-bd15-57a8c4c34444/SQLMobileBooksOnline.exe

There is an interesting web cast rather many webcast explaining SQL
Mobile, one in that
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032283150&EventCategory=5&culture=en-US&CountryCode=US

Darren Shaffer's Blog
http://dotnetjunkies.com/WebLog/darrenshaffer/default.aspx

Hope this helps,
Cheers,
Arun
www.innasite.com



On Mar 28, 10:04 am, "forest demon" <mete.ha...@xxxxxxxxx> wrote:
that's good info. thanks a ton. i do appreciate you people!

On Mar 28, 10:52 am, "Ginny Caughey [MVP]"



<ginny.caughey.onl...@xxxxxxxxxxxxxx> wrote:
That's a lot of questions! So I'll just tackle a few of them:

Usually it's easiest to put the sdf file in the same folder of the
emulator/device as your app. You can set up VS to automatically deploy the
sdf file along with your app for testing. I generally prefer to test on the
actual device if I have one as it's usually faster as well as closer to the
actual experience.

I like SQL Server Management Studio (or SQL Express Sp2 Management Studio)
for testing queries, etc., although you can also use Visual Studio for that.

You can use Activesync to connect to the server for syncing or some other
such as wireless - it just depends on your infrastructure. The actual
syncing can be done using web services, or in the case of SQL Server as the
server also RDA or merge replication. You can also just copy the sdf file to
the desktop and write a desktop app to do the syncing. Again, it depends on
your needs.

Everybody gets lost on Microsoft's huge site, and most of us use a search
engine like MSN or Google to find what we want. Start by looking for SQL
Server Compact Edition Books Online. Also check outwww.microsoft.com/sql/compactfordownloads, whitepapers, tutorials and
webcasts.

--
Ginny

"forest demon" <mete.ha...@xxxxxxxxx> wrote in message

news:1175098937.968320.50340@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

i just got a project thrown into my lap....develop client/server apps
for a device running WinCE.

i have the Compact Framework installed as well as SQL Server CE. i'm
developing under VS2005.

questions:
- diffs between emulation and the actual device(some of this is
apparent)?
- when working with a client database, where does the .sdf
live(emulation/actual)?
- what SQL Server CE tools(query analysis, management, etc) to use?
- interaction between the client(SQL SE) and the server(whatever
DB) through ActiveSync, or what else?
.....and a ton of other questions i imagine.

am i the only one that gets lost in the bowels of the Microsoft site?

thanks folks, i appreciate your patience and any input(book and url
references, etc)

-
d(a)emon- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -


.



Relevant Pages

  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • It can be Done
    ... I just installed a 3 SQL Server 2005 instances on a 2 node Active/Passive cluster. ... IWiz will then offer you a choice of Group on where you can install teh Fail Over Clustered Instance of SQL. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)