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 : www.openlinksw.com associated with source document(s)
QRcode icon
http://www.openlinksw.com/describe/?url=http%3A%2F%2Fwww.openlinksw.com%2Fdataspace%2Fuda%2Fweblog%2Fuda%2527s%2520BLOG%2520%255B135%255D%2F1848

AttributesValues
has container
Date Created
maker
Date Modified
link
id
  • a544a8b5a94bed8bf354b933f581d4c6
has reply
content
  • 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

    Additions

    • 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
          , col3  XML COLUMN_SET FOR ALL_SPARSE_COLUMNS 
          )
        
             
            
        • 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 —

            1. SQLSetStmtAttr (hstmt, SQL_SOPT_SS_NAME_SCOPE, (SQLPOINTER)SQL_SS_NAME_SCOPE_EXTENDED, SQL_IS_SMALLINT);

            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

    Fixes

    • 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

Title
  • Announcement: UDA Release 7.0 Lite Edition ODBC Driver for Sybase and Microsoft SQL Server
is described using
atom:source
atom:updated
  • 2015-06-23T20:18:08Z
atom:title
  • Announcement: UDA Release 7.0 Lite Edition ODBC Driver for Sybase and Microsoft SQL Server
links to
atom:author
label
  • Announcement: UDA Release 7.0 Lite Edition ODBC Driver for Sybase and Microsoft SQL Server
atom:published
  • 2015-06-16T21:43:12Z
http://rdfs.org/si...ices#has_services
type
is made of
is link of
is reply of of
is atom:contains of
is atom:entry of
is container of of
is http://rdfs.org/si...vices#services_of 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.3320 as of Mar 14 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