Not logged in : Login

About: Announcement: UDA Release 7.0 Lite Edition ODBC Driver for Sybase and Microsoft SQL Server     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : atom:Entry, within Data Space : associated with source document(s)
QRcode icon

has container
Date Created
Date Modified
  • a544a8b5a94bed8bf354b933f581d4c6
has reply
  • In coming months, we'll be gradually shipping Release 7.0 of all our UDA drivers. This post will be the first of many, describing some of the fixes, changes, and improvements in each driver as they are made available.

    Today, we have the Lite Edition ODBC Drivers for Sybase and Microsoft SQL Server.

    Installation and configuration takes only minutes, by following the documentation which remains available anytime, specifically for this driver on OS X and Windows.

    Release 7.0 licenses are also available for immediate purchase.

    Client Platform Support

    Release 7.0 installers are available for immediate download for Mac and Windows. Builds for Linux and other Unix-like OS will be available soon; please contact us if you have urgent need.

    Release 7.0 supports all 32-bit and 64-bit ODBC client tools and applications, both GUI and command-line, on —

    OS X and OS X Server
    on x86 and x86_64
    Windows and Windows Server
    on x86 and x86_64
    • Yosemite (10.10.x) (x86_64)

    • Mavericks (10.9.x) (x86_64)

    • Mountain Lion (10.8.x) (x86_64)

    • Lion (10.7.x) (x86_64)

    • Windows 8.x (x86, x86_64)

    • Windows 7.x (x86, x86_64)

    • Windows Vista (x86, x86_64)

    • Windows XP (x86, x86_64)

    • Windows Server 2012 R2 (x86_64)

    • Windows Server 2012 (x86_64)

    • Windows Server 2008 R2 (x86_64)

    • Windows Server 2008 (x86, x86_64)

    • Windows Server 2003 R2 (x86, x86_64)

    • Windows Server 2003 (x86, x86_64)

    DBMS Version Support

    The Release 7.0 Lite Edition ODBC Driver supports virtually every version of Microsoft SQL Server and Sybase Adaptive Server in current use, including —

    • Microsoft SQL Server 6.5

    • Microsoft SQL Server 7.0

    • Microsoft SQL Server 2000

    • Microsoft SQL Server 2005

    • Microsoft SQL Server 2008

    • Microsoft SQL Server 2012

    • Microsoft SQL Server 2014

    • Microsoft SQL Azure

    • Sybase SQL Server 4.x

    • Sybase SQL Server 10.x

    • Sybase SQL Server 11.x

    • Sybase Adaptive Server Enterprise (ASE) 11.x

    • Sybase Adaptive Server Enterprise (ASE) 12.x

    • Sybase Adaptive Server Enterprise (ASE) 15.x

    • Sybase SQL Anywhere 6.x

    • Sybase Adaptive Server Anywhere (ASA) 7.x

    • Sybase Adaptive Server Anywhere (ASA) 8.x

    • Sybase Adaptive Server Anywhere (ASA) 9.x

    • Sybase SQL Anywhere 10.x

    • Sybase SQL Anywhere 11.x

    Changes since Release 6.x


    • added support for SPARSE columns in SQLColumns() call

      • added DSN options SHOWSPARSECOLS / ShowSparseCols and Multi-Tier connect option -X )

      • details, based on test table:

        CREATE TABLE tbl_sparse_test 
          ( col1  INT SPARSE
          , col2  INT
        • wildcard query will return only col2 and col3; will not include SPARSE columns. This is standard SQL Server behavior, and it cannot be changed.

          SELECT * 
            FROM tbl_sparse_test

          To include SPARSE columns in results, they must be explicitly SELECTed

          SELECT col1, col2, col3 
            FROM tbl_sparse_test
        • By default, calls to SQLColumns() don't return Sparse Columns. To receive full columns list:

          • via our Lite Edition ODBC driver —

            1. open connection with SHOWSPARSECOLS in DSN connection string, e.g., "DSN=TdsSQL;UID=sa;PWD=sa;SHOWSPARSECOLS=Y;"

            2. SQLColumns (hstmt, NULL, 0, NULL, 0, L"tbl_sparse_test", SQL_NTS, NULL, 0 );

          • via the Microsoft ODBC driver —


            2. SQLColumns (hstmt, L"tempdb", SQL_NTS, L"dbo", SQL_NTS, L"tbl_sparse_test", SQL_NTS, NULL, 0 );

    • added support for new SQL Server datatypes such as datetime2

    • added support for NBCROW token

    • added support for Sybase 15


    • fixed issue with SQL Server BIT datatype

    • fixed memory overwrite error, when DB procedure is called with SQL_PARAM_OUTPUT parameter of CHAR/VARCHAR/LONGVARCHAR

    • fixed issue with VARBINARY datatype and DB procedures

    • fixed issue with converting TIMESTAMP to CHAR/WCHAR

    • fixed datatype info in SQLGetTypeInfo -- new Sybase and MSSQL datatypes were added

    • fixed database catalog and query metadata info for Sybase 15's UNSIGNED INT, UNSIGNED SMALLINT, BIGINT, SYSNAME, LONGSYSNAME

  • Announcement: UDA Release 7.0 Lite Edition ODBC Driver for Sybase and Microsoft SQL Server
is described using
  • 2015-06-23T20:18:08Z
  • Announcement: UDA Release 7.0 Lite Edition ODBC Driver for Sybase and Microsoft SQL Server
links to
  • Announcement: UDA Release 7.0 Lite Edition ODBC Driver for Sybase and Microsoft SQL Server
  • 2015-06-16T21:43:12Z
is made of
is link of
is reply of of
is atom:contains of
is atom:entry of
is container of of
is of
Faceted Search & Find service v1.17_git63 as of Apr 23 2021

Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:       RDF       ODATA       Microdata      About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3322 as of Jun 3 2021, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (30 GB total memory)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2021 OpenLink Software