Database Connections

This section deals with topics relating to importing data directly into Visokio applications from relational database tables/views using the Database Connection wizard and ODBC/JDBC standard protocols.

Note: Topics related to importing data from files in various formats, including files exported from relational databases, are covered in the section on importing and exporting to/from data files .

Contents:

ODBC & JDBC Introduction- two standard ways of connecting to relational databases, these options are sufficient for most solutions

Connecting to Databases- examples of connections with typical relational databases from various vendors

DSN-less ODBC- method of connecting multiple machines on a network without the administrative overhead of configuring the data source on each machine