tag:blogger.com,1999:blog-5238131531249720750.post5882998389881795871..comments2024-03-19T13:28:26.291+01:00Comments on Everything SQL Server Compact: Walkthrough: Expose SQL Compact data to the world as an OData feed, and access SQL Compact data from Excel 2010 and SilverlightErikEJhttp://www.blogger.com/profile/12641272161018114573noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-5238131531249720750.post-68593368086543566662013-06-07T08:33:53.627+02:002013-06-07T08:33:53.627+02:00Tim: No, not currently, but a good idea for a new ...Tim: No, not currently, but a good idea for a new blog post.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-89279422599877357582013-06-07T02:01:38.055+02:002013-06-07T02:01:38.055+02:00Got all the way to Step 3; but WCF Data Services w...Got all the way to Step 3; but WCF Data Services was not available in the dropdown. <br /><br />I am using VS2012, SQL Server 2012 CE, and Excel 2010. <br /><br />Do you have an updated walkthrough?Anonymoushttps://www.blogger.com/profile/15130288113946984001noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-90272810077314592862013-02-19T13:59:27.826+01:002013-02-19T13:59:27.826+01:00Is it possible to use ODC or similar to connect an...Is it possible to use ODC or similar to connect an Excel 2010 pivottable to a SQL Compact SDF.<br /><br />I don't want to use VBA to bring in all the data into a table or sheet in Excel if at all possible.<br /><br />Works fantastic with ODC off SQL Server - must be a way to do something similar without Power Pivot??guypbhttps://www.blogger.com/profile/13631418894621597445noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-23094410735013625562013-02-19T13:57:21.372+01:002013-02-19T13:57:21.372+01:00I'm sure this must have been covered but I hav...I'm sure this must have been covered but I have searched and searched... can a SQL Compact Database be accessed via ODC direct from Excel without the need for VBA?<br />I am trying to connect a pivottable direct to a SQL Compact sdf without running VBA to bring in all the data to a table.guypbhttps://www.blogger.com/profile/13631418894621597445noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-71055073248173224152012-05-16T11:13:36.609+02:002012-05-16T11:13:36.609+02:00Roderick: Not really, suggest you ask elsewhereRoderick: Not really, suggest you ask elsewhereErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-3814846343546477842012-05-16T02:03:07.978+02:002012-05-16T02:03:07.978+02:00Great set of instructions however my problem is th...Great set of instructions however my problem is that my mobile devises do not have web access but need to do lookups in MS Access data during the day and get an updated database at night, any suggestions?Roderick Teedhttps://www.blogger.com/profile/14272092605669428646noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-37081921552696011082010-06-25T08:20:11.216+02:002010-06-25T08:20:11.216+02:00Hi Joel,
I have tools to create SQL CE compatible ...Hi Joel,<br />I have tools to create SQL CE compatible DDL scripts (Microsft does not supply such a tool). Go to http://exportsqlce.codeplex.com, you can use Export2SqlCe command line or one of the addins.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-52616191452066649052010-06-24T23:19:51.585+02:002010-06-24T23:19:51.585+02:00Erik -
Excellent post. I have never worked with ...Erik - <br />Excellent post. I have never worked with SQL CE before but have an application that currently uses WCF Data Services to communicate with a network server. I am trying to give the user the option to use SQL CE on their local machines instead. <br /><br />I am having trouble using my ddl script to generate the SQL CE Tables. It works fine with SQL 2008 R2. Can you create CE databases with ddl scripts?Joel Karrhttps://www.blogger.com/profile/02159879332719070147noreply@blogger.com