You can migrate your existing Virtuoso servers to 3.0 using the migration utility. The Virtuoso database file structure has been considerably altered between versions. Please consult the Migration of Virtuoso from Version 2.7 to Version 3.0 section for more details.
To ensure a smooth installation, please review the following checklist before you start the setup program.
If you have not already done so, please download your copy of OpenLink Virtuoso from the OpenLink web site. The URL is http://www.openlinksw.com. When you visit the site, select "Software availability and download".
The Windows file is a single executable for example ntvez30z.exe
The server will need a license file, and this is automatically delivered by email as part of the download process. It is therefore important to supply a valid email address. The installer will prompt for the license file location.
If you are reinstalling Virtuoso, you must first shutdown any additional database servers you have configured on non default ports. The databases on port 1111 and 1112 will automatically be stopped during the install process. On Windows NT/2000/XP, go to the services applet in the Control Panel. There you can stop services that appear with names of the form "OpenLink Virtuoso DBMS Server [instance name]".
On Windows NT/2000/XP you can also shut them down with the following commands in the Virtuoso\bin directory:
virtuoso-odbc-t.exe +service stop virtuoso-odbc-t.exe +instance myinstance +service stop virtuoso-odbc-t.exe +instance anotherinstance +service stop
There is an alternative executable available for Virtuoso called: virtuoso-odbc-f.exe, which you may have installed. This version is designed for versions of Windows that offer no native threading support such as Windows 98, and offers no advantages over virtuoso-odbc-t.exe for Windows NT/2000/XP.
You can list the services with their status using:
virtuoso +service list
The Default and Demo databases have the following port allocations:
Port | Used by |
---|---|
1111 | Default Virtuoso Server port |
8889 | Default Virtuoso Visual Server Administration Interface HTTP port |
1112 | Demo Virtuoso Server port |
8890 | Demo Virtuoso Visual Server Administration Interface HTTP port |
During the installation you will be prompted for the HTTP port number on which the Virtuoso System manager will listen. If the port is already in use, you will encounter problems, and should choose another free port when you are prompted.
By default, the Virtuoso DBMS listens on port 1111 and the Demo database on 1112. These port numbers are not selectable at install time. If the port is currently in use by another server then after the installation completes you will need to change the port number in the Local Virtuoso ODBC DSN that is created during the installation process, and also in the following file:
C:\Program Files\OpenLink\Virtuoso\bin\virtuoso.ini
To check if a port is in use on NT, you can use the following command, and review the output:
netstat -an | more
The Virtual Database aspects of the Virtuoso for ODBC assumes that you already have an ODBC driver on your machine from a database vendor, OpenLink Software, or from another 3rd party vendor. It is a useful sanity-check to ensure that you have an ODBC System Data Source Name (DSN) on your machine, and that it successfully connects to your database, and that it retrieve data. Any ODBC compliant tool can be used to test that your ODBC Data Source Name (DSN) works, such as the sample application we provide - C++ Demo32, and that it is sufficiently robust to operate with Virtuoso. Virtuoso is ODBC Driver Independent and certified to work with any drivers that are ODBC level 1 or higher.
Virtuoso is made up of several components, these components fall into two distinct categories: Client Components and Server Components.
These are the components typically used to communicate with a local or remote Virtuoso server, this includes:
These are the components that service Virtuoso clients, these include:
You can install Virtuoso in any one of the following configurations: Stand-Alone, 2-Tier Client-Server, or 3-Tier Client-Server.
In this scenario you have one machine making up your entire solution, which implies that your Applications, Virtuoso's client and server components, and the back end database engine(s) that you want to access via Virtuoso all reside on the same machine.
Run the installer program, for example "ntvez30z.exe"
The install engine will load.
![]() |
This installer might have been compiled for an older version of the installer engine than the one on your system. This will be the case on an XP system without the Service Pack 1. Just confirm OK and continue with installation. It is not a serious problem.
![]() |
Follow the installers on-screen instructions.
![]() |
You read the full license agreement information and make sure that you agree with all the terms and conditions before proceeding with the installation.
![]() |
Choose the installation type that you want to install. The "Client Only" option is for installing other client machines that will be used to access Virtuoso remotely, and so do not need the database installed.
![]() |
You can transparently integrate Virtuoso with various hosting environments. Your system may show a subset of the available environments that are listed in the figure below.
![]() |
Choose the destination directory for the installation. The installer will create the installation structure below this.
![]() |
If you have already got files at this location, you will be warned.
![]() |
Select the components that you want to install. Each selected item will have a tick in the tick-box. These are the only items that will be installed.
![]() |
This warning may appear to inform you that the Virtuoso installer cannot find the Microsoft SMTP service. If you will not be using the SMTP features of Virtuoso this message can be ignored. If you will be using an alternative SMTP server possibly on another machine you can ignore this message. The installation will proceed in either case.
![]() |
If you are installing to a directory that contained a previous installation of Virtuoso the installer may find that you already a demo database .db file. This prompt confirms whether you want it replaced.
![]() |
The default database server requires a valid license file (virtuoso.lic) before it will successfully start. This file is usually delivered by email. If you are not in possession of a license file at this time then you can install it later manually.
![]() |
Use this dialog to locate the license file that you wish to use. If you do not have a license file you will need to install it later, in which case you can cancel this dialog.
![]() |
After the installation has completed you may want one of the installed Virtuoso servers to be started. Choose the appropriate action.
![]() |
Virtuoso is installed as a Windows Service which can be started manually or automatically at boot time. These options let you choose which.
Choose the server variant you wish to use for the default server. The list will only show supported environments as indicated earlier.
![]() |
Choose the server variant you wish to use for the demo server. The list will only show supported environments as indicated earlier.
![]() |
![]() |
Shortcuts to the program and documentation will be contained under a subdirectory of the Start Menu. Choose the name of the directory.
![]() |
Press Next to begin copying files or press Back to change any of the settings of the installer.
![]() |
Before any files can be copied the installer must make sure that there are now running Virtuoso services that will lock files that must be overwritten.
![]() |
This will give an indication of the progress of the file copying process.
![]() |
The Virtuoso includes a web server that can be used for administering the server remotely. You must choose a free TCP/IP port number for the web server listener to use. This is for the default Virtuoso server.
![]() |
The Virtuoso Default server listens on a specific port for commands. You must choose a free TCP/IP port number for this.
![]() |
Set the Administration password for the Default Virtuoso Server. Repeat the password to make sure you enter it correctly.
![]() |
Set the DAV password for the Default Virtuoso Server. Repeat the password to make sure you enter it correctly.
![]() |
If the Demo database was selected then this is configured in a similar way to the Default database. Set the Admin interface HTTP port.
![]() |
Set the port for the Demo server.
![]() |
Set the Administration password for the Demo Virtuoso Server. Repeat the password to make sure you enter it correctly.
![]() |
Set the DAV password for the Demo Virtuoso Server. Repeat the password to make sure you enter it correctly.
![]() |
As per your selection earlier, Virtuoso services will now be started.
![]() |
The final confirmation of the completion of the installation. You may need to reboot the machine for the client drivers to be correctly installed.
![]() |
If a server was started during the install, then the Administration page is shown in a web browser.
![]() |
In this scenario you have two logically distinct machine types making up your total solution, one machine hosts your Applications and Virtuoso client components, while the other hosts your Virtuoso and back-end Database Servers. This installation configuration format will allow Windows client machines to communicate with non Windows server machines running Virtuoso, it also allows Virtuoso clients on non Windows client machines to connect to Virtuoso servers on Windows server machines.
Move the Virtuoso installation archive into a temporary installation folder on your Client machine
Choose the Client install option. No further component selection will be required.
![]() |
The installer will now extract and install your Virtuoso Client components
Move the Virtuoso installation archive into a temporary installation folder on your Server machine.
Choose the Server install option.
![]() |
At the component selection, uncheck the "Virtuoso Drivers for ODBC" and "Virtuoso Drivers for JDBC" and the "Samples" check-boxes since you are only installing Virtuoso's Server components on this machine.
The installer will now extract and install your Virtuoso Server components.
In this scenario you have three logically distinct machine types making up your total solution, the first machine hosts your Applications and Virtuoso client components (Client Machine), the second hosts your Virtuoso server, (Middle Tier Server Machine) and the third machine your back end Database Server (Database Server Machine). This installation configuration format will allow Windows client machines to communicate with non Windows middle-tier server machines running Virtuoso, as well as allowing Virtuoso clients on non Windows client machines to connect to Virtuoso servers on windows based middle-tier server machines.
Move the Virtuoso installation archive into a temporary installation folder on your Client machine
Choose the Client install option. No further component selection will be required.
![]() |
The installer will now extract and install your Virtuoso Client components
You need to install both the Virtuoso client and server components on this machine. This is due to the fact that in many cases this server will double as an Application Server, which entails having clients connecting to an application service that uses Virtuoso for data access.
Move the Virtuoso installation archive into a temporary installation folder on your Server machine.
Choose the Server install option.
![]() |
At the component selection, uncheck the "Sample Application" check-box then the "Virtuoso Driver for ODBC" and "Virtuoso Drivers for JDBC" check-boxes since you are only installing Virtuoso's Server components on this machine.
The installer will now extract and install your Virtuoso Server components.
You will not need to install anything on the remote database server since you will be connecting to remote database either via ODBC or Native Drivers installed on this Server.
Due to subtle differences between Windows 95/98 and Windows NT it is necessary to address the issue of starting and stopping your Virtuoso server for each one of these Windows variants separately.
You can start your Virtuoso server in one of two ways, automatically or manually, the default mode configured by your installer is Automatic.
Your Virtuoso servers (default and demonstration databases) are configured at installation time as "Automatic Startup" services. Thus, rebooting your machine after installation is all that is required in order for your Virtuoso servers to be ready to start receiving connections from client applications. The service is actually started during the installation, however some files may be locked, so a reboot is required to complete the install.
You can manually start your Virtuoso server in one of two ways, either via the "services" control panel applet or from within a DOS shell. When doing this via the "Services" control panel Applet you need to simply open up your control panel and click on the "services" applet. This will present you with a screen similar to the one below:
![]() |
Click the "Start" or "Stop" button in order to start or stop a highlighted Virtuoso Server.
To start your Virtuoso servers manually using DOS command prompts, start a DOS shell and then enter the following command:
virtuoso-odbc-f +service start
You can start your Virtuoso server under Windows 95/98 in one of two ways, automatically or manually, the default mode configured by your installer is Automatic.
Your Virtuoso servers (default and demonstration databases) are configured at installation time as "Automatic Startup" services. Thus, rebooting your machine after installation is all that is required in order for your Virtuoso servers to be ready to start receiving connections from client applications.
If Virtuoso does not start automatically on Windows 95/98 after installation you will need to add the following line to the system's "autoexec.bat" file (assuming you have installed Virtuoso using the installers default installation folder):
C:\Program Files\OpenLink\Virtuoso\bin\virtuoso-odbc-f +service start
You can start your Virtuoso servers manually by entering the following commands at the DOS command line prompt:
virtuoso-odbc-f +service start virtuoso-odbc-f +instance demo +service start
If you encounter a "Program Not Found" error this is because your Virtuoso installation's "bin" sub-directory is not part of your PATH environment variable.
A quick way to check that the database is running, is to point a browser to the http port. The following example URLs will show the System Manager for the default, and the demo Virtuoso databases:
http://localhost:8889 http://localhost:8890 http://a_virtuoso_server.org:8890
See the following Quick Start chapter for further ways to verify the database.
At sometime you may need to have multiple Virtuoso server processes running on your Windows servers or simply need to add or delete existing Virtuoso servers that have been registered with the "Services" control panel applet. You do this by executing the following commands:
Adding new Virtuoso Server service: virtuoso-odbc-f +service create -I <your chosen service name>
Deleting an existing Virtuoso service: virtuoso-odbc-f +service delete -I <service that you are deleting>
Starting a new Virtuoso service manually: virtuoso-odbc-f +service start -I <service name>
Showing a list of existing Virtuoso services: virtuoso-odbc-f +service list
This functionality is only available on Windows NT/2000/XP.
Ensure that the services applet from the control panel is closed while issuing the above commands to prevent locking.
The Virtuoso client components set consists of the following:
The sections that follow address the configuration and utilization of each one of these client components separately.
The Virtuoso Driver for ODBC conforms to both the ODBC 1.x,2.x,and 3.x versions of the ODBC specification, it implements Core, Level 1, Level 2, and Extensions functionality. This driver enables you to communicate with local or remote Virtuoso servers across any combination of platforms supported by Virtuoso.
At installation time two ODBC data source names (DSN's) are created with default values by the Virtuoso installer, the first DSN named "Local Virtuoso" provides a link to a local default Virtuoso database server instance, while the other named "Local Virtuoso Demo" provides a link to a local Virtuoso server for the Virtuoso demonstration database.
the Data Access Interfaces chapter for more detailed information regarding the Virtuoso ODBC Driver setup
The Virtuoso Drivers for JDBC are available in "jar" file formats for the JDBC 1.x, JDBC 2.x and JDBC 3.x JDBC specifications. These are Type 4 Drivers implying that utilization is simply a case of adding the relevant "jar" file to your CLASSPATH and then providing an appropriate JDBC URL format in order to establish a JDBC session with a local or remote Virtuoso server. It is important to note that when you make a JDBC connection to a Virtuoso Server, you do also have access to Native and External Virtuoso tables. Thus, you actually have a type 4 JDBC Driver for any number of different database types that have been linked into Virtuoso.
The JDBC Driver section in the Access Interfaces chapter.
To assist you with the use of Virtuoso an interactive SQL interpreter utility called "ISQL" is bundled with all Virtuoso installations. This utility allows you to enter and execute SQL statements from a command line prompt against a local or remote Virtuoso server.
The command line format for executing this utility is:
isql [<hostname>][:<port#>]
The steps that follow guide you through the process of using ISQL to verify your Virtuoso installation:
Open up a DOS shell
Move into the "bin" sub-directory of your Virtuoso installation
Type the following command: isql
This will connect you to the default Virtuoso server at port "1111", if you want to connect to your demonstration Virtuoso database (which listens at port 1112 by default) then enter: isql 1112
At the ISQL command line prompt type in the following command:
tables ;
This will produce a list of tables in the current Virtuoso database, you can also enter other SQL statements e.g.:
select * from Customers
This will produce a listing of records in the "Customers" table.
If you are not able to perform these task that it implies that your Virtuoso database server is not running or that it has not been installed properly.
In addition to a Native ISQL utility, your Virtuoso installation includes an ODBC based version of "ISQL" called "ISQLO", this enable you to connect to ODBC DSN's rather than Virtuoso only. To use this program perform the following steps:
Open up a DOS shell
Move into the "bin" sub-directory of your Virtuoso installation
Type the following command :
isqlo <enter a valid ODBC Data Source Name>
If your DSN contains spaces you will need to enclose it within double quotes when passing it as a parameter to ISQLO
Enter any valid SQL at the ISQLO command line prompt.
You can also use this utility from within the Virtuoso Conductor
See the following Quick Start chapter for very important information about changing the default passwords.
Previous
Contents of Installation Guide |
Chapter Contents |
Next
Virtuoso for Linux |