Stack Overflow
Stack Overflow

Questions tagged [vistadb]

VistaDB is an Embedded SQL Database Engine for .Net (SQL Server compatible)

39 questions
189
votes
11 answers

What is a good choice of database for a small .NET application?

I'm developing a small application with C# in .NET and I want to have a small light weight database which does not use much resources. Could you please list some of the best known light weight database softwares.
ePezhman
  • 4,010
  • 7
  • 44
  • 80
12
votes
4 answers

What are the advantages of VistaDB

I have seen the references to VistaDB over the years and with tools like SQLite, Firebird, MS SQL et. al. I have never had a reason to consider it. What are the benefits of paying for VistaDB vs using another technology? Things I have thought…
Andrew Burns
  • 13,917
  • 9
  • 40
  • 42
5
votes
3 answers

Can Someone Explain VistaDB Please?

I'm seeing it pop up more and more and not really understanding the purpose of it? Can I only use it when I am developing locally on my desktop? Or can I put a commercial site on a server with say Win2003 thats using VistaDB? Is it faster than…
YodasMyDad
  • 9,248
  • 24
  • 76
  • 121
3
votes
0 answers

Is VistaDB compatible with Microsoft Enterprise Library DAAB?

As the title asks, is VistaDB 3.x/4.x supported in Data Access Application Block (DAAB) of Microsoft Patterns and Practices Enterprise Library 3.x/4.x? If it is and you have used the two together, are there any issues or caveats I should know about?…
410
  • 3,170
  • 8
  • 32
  • 36
2
votes
3 answers

Hierarchical query without CTE

With the lack of CTEs/recursive queries on VistaDB, I'm trying to formulate a viable query with a certain depth to query a PARENT/ID hierarchical self-referencing table. I had several ideas (SQL is from Firebird, as we are using it on the server…
Alexander Gräf
  • 511
  • 1
  • 3
  • 10
2
votes
2 answers

SELECT INTO advanced

I have many tables in my database and I am collecting calculated values with following code and would like to Insert those values into other table. I am Using SELECT INTO method but database tells me that "Incorrect syntax near the keyword INTO line…
Hakan
  • 141
  • 3
  • 16
2
votes
2 answers

Can Sybase Sql Anywhere be deployed like VistaDB (or MSAccess)?

The context : My current project uses VistaDB as it really fits the main scenario: the user log into the application, selects the DB (file on HDD or Network drive), does his job, then logs off. The DB (a single file) can be copied (email, usb…
elpipo
  • 124
  • 5
1
vote
2 answers

Unable to load DLL VistaDb20.dll because of an invalid access to memory location (HRESULT: 0x800703E6)

I have a project that was built in Visual Studio 2005 in C#. I created an installer for the Windows application (in VS2010) and it installs and works fine on Windows XP SP3. I tried installing it on Windows 7 32-bit and it says installation is…
tennisbuddy
  • 35
  • 6
1
vote
3 answers

Downgrade SQL CE from 4 to 3.5?

Does anyone know if it's possible to downgrade an existing SQL CE 4 database to 3.5? The reason I ask is because I'm looking to migrate from SQL CE to VistaDB...and VistaDB's data migration wizard only takes SQL CE 3.5 db's.
Rob Lauer
  • 3,075
  • 1
  • 32
  • 44
1
vote
2 answers

Given a recursive query that starts with a child, how can I eliminate sibling and parent rows?

I have managed to build a recursive query which returns rows for the selected Id and all its children. This works absolutely fine for the ultimate parent, but I need it also to work correctly when the passed Id is that of one of the children,…
oldcoder
  • 342
  • 2
  • 12
1
vote
2 answers

How do we examine a particular job in GTM?

Just as we have in Intersystem Cache D ^JOBEXAM to examine the jobs running in background or scheduled. How can we do the same in GTM? Do we have any command for the same. Please advice.
Dhaval Shah
  • 9,042
  • 2
  • 14
  • 21
1
vote
2 answers

Insert INTO in vb.net

I have 2 databases. In first one I have 10 tables. Second one is only 1 table. I would like to select 1 columns from each table from 1st database and Insert INTO another database. How can I manage this using INSERT INTO statement in VB.net?
Hakan
  • 141
  • 3
  • 16
1
vote
5 answers

What are the disadvantages of VistaDB

I am looking into using a lightweight serverless database engine like SQLite, Firebird, or VistaDB in an upcoming project. Someone asked about What are the advantages of VistaDB. I would like to know what are the disadvantages of using VistaDB…
410
  • 3,170
  • 8
  • 32
  • 36
1
vote
1 answer

All embedded databases fail to open connections

I'm working on a winforms desktop application that needs to store data. I made the really bad decision to try and embed a database. I've tried: SQLite VistaDB SQL Server Compact In each case, I was able to generate a Entity Framework Model over…
rsteckly
  • 1,952
  • 3
  • 23
  • 35
1
vote
0 answers

Cascade delete is happening even though there is no foreign key relationship between 2 tables

Lets say there are two tables Student and Address. There are no foreign key relationship between the two tables. Let me give the sample structure. Student TABLE ID, Name, AddressID, Email Address TABLE AddressID, DoorNo, Street, City, Country The…
Murali Kothandaraman
  • 41
  • 2
  • 9
1
2 3