Hi, I'm sorry, but the functionality you need isn't implemented, and the project has been abandoned since the SQLCE database itself is completely obsolete. I'm sorry I can't help you, best regards
Hi, I need to export the results of a sql query to csv file and it doesn't look like this function is implemented. Am I missing something? Could it be implemented? Thank you!
When you open an encrypted document, a dialog box seems to go into the password. Entering the proper password for game meat bags page, file is displayed and you could paintings with the everyday way.
Hi, Please read this thread: https://sourceforge.net/p/compactview/support/support/thread/bf257230
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style><!-- /* Font Definitions */ @font-face {font-family:SimSun; panose-1:2 1 6 0 3 1 1 1 1 1;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:DengXian; panose-1:2 1 6 0 3 1 1 1 1 1;} @font-face {font-family:DengXian; panose-1:2 1 6 0 3 1 1 1 1 1;} @font-face {font-family:SimSun; panose-1:2 1 6 0 3 1 1 1 1 1;} @font-face...
Here is a command line utility that can used for compact sql files: https://github.com/ErikEJ/SqlCeCmd
Thanks for your answer. Julien
Hi I sorry, CompactView don't support command line options. I currently do not know of any tool to export via command line.
Dear all, Do you know if Compact view can be used through command line. My need is to export data without opening the GUI. I'm looking for command line options like : -i for input file -p for password -o for export file When I launch compactView through cmd, I do't think this function is available. If confirmed, do you know if an alternative method exists to exports .sqf (sql CE 4.0) files? Thanks for your reply Julien
Continue... There is C:\Windows\System32\sqlcese40.dll version 4.0.9600.1 dated 2014 and "C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\sqlcese40.dll" version 4.0.8876.1 dated 2012.
I can't open database on W 8.1/64. The error says there is a problem with sqlcese40.dll. I have reinstalled SQL server version 4.0 SP1 (SSCERuntime_x64-ENU.exe), but no way...
I was to able to resolve the issue by using your solution. thanks
Hi, Your database is version 3.5, please install version 3.5 server and try again: Microsoft SQL Server Compact Edition v3.5 SP2 (Version 3.5 and 4.0 servers can live together)
When i am trying to open the database, the program send me this error. Can't load 'System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91', or one of the dependencies.the system cannot find the specified file. i installed microsoftdotnet 4.0 still im not able to open it. please can u provide me a solution.
Hi, Please try opening the attached database (Microsoft test database). Can you open this database correctly?
Hi there I try to open a sql server 3.5 file and get this: [cid:image001.jpg@01D54801.006ABCE0] I have .net 4 and also sql compact 3.5 (which this database is). I can open the database with the app I've developed, but I'd like to use your tool to help me look at it. Thanks David
Hi, To downgrade your database to version 3.5 you can try the following: 1) Install both servers version 3.5 and 4.0 2) Open your database version 4.0 and export all (menu File - Export) 3) Create a new empty database version 3.5 (menu Tools, press the button "..." to choose a file and enter a new file name. Select version 3.5 for the database. Press the button "Create") 4) Open your new database version 3.5 and import from the file previously exported
Thank you for your support. I hope use version 3.5 SP2 bicause the program is not compatible with version4.0 or later. And I can not rewrite the program. I used version4.0SP1 at the beginning but program did not move, so I used version3.5SP2 after erasing version3.5SP2.
Hi, The error message refers to the missing assembly corresponding to version 4.0, therefore the database you are opening is version 4.0 Please reinstall server version 4.0 SP1: https://www.microsoft.com/en-US/download/details.aspx?id=30709
I use japanese. This message has the same meaning as that of the above
Hi, Please attach a screenshot of the error
Yes. I installed the version 3.5 SP2
Hi, You have installed the version 3.5 server? https://www.microsoft.com/en-us/download/details.aspx?id=5783
Hi, You have installed the version 3.5 server?
I get the same error after changing the database from 4.0 to 3.5. Do you know how to make it usable in 3.5?
Version 1.4.16 has been released to add option for execute the selected text without prompt (Tools-Options menu).
Changes
Is there any way you could add a checkbox to the "Do you want to execute the selected text only?" confirmation that says don't show this again? I appreciate the warning, but I'd like to opt out of it if possible.
Hi, first sorry for the delay Database passwords are single-byte characters
are database passwords Unicode characters or single-byte ASCII
Hi, This software needs for its operation the database engine of Microsoft Sql Server compact edition and there is no version of this database for mac, sorry.
Good day , Can i use this software on a mac ios
Good day , Can i use this software on a mac ios
License
Changes
Hi Nicoledit, Thanks for your contribution.
Here's my contribution. Thanks for your software!
Here's my contribution. Thanks for your software!
thank you. I found a workaround. I put a msvcr110.dll in a 32-Bit Version into the Compactview directory. Then it works!
Hi, Is a problem of compatibility of the version 3.1 assembly that is very old and it seems that it does not register in windows 10 x64. As an workaround download the attached executable to upgrade your database to version 4.0. After doing the upgrade you will have a file "yourFileName_new_.sdf" of version 4.0. Make sure you have installed version 4.0 of the database engine: Sql Server Compact Edition v4.0 SP1
I installed it, but it does not work. Attached the Database
Sorry, version 9.0.242.0 corresponds to the data base engine v3.1 (this is a very old version): Sql Server Compact Edition v3.1
Hi, I have it installed on windows 10 pro 64bit and it works correctly, please make sure you have installed the database engine: Sql Server Compact Edition v4.0 SP1
The Viewer do not work with Windows10 pro 64-Bit. Why? (can not find System.Data.SqlServerCe Version 9.0.242.0 or dependency)
Hi, Thanks for your report. Version 1.4.14 has been released today to corrects this bug. Changes in the source: Added the event DataGrid_ColumnAdded to set Column.FillWeight = 1; Changed property DataGridView.ColumnHeadersHeightSizeMode = DisableResizing to improve performance.
Changes
If i load a table with above 655 fields, the datagrid throws a error: FillWeight sum is above 65535. I couldn't open the table. Cause: By default, the FillWeight values are set to 100 for each column. Remedy (as a suggestion): private void treeDb_AfterSelect(object sender, TreeViewEventArgs e) { if (!db.IsOpen) return; var cursor = Cursor; Cursor = Cursors.WaitCursor; dataGrid.SuspendLayout(); Application.DoEvents(); if (e.Node.ImageIndex == 0) { // Database node dataGrid.ReadOnly = true; dataGrid.DataSource...
If i load a table with above 655 fields, the datagrid throws a error: FillWeight sum is above 65535. I couldn't open the table. Cause: By default, the FillWeight values are set to 100 for each column. Remedy (as a suggestion): private void treeDb_AfterSelect(object sender, TreeViewEventArgs e) { if (!db.IsOpen) return; var cursor = Cursor; Cursor = Cursors.WaitCursor; dataGrid.SuspendLayout(); Application.DoEvents(); if (e.Node.ImageIndex == 0) { // Database node dataGrid.ReadOnly = true; dataGrid.DataSource...
The program only needs the executable "CompactView.exe" and ((if your language is not English) the language xml file. The attached zip archive contains these files. You must keep in mind that the executable depends on Microsoft .NET Framework 4.0 (you will normally already have it installed on your server). Of course you also need the Sql Server Compact database engine. This is not sure you already have it installed on the server. The database engine is owned by Microsoft and comes in the form of...
Hi - fantastic product. - is there a protable version? If not what files do I need to copy to the directory to make it portable? I am not able to do a normal install on the servers I need this on.
Hi, CompactView works with local PC files. Please copy your database files from yout...
I click on my SqlServer files and nothing happens. They from an arm device.
thank for simple and fast program. Can you support import table from csv file
License
Hi, Download the new version 1.4.13 and right-clicking on the header causes the width...
Changes
Is there a way to expand the width of the column... if you sort by column, the width...
Hi SteveZ, You can attach the ExportForm.cs file here to share with all who would...
Hi SteveZ, i am very interested at your changes. Please send it to my e-mail adress:...
Hi Michael, I'm sorry but I have not used the program Lemon Parser Generator to create...
Thank you for developing this programme; it works perfectly for me! I am working...
Hi Peet Baldem, Thanks for your contribution.
Here is my German Translation.
Hi - Thanks for creating this great utility! The application fails when performing...
Ah, I see. I have another laptop (somewhere) that I know worked, so I will try to...
The version used depends on the version with which the sdf file was created. I have...
The version used depends on the version with which the sdf file was created.
I installed that version, but no change in the behavior of CompactView. Any reason...
Home
Home
Hi, The version 9.0.242.0 of the assembly corresponds to the version 3.1 of the SqlServerCe....
I'm having a similar problem on Windows 10. The exact error I get is: "Unable to...
Hi, please be sure to install the appropriate version of the database server from...
Hi, please be sure to install the appropriate version of the database server from...
When we try to open an .sdf file, get message "Unable to open the database. Could...
It works. Thank you very much !
Hi Jordan Chen, Thanks for your contribution, the traditional and simplified Chinese...
Changes
Changes
OK now I see the "add attachment" link in the reply page.
I'd like to provide my Trad. Chinese and Simp. Chinese translation. However, I don't...
To create a translation edit the file "CompactView_en-EN.xml" and save it changing...
Changes