Stack Overflow
Stack Overflow

Questions tagged [compact-database]

70 questions
0
votes
2 answers

How to read columns from compact database

I'm using C# 2010 Express and Sql Compact. I have a table named as "Records" and column named as "Names" I want to list that names in a listbox. I wrote that code but last line is thorws "ExecuteReader: Connection property has not been initialized."…
Sefa
  • 8,865
  • 10
  • 51
  • 82
0
votes
1 answer

How to compare database entry and form entry

I'm using C# 2010 Express and Sql Compact. I have two-column table and a form to add a data to save to the table. But I dont want to save same entrys. For example; Name City Sefa Istanbul Sefa New york Sefa London Ben New…
Sefa
  • 8,865
  • 10
  • 51
  • 82
0
votes
1 answer

How to enable auto-increment with Sql compact & C#

I'm using C# 2010 Express. I have created a SQL Server CE database file (.sdf) then created Information table and ID, Name, City columns with Database Explorer. I want to save names and city user will write to the form. The auto-increment option is…
Sefa
  • 8,865
  • 10
  • 51
  • 82
0
votes
2 answers

Store in a variable the number of rows from a table where a column has a certain value in SQL Server Compact

I have a Windows Forms application and a SQL Server Compact 3.5 database. I want to store in a variable the number of rows from a table where a column has a certain value. I have something like this to count all the rows from a table: CarsDataSet…
user3751422
  • 3
  • 3
0
votes
0 answers

Compact MSAccess Database (.accdb) without having MSAccess installed preferably with Java

I am developing a management system that uses an Access Database to store data. The database is updated frequently and due to this it tends to bloat. The user doesn't have Microsoft Access, but has Windows 10. Is there a way to programmatically…
Cpt_Pi
  • 1
  • 2
0
votes
1 answer

C# DbDataReader populating List result in OutOfMemoryException

I am currently trying to read a large table from an compact ce database containing aprox 3-4 million rows. The database size i currently 832MB. Populating a list with the records is throwing OutOfMemoryException The mockup code: using (var con =…
jsandv
  • 276
  • 4
  • 20
0
votes
0 answers

Call an auto compact after event

I have some code, which works perfectly fine, that compacts an Access database when the database is opened. However, I'm a little stuck as to how to do the next bit. What I want to happen is that when an item within the DB table gets marked for…
james ellis
  • 23
  • 6
0
votes
1 answer

Couchdb compaction and deleted documents

When I delete document its revision is increased, then PUT the same document, its revision is increased. After compaction, PUT the same document, its revision is started from 1. And now, when I got document, I have the message, that this document…
InnerWorld
  • 585
  • 7
  • 26
0
votes
1 answer

How to Create MySQL Compact Database?

I want to use MySQL like SQL Compact Edition! In other words, I want to create a local database (compact database file) by MySQL csharp drivers in from Connector/Net . In my project we need first to install MySql.Data.dll in the GAC and my Data…
Behzad
  • 3,502
  • 4
  • 36
  • 63
0
votes
1 answer

Connection to Database Closed before data input

I am using Visual Studio 2008, with Microsoft Server Compact 3.5 and the script is written for Windows Mobile 6.5.3 Professional. I have a small form script that connects to a database file, after inputting data into the form, when you select the…
JJ Morgan
  • 117
  • 8
0
votes
1 answer

Solution for merging data from multiple sql compact databases to a central sql server database using sync framework

I am currently working on an application for tablets that uses a SQL Server Compact 3.5 database. The need has risen to sync data among tablets. After some research (namely this and this), my team and I decided to have a central database hosted by…
user5398447
0
votes
0 answers

Generate SQL Server Compact 3.5 to SQL script?

I need to convert a SQL Server Compact database file to SQL Server, so I think generate script is the best way, but I can't find anything in SQL Server CE Toolbox 3.5 Is there a workaround?
Andiana
  • 1,912
  • 5
  • 37
  • 73
0
votes
1 answer

The specified locale is not supported on this operating system. [ LCID = -1 ]

It's my first post here, so sorry for any mistakes I make. I get this error when I try to open a compact database with a program called Edusal, I tried also to open it with SDF viewers but they give me the same error, can someone help me? The…
Megabitus
  • 27
  • 4
0
votes
2 answers

Why doesn't AbortTransaction work?

I am using npoco, trying to work with transactions, I can´t get the AbortTransaction method to rollback anything in my db. public class ItemRepository { private Func _db; public ItemRepository(Func db) { _db = db; …
daniel_aren
  • 1,714
  • 3
  • 24
  • 41
0
votes
1 answer

How to compact database access file in vb

Now i have database already in my folder but size of file is biggest.Then i want to compact this file but i get some error about "Invalid argument.", How can i do in this case. thank u this my code Dim JRO As New JRO.JetEngine Dim source =…
user3001046
  • 235
  • 1
  • 10
  • 28
1 2 3
4
5