tag:blogger.com,1999:blog-5238131531249720750.post5907434383563342676..comments2024-01-22T04:58:27.847+01:00Comments on Everything SQL Server Compact: SQL Compact 3rd party toolsErikEJhttp://www.blogger.com/profile/12641272161018114573noreply@blogger.comBlogger37125tag:blogger.com,1999:blog-5238131531249720750.post-63384206875557792302018-04-20T19:28:32.822+02:002018-04-20T19:28:32.822+02:00@UK: Updated!@UK: Updated!ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-15101042095172325392018-04-17T08:59:13.080+02:002018-04-17T08:59:13.080+02:00You could adjust your CodePlex links to point to G...You could adjust your CodePlex links to point to GitHub.UKhttps://www.blogger.com/profile/15586421252144587526noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-40576887359951905862018-04-02T08:20:18.711+02:002018-04-02T08:20:18.711+02:00@rekojem: No, I do not know any other tools - rest...@rekojem: No, I do not know any other tools - restore a backup!ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-86621561752161549002018-04-01T19:33:50.303+02:002018-04-01T19:33:50.303+02:00Do you know of any repair tools for sqlce. I have ...Do you know of any repair tools for sqlce. I have a sdf file that will not open and gives the error message The database file is corrupted, possibly due to a file system issue. Ive tried your sqlcecmd40 repairdatabase with no joy aswell as other editors.rekojemhttps://www.blogger.com/profile/15284042836379025660noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-20050871870381616902016-08-06T21:32:18.524+02:002016-08-06T21:32:18.524+02:00Radwan: pls do not use these blog comments for the...Radwan: pls do not use these blog comments for the support, ask on gothub or stackoverflow, pleaseErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-28325813451346087882016-08-06T19:51:39.273+02:002016-08-06T19:51:39.273+02:00what can I do if I've got this message ?
SQL ...what can I do if I've got this message ?<br /><br />SQL Server Compact does not support calls to HasRows property if the underlying cursor is not scrollable.Anonymoushttps://www.blogger.com/profile/01586793674178805014noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-46017554560268174722016-04-29T01:24:13.410+02:002016-04-29T01:24:13.410+02:00Hello Sir. I love your blog. Keep up the good work...Hello Sir. I love your blog. Keep up the good work.<br />I have found all the necessary info about what database is right in terms of their pros and cons. This site has been truly useful to me.<br /><br />I however want to make a humbly request. I wish you will make a tutorial about using SQLite with VB.NET, C# with SQLite.<br />There seems to be very limited resources out there. Even if they are many, they seem to very fragmented and the steps seems very confusing to me...Some talk of Finisar dll that needs to be downloaded etc. <br /><br />To me, as it seems SQLite is going to be the future db for apps, I wish there was a good site or blog dedicated to it providing solid tutorials on how to complete the basics of every DB app - CRUD. (Add, Read, Edit, Delete) with the embedding/and retrieval of images to the database as well.<br /><br />I have managed to make a head start but due to very limted resource materials on .net and sqlite, I have found myself wanting.<br />For example, I have been able to load all the tables in the database to a combobox, but I am unable to display the content of a table in a listview for instance.<br />I urge you to google: "How to display sqlite table contents into listview in VB.net" and all you get is stuff relating to android.<br /><br />Please kindly help. We need resources on the .net languages (VB.NET esp & C# and SQLite). ALso please help me with how to display the contents of the sqlite table to my listview. It will be very much appreciated by the way. :)<br /><br /><br /><br />Samuel Dexter Gaisie-Yeboahhttps://www.blogger.com/profile/13288859601446234389noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-53822338097774936442014-02-26T15:13:35.554+01:002014-02-26T15:13:35.554+01:00Hi,
First of all, thanks for your these posts......Hi, <br /><br />First of all, thanks for your these posts... very useful.<br /><br />In case you would like to keep your post up to date, Compact view has just been updated to version 1.4.2 on 2014-02-18.<br /><br />Tnks!Anonymoushttps://www.blogger.com/profile/02430912842229749195noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-85692579021998778152012-11-05T11:01:54.001+01:002012-11-05T11:01:54.001+01:00Thanks it helped me!Thanks it helped me!Rama Charanhttps://www.blogger.com/profile/03730900434726966433noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-78808752426392857002012-08-20T19:26:55.406+02:002012-08-20T19:26:55.406+02:00Just needed an editor and a way to run scripts.
o...Just needed an editor and a way to run scripts.<br /><br />on this Win7 64b machine:<br /><br />SQL Compact Query Analyzer <br />installs but nothing shows up in the start menu<br /><br />SQL CE Browser <br />crashes promptly on start up<br /><br />SQL CE Database Editor <br />crashes promptly on start up<br /><br />SqlCeExplorer<br />crashes promptly on start up<br /><br />CompactView <br />too minimalist and slow<br /><br />Compact Query <br />just works<br />faststentorhttps://www.blogger.com/profile/04832976561353205176noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-67778163980325932342012-05-11T00:29:37.766+02:002012-05-11T00:29:37.766+02:00could you see my question?
http://stackoverflow.co...could you see my question?<br />http://stackoverflow.com/questions/10542544/a-lot-of-update-same-column-at-one-query-how-to-do-this-dynamic-query<br /><br />mutiples query how convert it, only in one? cuz it update all rowsangelhttps://www.blogger.com/profile/12411226377815424735noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-22221548853980293562011-11-11T08:21:16.888+01:002011-11-11T08:21:16.888+01:00Axtur: Yes, it will be on the list soon - yet anot...Axtur: Yes, it will be on the list soon - yet another query tool - I wish all the query tools developers could join forces instead of each developing the same tool!ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-41762889347568304792011-11-11T00:10:08.512+01:002011-11-11T00:10:08.512+01:00Other utility to view/edit/query and show schema i...Other utility to view/edit/query and show schema is the open source program "CompactView":<br /><br />http://www.sourceforge.net/p/compactview/home/Home/Axturhttps://www.blogger.com/profile/14845798066629172824noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-21303212713601678322011-10-18T10:01:48.061+02:002011-10-18T10:01:48.061+02:00Jose: See this post: http://erikej.blogspot.com/20...Jose: See this post: http://erikej.blogspot.com/2010/06/walkthrough-expose-sql-compact-data-to.htmlErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-44460377717062319352011-10-17T12:05:17.657+02:002011-10-17T12:05:17.657+02:00Is there a way to connect to a SQL Server CE 4.0 f...Is there a way to connect to a SQL Server CE 4.0 from Excel to use is as a data source for Pivot Table ?<br />I cannot see any Oledb provider corresponding to<br />Windows CE in the Excel Data Source connection dialog after installing it, and the associated tools...Josehttps://www.blogger.com/profile/02942075775208017176noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-9567347864448539332011-09-10T14:55:00.138+02:002011-09-10T14:55:00.138+02:00Eeleen: No, not that I know of, would that be usef...Eeleen: No, not that I know of, would that be useful?ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-22200617554295842332011-09-09T22:20:18.365+02:002011-09-09T22:20:18.365+02:00Are there any web based one similar to PhpMyAdmin?...Are there any web based one similar to PhpMyAdmin?Eeleenhttps://www.blogger.com/profile/17694096603433393256noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-7901888798410826272011-07-22T10:34:26.398+02:002011-07-22T10:34:26.398+02:00Jonx: Agreed, but many entries in the list are ina...Jonx: Agreed, but many entries in the list are inactive projects - maybe I should add that info (Last activity date) to the list, if I can find it.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-50778328421661225622011-07-22T01:24:39.690+02:002011-07-22T01:24:39.690+02:00Very nice list Erik. Thank you.
It's sad that...Very nice list Erik. Thank you.<br /><br />It's sad that they are so many different free projects doing similar things... They should come together and make a common effort...Jonxhttps://www.blogger.com/profile/02834446680849610263noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-16677761491206722992011-05-03T18:02:38.294+02:002011-05-03T18:02:38.294+02:00Nope, (other than migratting access to SQL Server,...Nope, (other than migratting access to SQL Server, but that will be too many steps). The Primeworks tools has very good MS Access supportErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-8701453376276206042011-05-03T17:26:38.753+02:002011-05-03T17:26:38.753+02:00Thanks. I can import my XLS files into an Access ...Thanks. I can import my XLS files into an Access table, the export it as a CSV.<br /><br />With an Access table as a starting point, are there any other options for getting the data into a CE 4.0 database using your Toolbox?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-73172179422916160552011-05-03T17:12:44.024+02:002011-05-03T17:12:44.024+02:00My Toolbox can create INSERT statements from a csv...My Toolbox can create INSERT statements from a csv file, but may be challenged by large Excel files. I do not know any other tool that works directly with Excel files.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-16582218514926863612011-05-03T17:02:19.057+02:002011-05-03T17:02:19.057+02:00I am looking for a graphical sql server CE 4.0 man...I am looking for a graphical sql server CE 4.0 management tool that will allow me to Import data into the tables. I need to import data from large Excel files. What are my options?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-66211750460657515562011-02-22T12:17:23.482+01:002011-02-22T12:17:23.482+01:00Thank you!
Very useful info.Thank you! <br />Very useful info.TrackIT Clienthttps://www.blogger.com/profile/04137000467450247895noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-69782877518323167202011-01-24T19:05:50.487+01:002011-01-24T19:05:50.487+01:00Eric
Can you add two tools to your list please.
...Eric<br /><br />Can you add two tools to your list please.<br /><br />Database Browser Portable<br /><br />http://www.dbsoftlab.com/database-editors/database-browser/overview.html<br /><br />Simple data editing tool<br />Works with a lot of different databases including SQL Server CE 3.1/3.5 <br /><br />Advanced ETL Processor<br /><br />http://www.dbsoftlab.com/etl-tools/advanced-etl-pocessor-news/<br /><br />Powerful Data Transformation tool<br />Support 16 different database types including SQL Server CEETL Guruhttps://www.blogger.com/profile/07610744767093719789noreply@blogger.com