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 of: 1. Compact Framework Support. SQLite+MSSQL support the CF. 2. Need migration path to a 'm...
I'm getting an error connecting to a VistaDB using a connection string in the web.config file. It works fine using a SQLDataSource AFTER I specified the ProviderName. On another page I'm only connecting in code and Here is the code for the connection string: Public Function CreateConnection() As SqlConnection _connectionString = ...
Currently, I have a blog that is using VistaDB as back-end database, but later I realize that I want to MS SQL Server instead. I was wondering there is any tools that are available for migration data like this problem? ...
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 using a SQL DB? Is it secure? Confused... ...
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? Or... Could anybody provide links to source code for the custom provider for Enterprise...
How to use SimpleRepository (SubSonic 3.0.0.3) with VistaDB? Would the SqlSever Provider work or a seprate provider exists for the same? ...
I am on a shared host and whilst in development (umbraco) I think it would be easier to use VistaDB then package up to install to SQL Server. However, I have already started using SQL Server. Is there a way to migrate my SQL Server (2008) database to VistaDB. I assume the schema is identical but I need a way/tool to move the data to Vist...
Hello all, 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 dongle, cd ...) and transfered to colleagues or to the headquarters. And, best of al...
Hi I'm looking for a good ORM for VistaDB database. It's for an small desktop application and it might expand in future. Open source solution will be preferred, but I'm ready to shell out if required. Regards, Vikas ...
Is it possible to use Subsonic with VistaDB? I see it as a supported database for Subsonic 3 on the project website, But can't find a T4 template for it? Will I need to use SR or I can use AR? Vikas ...
I have a database file with the extension "vdb" - presumably this is a VistaDB file - anyone know what to use to open it and access the tables inside? ...
Does VistaDB support 'Update model from Database' feature in EF4? I'm receiving this message: " ... 'System.ArgumentNullException' 'Value Cannot be Null' Parameter name: providerInvariantName" ...
What is the detailed syntax for the 'CREATE DATABASE' statement for VistaDB? The documentation only describes various procedures,functions,operators etc, but nothing on the 'CREATE DATABASE' statement. The 'create database' 'how-to' specifies hard coded values for the page size and other parameters, but can I use an ADO.NET connection ...
I am reading the database schema for VistaDB 4.0 database using the standard ADO.NET 'DbConnection.GetSchema' API. I haven't found a way to obtain the 'Identity' setting for a column? The 'Columns' schema collection doesn't seem to have a column for this and I am not aware of any other collection that I should look into. If it is not po...
Hi, 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 the basic schema I've created. I have an event that adds data that I've been using...
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 versus other technology? UPDATE: VistaDB out of business (the real disadvantage) I have jus...
Hello to everyone, I have 2 different table which is tbl_meter and tbl_machines. I am entering data using tbl_meter every day. I am finding dailiy results with following sql syntax. But I have problem with tbl_machines. There is relation between 2 tables with local_no and machine_no fields. How can I fetch fileds from tbl_machines table...
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? ...
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 ...". I believe that there is something I am missing but not sure where. Code looks fine....