| Attributes | Values |
|---|
| has container
| |
| Date Created
| - Tue, 20 Nov 2012 21:00:55 GMT
- Fri, 18 Jan 2013 15:31:20 GMT
- Fri, 26 Apr 2013 18:19:35 GMT
- Thu, 11 Jul 2013 21:22:54 GMT
- Tue, 18 Mar 2014 15:54:37 GMT
- Thu, 05 Feb 2015 21:17:51 GMT
|
| described by
| |
| seeAlso
| |
| content
| - Virtuoso for Windows 95/98/NT/2000/XP
Existing Virtuoso 2.7 Users
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.
Before You Start
To ensure a smooth installation, please review the
following checklist before you start the setup program.
Have you downloaded the software?
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 "Download & Evaluation".
Select product "OpenLink Virtuoso: Personal Edition "
From "Product Category" choose "Universal Server"
From "Product" choose "Virtuoso Universal Server"
Select "Database Version"
From "server OS" select "Windows" and click "Next"
Select a release and click "Next"
You will be prompt to login in not already.
Click "Next"
Download the desired component. For example, click the HTTP link for "Multi-Threaded Universal Server (Commercial Edition) for OpenLink Virtuoso 4.x"
Do you have the License file?
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.
Reinstalling Virtuoso?
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
Note:
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
Allocation of TCP/IP ports
The Default database have the following port allocations:
Port Usage
PortUsed by
1111
Default Virtuoso Server port
8889
Default Virtuoso Visual Server Administration Interface HTTP port
By default, the Virtuoso DBMS listens on port 1111.
This port number is 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 Software\Virtuoso 5.0\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
Do you already have an ODBC Data Source Name (DSN) that works?
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.
Getting To Know Your Virtuoso Components
Virtuoso is made up of several components, these components
fall into two distinct categories: Client Components and Server Components.
Client Components Package
These are the components typically used to communicate with
a local or remote Virtuoso server, this includes:
Virtuoso Drivers for ODBC
Virtuoso Drivers for JDBC
ISQL Utility
ISQLO Utility
Documentation
Samples
Server Components
These are the components that service Virtuoso clients,
these include:
Virtuoso Virtual Database Servers for: ODBC based
interfaces - the files "virtuoso-odbc-f" (for Virtuoso Lite)
and "virtuoso-odbc-t" (For Virtuoso Enterprise Edition).
Virtuoso HTTP Server.
Virtuoso System Manager to configure the database
through the HTTP interface.
Installation Steps
You can install Virtuoso in any one of the following
configurations: Stand-Alone, 2-Tier Client-Server, or 3-Tier Client-Server.
Stand-Alone Configuration
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.
Virtuoso Personal Edition Release 5.0 Installation on Windows
Double click on the Virtuoso Personal Edition installer (for example "ntvpz2zz.msi") to run the Windows installer.
Run the installer
The installer Welcome dialog is loaded:
The Welcome Screen
You read the full license agreement information and make sure
that you agree with all the terms and conditions before proceeding
with the installation.
License Agreement
If a license file already exists the installer can place this in the correct location for use.
Browse to the location of your installer file and the installer will use this for the Virtuoso Server. Alternatively
the "Try & Buy" feature of the installer can be used to enable a trial or full license file to be
obtained online.
The License File Location
Choose to obtain a Trial license for an evaluation or enter the shop
site to purchase a full license.
The obtain Trial license screen
Click on the "Download License" button on the right to obtain the
license file immediately. An e-mail will also be sent with details of the license and the location on the ODS account
of the registered user where in can be obtained from at a later date. Once a license file is available on the machine
use the "Browse" button to locate it and the "Set License" button to initialize the Virtuoso
server with this license file.
The Download license screen
Choose the installation type that you want to install.
Setup Type
If the custom option was chosen, the installer prompts for the
Destination folder of the installation.
Choose Destination Location
Select the Product Features to be installed.
Select Components
The Installation is now ready to proceed.
Proceed Installation
The Progress of the installation is indicated in the Status bar.
Status bar
The installation is now complete.
Complete Installation
The installer may prompt for the machine to be reboot if required.
Reboot prompt
Choose to change the "dba" and "dav" administrative
user passwords from their default of "dba" and "dav" respectively to a value of your choice.
Reboot prompt
The Virtuoso Server Welcome page will now be displayed indicating the
server is online. This Web based page can be used for general configuration and usage of the Virtuoso Server.
Reboot prompt
2-Tier Client-Server Configuration
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.
Client Components:
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.
Setup Screens
The installer will now extract and install your Virtuoso Client components
Server Components:
Move the Virtuoso installation archive into a temporary
installation folder on your Server machine.
Choose the Server install option.
Setup Screens
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.
3-Tier Client-Server Configuration
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.
Client Components:
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.
Setup Screens
The installer will now extract and install your Virtuoso Client components
Middle-Tier Server 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.
Setup Screens
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.
Starting Your Virtuoso 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.
Windows NT/2000/XP
You can start your Virtuoso server in one of two ways,
automatically or manually, the default mode configured by your installer is Automatic.
Automatic Startup
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.
Manual Startup
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:
Services Applet
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
Windows 95/98
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.
Automatic Startup
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
Manual Startup
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
Note:
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.
Post-Installation Sanity Check
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.
Creating and Deleting Virtuoso Services
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
Deleting an existing Virtuoso service: virtuoso-odbc-f +service delete -I
Starting a new Virtuoso service manually: virtuoso-odbc-f +service start -I
Showing a list of existing Virtuoso services: virtuoso-odbc-f +service list
Note:
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.
Configuring Virtuoso Client Components
The Virtuoso client components set consists of the following:
Virtuoso Driver for ODBC
Virtuoso Driver for JDBC
Native Virtuoso Interactive SQL Query (ISQL)
ODBC based Interactive SQL Query Utility (ISQLO)
The sections that follow address the configuration and
utilization of each one of these client components separately.
Virtuoso Driver for ODBC
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.
See Also:
the Data Access Interfaces chapter for more detailed information
regarding the Virtuoso ODBC Driver setup
Virtuoso Drivers for JDBC
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.
See Also:
The JDBC Driver section in
the Access Interfaces chapter.
Native Virtuoso Interactive SQL Query (ISQL)
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 [][:]
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.
ODBC based Interactive SQL Query Utility (ISQLO)
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
Note:
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
Default passwords
See the following Quick Start chapter for very important information about
changing the default passwords.
|
| Title
| |
| title
| - Virtuoso for Windows 95/98/NT/2000/XP
|
| created at
| - Wed, 25 Apr 2007 07:07:09 GMT
|
| type
| |
| content:encoded
| -
<H2 CLASS="sect1head">
<A NAME="installwin32">Virtuoso for Windows 95/98/NT/2000/XP</A>
</H2><!-- NEED 15 -->
<H3 CLASS="sect2head">
<A NAME="doyouwannamigrate">Existing Virtuoso 2.7 Users</A>
</H3>
<P>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
<A HREF="#migrate27to30">Migration of Virtuoso from Version 2.7 to Version 3.0</A>
section for more details.</P>
<!-- NEED 15 -->
<H3 CLASS="sect2head">
<A NAME="b4ustart">Before You Start</A>
</H3>
<P>To ensure a smooth installation, please review the
following checklist before you start the setup program.</P>
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="haveudld">Have you downloaded the software?</A>
</H4>
<P>If you have not already done so, please download your copy of OpenLink
Virtuoso from the OpenLink web site. The URL is
<A HREF="http://www.openlinksw.com">http://www.openlinksw.com</A>.
When you visit the site, select "Download & Evaluation". </P>
<OL>
<LI>
<P>Select product "OpenLink Virtuoso: Personal Edition "</P>
</LI>
<LI>
<P>From "Product Category" choose "Universal Server"</P>
</LI>
<LI>
<P>From "Product" choose "Virtuoso Universal Server"</P>
</LI>
<LI>
<P>Select "Database Version"</P>
</LI>
<LI>
<P>From "server OS" select "Windows" and click "Next"</P>
</LI>
<LI>
<P>Select a release and click "Next"</P>
</LI>
<LI>
<P>You will be prompt to login in not already.</P>
</LI>
<LI>
<P>Click "Next"</P>
</LI>
<LI>
<P>Download the desired component. For example, click the HTTP link for "Multi-Threaded Universal Server (Commercial Edition) for OpenLink Virtuoso 4.x"</P>
</LI>
</OL>
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="douhavelic">Do you have the License file?</A>
</H4>
<P>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.</P>
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="reinstvirt">Reinstalling Virtuoso?</A>
</H4>
<P>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]".</P>
<P>On Windows NT/2000/XP you can also shut them down with the following
commands in the Virtuoso\bin directory:</P>
<TABLE BORDER="0" WIDTH="90%">
<TR>
<TD BGCOLOR="#f0f0f0">
<PRE>
virtuoso-odbc-t.exe +service stop
virtuoso-odbc-t.exe +instance myinstance +service stop
virtuoso-odbc-t.exe +instance anotherinstance +service stop
</PRE>
</TD>
</TR>
</TABLE>
<BR />
<TABLE BORDER="1" WIDTH="610" CELLPADDING="5">
<TR>
<TD ALIGN="left">
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="5" WIDTH="600">
<TR>
<TD WIDTH="70" ALIGN="right" VALIGN="top">
<STRONG>Note:</STRONG>
</TD>
<TD ALIGN="left" WIDTH="500">
<P>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.</P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<BR />
<P>You can list the services with their status using:</P>
<TABLE BORDER="0" WIDTH="90%">
<TR>
<TD BGCOLOR="#f0f0f0">
<PRE>virtuoso +service list</PRE>
</TD>
</TR>
</TABLE>
<BR />
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="allocoftcpports">Allocation of TCP/IP ports</A>
</H4>
<P>The Default database have the following port allocations:</P>
<!-- NEED 15 --><BR />
<TABLE border="0" cellspacing="0" cellpadding="2">
<TR>
<TD>
<TABLE BORDER="1" CELLSPACING="1" CELLPADDING="2">
<TR>
<TD bgcolor="#eeeeee">
<B>Port</B>
</TD>
<TD bgcolor="#eeeeee">
<B>Used by</B>
</TD>
</TR>
<TR>
<TD>
<DIV CLASS="para">1111</DIV>
</TD>
<TD>
<DIV CLASS="para">Default Virtuoso Server port</DIV>
</TD>
</TR>
<TR>
<TD>
<DIV CLASS="para">8889</DIV>
</TD>
<TD>
<DIV CLASS="para">Default Virtuoso Visual Server Administration Interface HTTP port</DIV>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR>
<TD COLSPAN="2">
<I>Port Usage</I>
</TD>
</TR>
</TABLE>
<BR />
<P>By default, the Virtuoso DBMS listens on port 1111.
This port number is 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:</P>
<TABLE BORDER="0" WIDTH="90%">
<TR>
<TD BGCOLOR="#f0f0f0">
<PRE>
C:\Program Files\OpenLink Software\Virtuoso 5.0\bin\virtuoso.ini
</PRE>
</TD>
</TR>
</TABLE>
<BR />
<P>To check if a port is in use on NT, you can use the
following command, and review the output:</P>
<TABLE BORDER="0" WIDTH="90%">
<TR>
<TD BGCOLOR="#f0f0f0">
<PRE>
netstat -an | more
</PRE>
</TD>
</TR>
</TABLE>
<BR />
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="prevworkodbcdsn">Do you already have an ODBC Data Source Name (DSN) that works?</A>
</H4>
<P>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.</P>
<!-- NEED 15 -->
<H3 CLASS="sect2head">
<A NAME="knowthywinvirt">Getting To Know Your Virtuoso Components</A>
</H3>
<P>Virtuoso is made up of several components, these components
fall into two distinct categories: Client Components and Server Components.</P>
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="clicomppack">Client Components Package</A>
</H4>
<P>These are the components typically used to communicate with
a local or remote Virtuoso server, this includes: </P>
<UL>
<LI>Virtuoso Drivers for ODBC</LI>
<LI>Virtuoso Drivers for JDBC</LI>
<LI>ISQL Utility</LI>
<LI>ISQLO Utility</LI>
<LI>Documentation</LI>
<LI>Samples</LI>
</UL>
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="srvcomp">Server Components</A>
</H4>
<P>These are the components that service Virtuoso clients,
these include:</P>
<UL>
<LI>
Virtuoso Virtual Database Servers for: ODBC based
interfaces - the files "virtuoso-odbc-f" (for Virtuoso Lite)
and "virtuoso-odbc-t" (For Virtuoso Enterprise Edition).
</LI>
<LI>Virtuoso HTTP Server.
</LI>
<LI>Virtuoso System Manager to configure the database
through the HTTP interface.
</LI>
</UL>
<!-- NEED 15 -->
<H3 CLASS="sect2head">
<A NAME="InstallStepsWin">Installation Steps</A>
</H3>
<P>You can install Virtuoso in any one of the following
configurations: Stand-Alone, 2-Tier Client-Server, or 3-Tier Client-Server.</P>
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="standalone">Stand-Alone Configuration</A>
</H4>
<P>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. </P>
<P>Virtuoso Personal Edition Release 5.0 Installation on Windows</P>
<OL>
<LI>
<P>Double click on the Virtuoso Personal Edition installer (for example "ntvpz2zz.msi") to run the Windows installer.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="Run the installer" SRC="../images/inst/v50pex8601.png" />
</TD>
</TR>
<TR>
<TD>
<I>Run the installer</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>The installer Welcome dialog is loaded:</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="The Welcome Screen" SRC="../images/inst/v50pex8602.png" />
</TD>
</TR>
<TR>
<TD>
<I>The Welcome Screen</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>You read the full license agreement information and make sure
that you agree with all the terms and conditions before proceeding
with the installation.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="License Agreement" SRC="../images/inst/v50pex8603.png" />
</TD>
</TR>
<TR>
<TD>
<I>License Agreement</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>If a license file already exists the installer can place this in the correct location for use.
Browse to the location of your installer file and the installer will use this for the Virtuoso Server. Alternatively
the "Try & Buy" feature of the installer can be used to enable a trial or full license file to be
obtained online.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="The License File Location" SRC="../images/inst/v50pex8604.png" />
</TD>
</TR>
<TR>
<TD>
<I>The License File Location</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>Choose to obtain a Trial license for an evaluation or enter the shop
site to purchase a full license.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="The obtain Trial license screen" SRC="../images/inst/v50pex8605.png" />
</TD>
</TR>
<TR>
<TD>
<I>The obtain Trial license screen</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>Click on the "Download License" button on the right to obtain the
license file immediately. An e-mail will also be sent with details of the license and the location on the ODS account
of the registered user where in can be obtained from at a later date. Once a license file is available on the machine
use the "Browse" button to locate it and the "Set License" button to initialize the Virtuoso
server with this license file.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="The Download license screen" SRC="../images/inst/v50pex8606.png" />
</TD>
</TR>
<TR>
<TD>
<I>The Download license screen</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>Choose the installation type that you want to install.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="Setup Type" SRC="../images/inst/v50pex8607.png" />
</TD>
</TR>
<TR>
<TD>
<I>Setup Type</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>If the custom option was chosen, the installer prompts for the
Destination folder of the installation.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="Choose Destination Location" SRC="../images/inst/v50pex8608.png" />
</TD>
</TR>
<TR>
<TD>
<I>Choose Destination Location</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>Select the Product Features to be installed.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="Select Components" SRC="../images/inst/v50pex8609.png" />
</TD>
</TR>
<TR>
<TD>
<I>Select Components</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>The Installation is now ready to proceed.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="Proceed Installation" SRC="../images/inst/v50pex8610.png" />
</TD>
</TR>
<TR>
<TD>
<I>Proceed Installation</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>The Progress of the installation is indicated in the Status bar.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="Status bar" SRC="../images/inst/v50pex8611.png" />
</TD>
</TR>
<TR>
<TD>
<I>Status bar</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>The installation is now complete.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="Complete Installation" SRC="../images/inst/v50pex8612.png" />
</TD>
</TR>
<TR>
<TD>
<I>Complete Installation</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>The installer may prompt for the machine to be reboot if required.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="Reboot prompt" SRC="../images/inst/v50pex8613.png" />
</TD>
</TR>
<TR>
<TD>
<I>Reboot prompt</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>Choose to change the "dba" and "dav" administrative
user passwords from their default of "dba" and "dav" respectively to a value of your choice.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="Reboot prompt" SRC="../images/inst/v50pex8614.png" />
</TD>
</TR>
<TR>
<TD>
<I>Reboot prompt</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>The Virtuoso Server Welcome page will now be displayed indicating the
server is online. This Web based page can be used for general configuration and usage of the Virtuoso Server.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="Reboot prompt" SRC="../images/inst/v50pex8615.png" />
</TD>
</TR>
<TR>
<TD>
<I>Reboot prompt</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
</OL>
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="TwoTierConfigInst">2-Tier Client-Server Configuration</A>
</H4>
<P>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.</P>
<!-- NEED 15 -->
<H5 CLASS="sect4head">
<A NAME="twotierclicomp">Client Components:</A>
</H5>
<OL>
<LI>
<P>Move the Virtuoso installation archive into a temporary
installation folder on your Client machine</P>
</LI>
<LI>
<P>Choose the Client install option.
No further component selection will be required.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="Setup Screens" SRC="../images/inst/12clienttype.png" />
</TD>
</TR>
<TR>
<TD>
<I>Setup Screens</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>The installer will now extract and install your Virtuoso Client components</P>
</LI>
</OL>
<!-- NEED 15 -->
<H5 CLASS="sect4head">
<A NAME="twotiersrvcomp">Server Components:</A>
</H5>
<OL>
<LI>
<P>Move the Virtuoso installation archive into a temporary
installation folder on your Server machine.</P>
</LI>
<LI>
<P>Choose the Server install option.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="Setup Screens" SRC="../images/inst/13installtype.png" />
</TD>
</TR>
<TR>
<TD>
<I>Setup Screens</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>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.</P>
</LI>
<LI>
<P>The installer will now extract and install your Virtuoso Server components.</P>
</LI>
</OL>
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="ThreeTierConfigInst">3-Tier Client-Server Configuration</A>
</H4>
<P>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. </P>
<!-- NEED 15 -->
<H5 CLASS="sect4head">
<A NAME="threetierclicomp">Client Components:</A>
</H5>
<OL>
<LI>
<P>Move the Virtuoso installation archive into a temporary
installation folder on your Client machine</P>
</LI>
<LI>
<P>Choose the Client install option.
No further component selection will be required.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="Setup Screens" SRC="../images/inst/12clienttype.png" />
</TD>
</TR>
<TR>
<TD>
<I>Setup Screens</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>The installer will now extract and install your Virtuoso Client components</P>
</LI>
</OL>
<!-- NEED 15 -->
<H5 CLASS="sect4head">
<A NAME="threetiermidsrccomp">Middle-Tier Server Components:</A>
</H5>
<P>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.</P>
<OL>
<LI>
<P>Move the Virtuoso installation archive into a temporary
installation folder on your Server machine.</P>
</LI>
<LI>
<P>Choose the Server install option.</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="Setup Screens" SRC="../images/inst/13installtype.png" />
</TD>
</TR>
<TR>
<TD>
<I>Setup Screens</I>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>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.</P>
</LI>
<LI>
<P>The installer will now extract and install your Virtuoso Server components.</P>
</LI>
</OL>
<P>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.</P>
<!-- NEED 15 -->
<H3 CLASS="sect2head">
<A NAME="startvdbms">Starting Your Virtuoso Server</A>
</H3>
<P>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.</P>
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="winnt">Windows NT/2000/XP</A>
</H4>
<P>You can start your Virtuoso server in one of two ways,
automatically or manually, the default mode configured by your installer is Automatic.</P>
<!-- NEED 15 -->
<H5 CLASS="sect4head">
<A NAME="winntautostart">Automatic Startup</A>
</H5>
<P>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.</P>
<!-- NEED 15 -->
<H5 CLASS="sect4head">
<A NAME="winntmanstart">Manual Startup</A>
</H5>
<P>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:</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<IMG TITLE="Services Applet" SRC="../images/virtinst12.gif" />
</TD>
</TR>
<TR>
<TD>
<I>Services Applet</I>
</TD>
</TR>
</TABLE>
<BR />
<P>Click the "Start" or "Stop" button in
order to start or stop a highlighted Virtuoso Server.</P>
<P>To start your Virtuoso servers manually using DOS command
prompts, start a DOS shell and then enter the following command:</P>
<TABLE BORDER="0" WIDTH="90%">
<TR>
<TD BGCOLOR="#f0f0f0">
<PRE>virtuoso-odbc-f +service start</PRE>
</TD>
</TR>
</TABLE>
<BR />
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="win9x">Windows 95/98</A>
</H4>
<P>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.</P>
<!-- NEED 15 -->
<H5 CLASS="sect4head">
<A NAME="win9xautostart">Automatic Startup</A>
</H5>
<P>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.</P>
<P>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):</P>
<TABLE BORDER="0" WIDTH="90%">
<TR>
<TD BGCOLOR="#f0f0f0">
<PRE>C:\Program Files\OpenLink\Virtuoso\bin\virtuoso-odbc-f +service start</PRE>
</TD>
</TR>
</TABLE>
<BR />
<!-- NEED 15 -->
<H5 CLASS="sect4head">
<A NAME="sect4win9xmanstart">Manual Startup</A>
</H5>
<P>You can start your Virtuoso servers manually by
entering the following commands at the DOS command line prompt:</P>
<TABLE BORDER="0" WIDTH="90%">
<TR>
<TD BGCOLOR="#f0f0f0">
<PRE>
virtuoso-odbc-f +service start
virtuoso-odbc-f +instance demo +service start
</PRE>
</TD>
</TR>
</TABLE>
<BR />
<TABLE BORDER="1" WIDTH="610" CELLPADDING="5">
<TR>
<TD ALIGN="left">
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="5" WIDTH="600">
<TR>
<TD WIDTH="70" ALIGN="right" VALIGN="top">
<STRONG>Note:</STRONG>
</TD>
<TD ALIGN="left" WIDTH="500">
<P>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. </P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<BR />
<!-- NEED 15 -->
<H3 CLASS="sect2head">
<A NAME="postinstsanitywin32">Post-Installation Sanity Check</A>
</H3>
<P>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:</P>
<TABLE BORDER="0" WIDTH="90%">
<TR>
<TD BGCOLOR="#f0f0f0">
<PRE>http://localhost:8889
http://localhost:8890
http://a_virtuoso_server.org:8890</PRE>
</TD>
</TR>
</TABLE>
<BR />
<P>See the following Quick Start chapter for further ways to verify the database.</P>
<!-- NEED 15 -->
<H3 CLASS="sect2head">
<A NAME="CreatingDeletingServices">Creating and Deleting Virtuoso Services </A>
</H3>
<P>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:</P>
<P>Adding new Virtuoso Server service: virtuoso-odbc-f +service create -I <your chosen service name></P>
<P>Deleting an existing Virtuoso service: virtuoso-odbc-f +service delete -I <service that you are deleting></P>
<P>Starting a new Virtuoso service manually: virtuoso-odbc-f +service start -I <service name> </P>
<P>Showing a list of existing Virtuoso services: virtuoso-odbc-f +service list</P>
<TABLE BORDER="1" WIDTH="610" CELLPADDING="5">
<TR>
<TD ALIGN="left">
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="5" WIDTH="600">
<TR>
<TD WIDTH="70" ALIGN="right" VALIGN="top">
<STRONG>Note:</STRONG>
</TD>
<TD ALIGN="left" WIDTH="500">
<P>This functionality is only available on Windows NT/2000/XP.</P>
<P>Ensure that the services applet from the control panel is closed while
issuing the above commands to prevent locking.</P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<BR />
<!-- NEED 15 -->
<H3 CLASS="sect2head">
<A NAME="ConfiguringVirtuosoClients">Configuring Virtuoso Client Components</A>
</H3>
<P>The Virtuoso client components set consists of the following:</P>
<UL>
<LI>Virtuoso Driver for ODBC</LI>
<LI>Virtuoso Driver for JDBC</LI>
<LI>Native Virtuoso Interactive SQL Query (ISQL)</LI>
<LI>ODBC based Interactive SQL Query Utility (ISQLO)</LI>
</UL>
<P>The sections that follow address the configuration and
utilization of each one of these client components separately.</P>
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="VirtuosoDriverODBC">Virtuoso Driver for ODBC</A>
</H4>
<P>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.</P>
<P>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.</P>
<TABLE BORDER="1" WIDTH="610" CELLPADDING="5">
<TR>
<TD ALIGN="left">
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="5" WIDTH="600">
<TR>
<TD WIDTH="70" ALIGN="right" VALIGN="top">
<STRONG>See Also:</STRONG>
</TD>
<TD ALIGN="left" WIDTH="500">
<P>the <A HREF="#virtdsnsetup">Data Access Interfaces</A> chapter for more detailed information
regarding the Virtuoso ODBC Driver setup</P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<BR />
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="VirtuosoDriverJDBC">Virtuoso Drivers for JDBC</A>
</H4>
<P>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.</P>
<TABLE BORDER="1" WIDTH="610" CELLPADDING="5">
<TR>
<TD ALIGN="left">
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="5" WIDTH="600">
<TR>
<TD WIDTH="70" ALIGN="right" VALIGN="top">
<STRONG>See Also:</STRONG>
</TD>
<TD ALIGN="left" WIDTH="500">
<P>The <A HREF="#VirtuosoDriverJDBC">JDBC Driver</A> section in
the Access Interfaces chapter.</P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<BR />
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="ISQL">Native Virtuoso Interactive SQL Query (ISQL)</A>
</H4>
<P>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.</P>
<P>The command line format for executing this utility is: </P>
<TABLE BORDER="0" WIDTH="90%">
<TR>
<TD BGCOLOR="#f0f0f0">
<PRE>
isql [<hostname>][:<port#>]</PRE>
</TD>
</TR>
</TABLE>
<BR />
<P>The steps that follow guide you through the process of
using ISQL to verify your Virtuoso installation:</P>
<OL>
<LI>
<P>Open up a DOS shell</P>
</LI>
<LI>
<P>Move into the "bin" sub-directory of your
Virtuoso installation</P>
</LI>
<LI>
<P>Type the following command: isql</P>
<P>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</P>
</LI>
<LI>
<P>At the ISQL command line prompt type in the following
command: </P>
<TABLE BORDER="0" WIDTH="90%">
<TR>
<TD BGCOLOR="#f0f0f0">
<PRE>
tables ;</PRE>
</TD>
</TR>
</TABLE>
<BR />
<P>This will produce a list of tables in the current Virtuoso database, you can also enter
other SQL statements e.g.: </P>
<TABLE BORDER="0" WIDTH="90%">
<TR>
<TD BGCOLOR="#f0f0f0">
<PRE>
select * from Customers</PRE>
</TD>
</TR>
</TABLE>
<BR />
<P>This will produce a listing of records in the "Customers" table.</P>
</LI>
<LI>
<P>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.</P>
</LI>
</OL>
<!-- NEED 15 -->
<H4 CLASS="sect3head">
<A NAME="ISQLO">ODBC based Interactive SQL Query Utility (ISQLO)</A>
</H4>
<P>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: </P>
<OL>
<LI>
<P>Open up a DOS shell</P>
</LI>
<LI>
<P>Move into the "bin" sub-directory of your
Virtuoso installation</P>
</LI>
<LI>
<P>Type the following command :</P>
<TABLE BORDER="0" WIDTH="90%">
<TR>
<TD BGCOLOR="#f0f0f0">
<PRE>
isqlo <enter a valid ODBC Data Source Name></PRE>
</TD>
</TR>
</TABLE>
<BR />
<TABLE BORDER="1" WIDTH="610" CELLPADDING="5">
<TR>
<TD ALIGN="left">
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="5" WIDTH="600">
<TR>
<TD WIDTH="70" ALIGN="right" VALIGN="top">
<STRONG>Note:</STRONG>
</TD>
<TD ALIGN="left" WIDTH="500">
<P>If your DSN contains spaces you will need to enclose it within
double quotes when passing it as a parameter to ISQLO</P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<BR />
</LI>
<LI>
<P>Enter any valid SQL at the ISQLO command line prompt.</P>
</LI>
<LI>
<P>You can also use this utility from within the Virtuoso Conductor</P>
</LI>
</OL>
<!-- NEED 15 -->
<H3 CLASS="sect2head">
<A NAME="defpasschgwin">Default passwords</A>
</H3>
<P>See the following Quick Start chapter for very important information about
<A HREF="#defpasschange">changing the default passwords</A>.</P>
|
| is topic
of | |
| is container of
of | |
![[RDF Data]](/fct/images/sw-rdf-blue.png)
![[cxml]](/fct/images/cxml_doc.png)
![[csv]](/fct/images/csv_doc.png)
![[text]](/fct/images/ntriples_doc.png)
![[turtle]](/fct/images/n3turtle_doc.png)
![[ld+json]](/fct/images/jsonld_doc.png)
![[rdf+json]](/fct/images/json_doc.png)
![[rdf+xml]](/fct/images/xml_doc.png)
![[atom+xml]](/fct/images/atom_doc.png)
![[html]](/fct/images/html_doc.png)