# 3. Quick Start & Tours

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Quick Start & Tours
Where to Start
Client Connections
Virtual Database Server
Web Server
WebDAV
Web Services
Exposing Persistent Stored Modules as Web Services
VSMX - Virtuoso Service Module for XML
SQL to XML
NNTP
Dynamic Web Pages
VSP Examples
Third-Party Runtime Typing, Hosting & User Defined Types
Troubleshooting Tips
General Tips DBMS Server will not start Case Mode

## 3.14. Troubleshooting Tips

### 3.14.1. General Tips

The following sections are some common faults and tips. For a complete list of troubleshooting tips, please visit sources that are listed in the Product Support section of the Appendix.

### 3.14.2. DBMS Server will not start

If the Virtuoso DBMS server won't start, there could be 3 reasons.

- It is already running
- It died earlier
- It terminated normally earlier, but the virtuoso.lck file was not deleted

When the DBMS server starts up, it creates a file in the bin directory named "virtuoso.lck". If this file is present, a new instance cannot run. If you are certain that the DBMS isn't running, then you can delete the virtuoso.lck file and then start it from the Services icon in the Control Panel, or by using the command "virtuoso +service start" in the virtuoso directory. You can check if virtuoso is running from the Task Manager, and you can shut it down using the command "virtuoso +service stop".

Figure: 3.14.2.1. Command Prompt

### 3.14.3. Case Mode

Whenever a database object is referenced, all names (schema, owner, table and column) should preferably be placed in double-quotes, exactly as it appears in the catalog. This way, the object name in the Virtuoso catalog will be correctly referenced. If names are not quoted, then the case of the object name will be determined by the value of the CaseMode property in the virtuoso.ini file. The default mode is case sensitive (CaseMode = 1). This means that all unquoted objects names will be processed exactly as supplied. This may result in messages indicating that an object could not be found. If CaseMode is set to 0, then all objects will be translated to upper case. When using certain tools such as Microsoft Query (which is used by Microsoft Excel) object references are not enclosed in quotes. As a result, it may be necessary to change from CaseMode=1 to CaseMode=0, or vise-verse before starting up the DBMS if the application that you use does not enclose identifiers in double quotes. Virtuoso itself will always use the object names that were identified when the table was attached when it communicates with a back-end database.

The following table describes when an identifier name will match the catalog entry.

Table: 3.14.3.1. Case mode options
CaseMode | Identifiers in Virtuoso Catalog | Unquoted Identifiers In Query | Result
--- | --- | --- | ---
0 - Case Sensitive | Lower/Mixed case | Lower/Mixed case | Will match
0 - Case Sensitive | Lower/Mixed case | Upper case | Will not match
0 - Case Sensitive | Upper case | Lower/Mixed case | Will not match
0 - Case Sensitive | Upper case | Upper case | Will match
1 - Translate to Upper | Lower/Mixed case | Lower/Mixed case | Will not match
1 - Translate to Upper | Lower/Mixed case | Upper case | Will not match
1 - Translate to Upper | Upper case | Lower/Mixed case | Will match
1 - Translate to Upper | Upper case | Upper case | Will match

Figure: 3.14.3.2. Virtuoso.ini file in notepad

Previous Third-Party Runtime Typing, Hosting & User Defined Types | Chapter Contents | Next Contents of Sample ODBC & JDBC Applications