Virtuoso Client Interfaces
ODBC
ODBC is Virtuoso's native client API. Virtuoso supports all ODBC 2.0 and 3.5 features on Windows and Unix, in both 32- and 64-bit variants of the API. The ODBC implementation is extensively tested with all major Windows ODBC applications. The implementation has array parameters for bulk operations, scrollable cursors, positioned operations etc. The Windows ODBC driver supports the MS DTC distributed transaction related connection options.
JDBC
Virtuoso has a pure Java JDBC driver. The driver is JDBC 3.0 compatible, supporting connection pooling, XA interfaces for JTA, scrollable cursors, array parameters etc.
Scrollable Cursors
Virtuoso has built-in server side support for scrollable cursors. Static, keyset-driven and dynamic cursors are supported. All cursor types support bookmarks and a single cursor can survive multiple transactions. Forward-only cursors also keep their position across commits and rollbacks. Scrollable cursors support optimistic concurrency for positioned updates/deletes.
ADO .NET
Virtuoso has a pure ADO.NET 1.1 data-provider. This works with both the Windows CLR and Mono on Linux and supported Unix platforms.
OLE/DB
Virtuoso has a native OLE/DB provider for Win32. This has been tested with Microsoft Visual Studio, Microsoft SQL Server and other OLE/DB applications. However, OLE/DB is not the recommended data access interface, unless existing applications already use it.
Tested With
- Microsoft Office Suite, Visual Studio, Access, Excel on Windows and Mac
- Perl DBI
- PHP
- Others
