VistaDB is an Embedded SQL Database Engine for .Net (SQL Server compatible)
Questions tagged [vistadb]
39 questions
0
votes
1 answer
SQL Use Greater/Less Than with like and wildcards
I'm currently a bit stumped on how to implement a certain thing. Basically I have an embedded database(which really hates JOINs, performance-wise) and the requirement of adding a wildcard mechanism to a search field. Currently the search field…
fk2
- 739
- 1
- 14
- 30
0
votes
2 answers
How to do DB backup with VistaDB?
I'm trying to do a XML export of the database with VistaDB.
Unfortuanently, I'm lost.
Here's my code so far:
Dim instance As IVistaDBDatabase
Dim value As System.Int64
SaveFileDialog2.InitialDirectory = "C:\"
Select Case…
Chris
- 149
- 12
0
votes
1 answer
VistaDB - Connection property must be assigned Error
I am getting the following error when I try to update one of the table in my vistadb.
VistaDB.Diagnostic.VistaDBSQLException was caught
HResult=1011
Message=
Error 1011 (Provider v. 5.0.4.1289): Connection property must be assigned Error #1011
Line…
Murali Kothandaraman
- 41
- 2
- 9
0
votes
1 answer
Vistadb Writing SQL For Image DataType
I have recently started a new job and they use Vistadb so I cannot change the software package before people suggest that. I have obtained out of the database a byte[] from a datatype of image that is used in there different systems so its data type…
ZoomVirus
- 615
- 7
- 22
0
votes
1 answer
VistaDB Connection Issue Programmatically using SQLConnection and ConnectionString
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…
Brian Boatright
- 36,294
- 34
- 81
- 102
0
votes
1 answer
VistaDb5 with entityframework 4 error
I am checking the EntityFrameworkBasics sample project which comes with the installation of VistaDB5. When I try to build the project it successfully compiles despite the error message given below:
Error 1 Error 168: A null was returned after…
user1659459
- 65
- 8
0
votes
1 answer
open vistadb vdb file
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?
user23048345
- 3,033
- 7
- 31
- 31
0
votes
1 answer
autocomplete from local database c#
Im kindda stuck here big time, I just cant find the way to resolve this.
My local db is VistaDB. My code works when it comes to top 10 results,but I need to collect everything from the "Pojam" column to show in the textbox and not just the top 10…
user2850503
- 1
- 2
0
votes
1 answer
Vistadb SQL Syntax error
vistadb4 not recognize this sql view script. but it is working with sql2005. is there a solution ? thanks.
SELECT DISTINCT ItemCode, SellingPrice
FROM dbo.SalesPurchases AS a
WHERE (KeyID =
(SELECT TOP (1)…
Hasitha D
- 19
- 2