tag:blogger.com,1999:blog-5238131531249720750.post8882568693329422273..comments2024-03-19T13:28:26.291+01:00Comments on Everything SQL Server Compact: SQL Server Compact Toolbox 3.1.1 with support for Windows Phone 8 and VS 2012 releasedErikEJhttp://www.blogger.com/profile/12641272161018114573noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-5238131531249720750.post-64656862190419070852013-01-08T20:39:15.157+01:002013-01-08T20:39:15.157+01:00Excellent ... I have a script!!
thanks a million f...Excellent ... I have a script!!<br />thanks a million for all your help.<br />this is going to make my life much easier...Anonymoushttps://www.blogger.com/profile/11526160730692825537noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-37942436508332268762013-01-08T19:55:41.095+01:002013-01-08T19:55:41.095+01:00Paul: I got it to work: Type (localdb)\v11.0 in th...Paul: I got it to work: Type (localdb)\v11.0 in the Server Name, type the database name, and just click ok, no Test button. I will post a guide in a blog post soon. ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-39351816522052110652013-01-08T19:36:17.541+01:002013-01-08T19:36:17.541+01:00Paul: Can we take the further discussion of the by...Paul: Can we take the further discussion of the by email or via the CodePlex issue tracker, we will get it to Work, I am sure. Launching the Toolbox is not project related, so I do not understand that issue, the Toolbox lives on it own, just like Server Explorer does.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-2725787021418187872013-01-08T19:26:57.188+01:002013-01-08T19:26:57.188+01:00This is a Win8 machine with VS 2012 with updates. ...This is a Win8 machine with VS 2012 with updates. I can connect to localdb via Server Explorer from any project. I can only launch ToolBox from a project that has a CE database. ToolBox can explore and edit this CE 4.0 great. In this same project I can use Server Explorer to connect to any localdb's it has. If I attempt to connect to localdb through the the ToolBox I get the error I posted up. This localdb is actually an Azure SQLdb which I've copied (SQLAzureMW .. fabulous program!). I can connect to the AzureDb and Toolbox generates a beefy .sqlce for me! So I think I've got a path to get my Ce 4.0. Be glad to try anything to get the localdb connect to work.Anonymoushttps://www.blogger.com/profile/11526160730692825537noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-58186084413373748852013-01-08T19:00:00.599+01:002013-01-08T19:00:00.599+01:00Paul: Interesting, I will test it. Do you have .NE...Paul: Interesting, I will test it. Do you have .NET 4.0.3 installed? You are running Vs 2012? Can you connect to localdb via Server Explorer?ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-5484352022677591622013-01-08T17:08:31.434+01:002013-01-08T17:08:31.434+01:00I opened another project that does have a Compact ...I opened another project that does have a Compact database and was able to open the toolbox. Now I can get the "Script Server Database...Data". Which gives me the Data Link Properties. Using "(LocalDb)\v11.0" as the server name with Integrated security I get a Test connection failed because of an error in the initializing provider.[DBNETLIB]ConnectionOpen(Connect().]SQL Server does not exit or access denied.Anonymoushttps://www.blogger.com/profile/11526160730692825537noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-63035399256809106652013-01-08T09:20:56.032+01:002013-01-08T09:20:56.032+01:00The Toolbox should be able to do that, have you tr...The Toolbox should be able to do that, have you tried right click on the root node? Or maube try 3.2 Alpha build?ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-85464197293310181302013-01-08T02:22:18.029+01:002013-01-08T02:22:18.029+01:00I need to convert a (localDb)\v11.0 db to Compact ...I need to convert a (localDb)\v11.0 db to Compact 4.0. The VS2012 addin doesn't seem to support this (toolbox wont launch without a Compact connection). Will your older command line tools work with the new database format to do the downgrade?Anonymoushttps://www.blogger.com/profile/11526160730692825537noreply@blogger.com