Ask a question?
  • Contact Us
  • Support Case System
  • Support Forum

OpenLink ODBC drivers for Microsoft SQL Server

Versions

OpenLink ODBC driver for Microsoft SQL Server supports SQL Server versions 6.x through 2012.

Driver Architecture

OpenLink's SQL Server ODBC drivers are available in a choice of three formats to suit your network infrastructure.

  • Single-Tier (Express) More Information / Download

    A single-tier driver: easy installation on Mac OS X Universal and Microsoft Windows platforms.

  • Single-Tier (Lite) More Information / Download

    A single-tier driver: simple and quick to deploy; installs on the client computer only; uses a database-specific communications layer

  • Multi-Tier (Enterprise Edition) More Information / Download

    A multi-tier driver with configurable performance, scalability and security for Enterprise users; typically components are installed on both the client and database-server hosts.

Features

Feature / Architecture Single-Tier
(Express)
Single-Tier
(Lite)
Multi-Tier
(Enterprise Edition)
More Information and Download More Information and Download More Information and Download
Microsoft Windows and Mac OS X Availability Y Y Y
Linux, Solaris and other Unix OS Availability N Y Y
Single component client-only installation Y Y N
Multiple components installed on clients and server computers N N Y
Requires database-specific comms layer on client N Y N
SQL-92 Conformance Y Y Y
ODBC Core, Level 1 and Level 2 Compliance Y Y Y
Unicode Support Y Y Y
Support for Built-in Client-side Tracing Y Y Y
Configurable performance N Y Y
Configurable for Scalability N N Y
Configurable Security N N Y
Ability to restrict connections based on application, IP address, username, requested database N N Y
Ability to override connection parameters on the server N N Y
Operating-system user authentication N N Y
Auto-Discovery of SQL Server instances N Y Y
Database mirroring compatibility N Y Y
MS DTC N N Y
Multiple Active Result Sets (MARS) N Y Y
Named Instance Support N Y Y
Snapshot transaction isolation levels N Y Y
SQL Server Express Support N Y Y
XA-Based Two-Phase Commit N N Y

Applications

Our ODBC driver for SQL Server allows you to connect desktop applications such as Microsoft Access and Excel/Query, OpenOffice, reporting tools such as Crystal Reports/Business Objects, and more, to your backend database.

Additionally, our ODBC driver facilitates database connectivity for developers programming in scripting languages such as Perl (using DBI and DBD::ODBC), Python (using mxODBC or PyODBC), Ruby, SoftIntegration's Ch language, C and using the Microsoft Visual Studio 2005 IDE.

Download

For a guided download, use our Solution Wizard.

If you know what components you need, you can proceed via the Download Wizard.

License Offers

Current ODBC drivers for Microsoft SQL Server offers.