OpenLink ODBC Driver for Microsoft SQL Server (Express Edition) Pre-Installation Requirements

Pre-Installation Requirements for Windows Clients

DBMS Requirements

You need to know a variety of information pertaining to your Microsoft SQL Server DBMS:

• Microsoft SQL Server listen port
  
• Microsoft SQL Server database name
  
• Microsoft SQL Server database server hostname or IP address

Software Requirements

• You need to ensure that you have a functional JVM (JAVA installation). You can obtain this software from Sun Microsystem's http://www.java.com Website.

Configuration Requirements

• You will need to ensure that the path to "jvm.dll" is configured in your %Path% Environment Variable.
  
  To do this, proceed as follows --
  
  1. "Start" -> "Control Panel" -> "System"
     
  2. Select the "Advanced" tab
     
  3. Select the "Environment Variables" button
     
  4. Locate and select the environment variable named "Path" in the "System variables" pane
     
  5. Select "Edit" which will bring up a new dialog containing "Variable name" and "Variable value" fields
     
  6. Append the path to "jvm.dll" to the end of the already present "Variable value" field taking care not to delete anything that is already present.
     
     So, typically you should be appending text along the lines of --
     
     ;C:\Program Files\Java\jre1.6.0_03\bin\client
     
     NOTE1: Multiple paths are delimited by a semi-colon ';'
     NOTE2: You should specify the path to the directory containing "jvm.dll" only which does not include the filename!
     
  7. Finally, select "OK" to accept the changes.

Proceed to Installation Documentation: Install & Configure Microsoft SQL Server Express Edition Drivers (Windows)