Before you can link a table into Virtuoso, you need to configure
an ODBC datasource. It is quite likely that you already have ODBC
data sources defined. If so, you can skip this part of the
If you do not have any data sources defined, you should
configure your datasource using an appropriate ODBC driver. The
ODBC driver may come from the database vendor or a third-party
middleware vendor, such as OpenLink Software. You will need to
configure your ODBC datasource in accordance with the directions
from your driver vendor.
In this part of the tour, we show sample DSN configuration
information for some database vendor drivers. These examples of
working data sources are not meant to replace the instructions from
the driver vendor. In your specific installation other parameters
may be necessary.
To define ODBC data sources on Windows XP/95/98/NT, in the
Control Panel go to Administrative Tools and then click the Data
Sources (ODBC) icon.
This first datasource uses OpenLink Generic ODBC Driver V6.0 to
create DSN to a MySQL 5.x database.
Figure3.7.OpenLink Mutli Tier
DSN Configuration with database MySQL 5.x
The next example is an Informix 7 datasource using the driver
from Informix Software, Inc.
Figure3.8.Informix Driver DSN
The next few images show a Microsoft SQL Server 6.5 datasource
using the Microsoft Corporation SQL Server driver.
Figure3.9.MS SQL Server DSN
Figure3.10.MS SQL Server DSN
Figure3.11.MS SQL Server DSN
Figure3.12.MS SQL Server DSN
Figure3.13.MS SQL Server DSN
Finally, review the configuration information for your default
local Virtuoso datasource, named "Local
DSNs can be created and configured within the Virtuoso
Conductor. Go to "Database", then to "External Data Sources" and
then go to "Configure Data Sources" tab. Click the "Add System
DSN", or "Add User DSN", or "Add File DSN" button.