Questions tagged [compact-database]
70 questions
0
votes
0 answers
Is it possible to run SQL Server Compact Edition totally in memory?
I have a need to run a small database in memory (no disk). It's important that the data only be loaded in memory and not persisted on disk. I will load the database up when the application starts. The source database is SQL Server. Its a very small…
Paul Fryer
- 9,268
- 14
- 61
- 93
0
votes
2 answers
EF 6.0 Code first Compact Edition: incorrect connection string or app.config problems?
ask your advices about this:
I am trying to create db compact edition,
first time it was successfully with default dbName (ProjectName.dbContextName).
But i decided to define my own name, and added in app.config in connectionString sections my…
Ryan
- 609
- 6
- 13
0
votes
0 answers
SqlServer Compact into RAM?
I'm developping a C# project with SqlServerCompact.
I have to open a connection with the database for each request and create a reader/executenonquery. But is it possible to load all the database in the memory ? (sqllite did this in c++ as far as i…
user2088807
- 1,378
- 2
- 25
- 47
0
votes
2 answers
Can I access an encrypted SQL Server Compact database in Excel VBA?
I want to access an encrypted SQL Server Compact Edition database via VBA. I can access the database fine when it is not encrypted, but the code breaks when I try to use a password:
pConn.ConnectionString =…
Peter Rankin
- 713
- 1
- 6
- 29
0
votes
1 answer
Should I compact a MongoDB database before mongodump/mongorestore?
I have a database that hasn't been compacted in a while so its disk size is much larger than actual data and index sizes. I'll be moving it to another database and would like to know:
would compacting speed up mongodump
does mongorestore rebuild…
Aaron Silverman
- 22,070
- 21
- 83
- 103
0
votes
3 answers
Access Creates new file every time I Compact & Repair
It didn't always do this, but ever since I split my database and made the front-end an ACCDE file, any time I try to compact and repair either file, a new file called "Database 1" is generated and my original file size doesn't change.
Is this…
NickSentowski
- 820
- 13
- 27
0
votes
2 answers
CompactDatabase with dbEncrypt returns "3001: Invalid argument" error
I am getting a 3001: Invalid argument error when trying:
DbEngine.CompactDatabase "db1.accdb", "db2.accdb", , dbEncrypt
I believe the function is using ACEDAO.DLL version 14.0.6016.1000
What could be the cause of the error? It only seems to…
CJ7
- 22,579
- 65
- 193
- 321
0
votes
1 answer
IDatabaseCompact.Compact() on an used IWorkspace
I am writting an ArcMap-AddIn with vb.net. I got an error when trying to compact my IWorkspace(mdb), the error is:
COMException
You tried to open a database, which was already opened by the user
'ADMIN' on Computer 'XXXXXX'. Try it again when the…
Munchies
- 444
- 6
- 14
-1
votes
2 answers
How to read data faster in Entity Framework from SQL Server Compact C#
I used SQL Server Compact edition v4.
When I get new from entities, it takes 1 second, but when I count from a table with only one record, it takes 4 seconds.
I used Entity Framework and SQL Server Compact Edition.
What is the reason for this slow…
user11657764
-4
votes
1 answer
MS Access Jet Database programatically compact
Ref: Access "Compact and Repair" programatically
HI Guys, I'm looking for a way to run a batch script via scheduled task to compact and or repair a "Jet" .mdb file / database.
Environment
Win 7 32 bit
Jet 4.x format
application.exe Original code…
