Knowledge Base
Vanatec engineers provide hands-on information to support you become productive using Vanatec OpenAccess.
How to work with 2 (or more) different databases
The attached sample shows how to do it and implement the snippets from the programmers guide.More...
Open the same database with different users
Here is a small code snippet how to open the same database with different users. More...
Standalone OQL Query Browser
Some customers inquired about having a non-modal query browser window.More...
Visual Studio 2003 doesn't start after installing OpenAccess
We saw such a behavior in an old 3.5 version of our product; we installed a wrong registry entry with the result that the Visual Studio did not start at all. That should not be the case anymore, but nobody knows. These are the steps to... More...
Microsoft SQL Server 2000 Desktop Edition (MSDE) Installation
5 easy steps to install a MSDE SQL Server 2000 on your machine – You can develop your Vanatec OpenAccess application using the Microsoft SQL Server 2000 Desktop Edition as the database. It’s easy to use and best of all it’s free. The following steps describe how to install the MSDE for use with Vanatec OpenAccess. More...
Network error IOException while trying to connect to MSDE
If you receive a Network error IOException while trying to use VOA with MSDE, firstly please check if you have enabled SQL authorization and TCP/IP access, also please check whether you have installed MSDE correctly to work with VOA. More...
Using a XMLSerializer with Generics and persistent objects
The XMLSerializer class won’t support IList<>. This article shows how to serialize persistent objects with IList<> members. More...
Dealing with Interfaces
In some cases, it is helpful to separate information access in an interface. In most cases, -times interfaces are only used in the context of user interfaces but it is also useful to use interfaces in the context of persistent classes. More...
Handling m:n relation with additional link information
OpenAccess can handle collections of persistent capable objects. Both one-to-many (1:n) and many-to-many (m:n) type of relations are supported.
To maintain an m:n relation between 2 classes, say A and B, OpenAccess uses a join table. This join table stores the PK values of the related objects.
In some cases the user might have some additional data pertaining to each m:n record. Such cases cannot be handled by the built-in join table mechanism. More...
SQL and Stored Procedures with OpenAccess
Here you will find a sample how to use SQL directly and stored procedures with OpenAccess.
More
| 
