Downloads Try Thriftly
Downloads Try Thriftly
Group 762

Migrate and run DataFlex applications with Oracle, MS SQL Server, PostgreSQL, MySQL &  MariaDB.

flex2Crystal

Stuck in Crystal XI?  Upgrade and use the latest versions of Crystal Reports with DataFlex applications. 

BTR2SQL

Convert from Btrieve / P.SQL / Actian transactional engines to Oracle, MS SQL Server, and PostgreSQL

thriftly-1

Quickly build multi-protocol web services with the same API. Supports JSON-RPC, REST, SOAP,  Thrift, and gRPC.

 Group 671-1

 

    Why Mertech?

    2 min read

    How and When to Use MS SQL Server Native Client

    SQL Native Client can be used rather than Microsoft Data Access Components (MDAC) to create new applications or enhance existing applications that need to take advantage of new SQL Server 2019 features, such as Multiple Active Result Sets (MARS), Query Notifications, User-Defined Types (UDT), and XML data type support.


    What Is SQL Native Client?

    Microsoft SQL Server Native Client (SQL Native Client) contains the SQL ODBC driver and SQL OLE DB provider in one native dynamic link library (DLL) supporting applications using native-code APIs (ODBC, OLE DB, and ADO) to Microsoft SQL Server. SQL Native Client was introduced in Microsoft SQL Server 2005 to provide new functionality above and beyond that supplied by the Microsoft Data Access Components (MDAC).

    Why Do I Need SQL Native Client?

    When would you actually want to use SQL Native Client as opposed to MDAC, or even ADO.NET? The answer is – only if you are upgrading existing or developing new COM-based (or native) applications that will target the new features of SQL Server 2019.

    If you don’t need any of the new features of SQL Server 2019, then you don’t need to use SQL Native Client. Your existing OLE DB and ODBC code will work just fine. Of course, if you have or are planning on moving to a managed code base for data access, then the ADO.NET data access classes of the .NET Framework are what you should use.

    The Benefits of Using SQL Native Client

    SQL Native Client should be used to create new applications or enhance existing applications that want to take advantage of new SQL Server 2019 features, such as database mirroring, multiple active result sets (MARS), query notifications, snapshot isolation, and XML data type support.

    SQL Native Client can be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2019 features, such as Multiple Active Result Sets (MARS), user-defined data types (UDT), query notifications, snapshot isolation, and XML data type support.

     

    How Do I Deploy SQL Native Client?

    When deploying an application that is dependent on SQL Native Client, you will need to redistribute SQL Native Client with your application. Unlike Microsoft Data Access Components (MDAC), which is now a component of the operating system, SQL Native Client is a component of SQL Server 2019.

    Therefore, it is important to install SQL Native Client in your development environment and redistribute SQL Native Client with your application. SQL Native Client redistributable installation program, named sqlncli.msi, is available on the SQL Server 2019 installation media and is available as one of the SQL Server 2019 Feature Pack components on the Microsoft Download site.

    Where Do I Get It?

    Mertech's driver installation installs the SQL Native Client.

     

    Learn how to easily migrate from Btrieve to SQL without any costly code changes in our free whitepaper.

    Download My BTR2SQL Whitepaper

     

    1 min read

    STREAMLINE YOUR DEPLOYMENTS WITH THE NEW Flex2SQL Deployment Toolset

    When you're dealing with product deployments at hundreds of sites, it's a given that you'll end up with some sites with a mix of older and newer...

    Read More

    Application Modernization: Closing the skills gap

    The skills gap maybe your greatest challenge in migrating to the cloud. Find out why – and how you can eliminate it. 

    Read More

    Flex2SQL v17 64-bit Unicode Edition for Oracle and MS SQL Server  available for download

    We are pleased to bring to you Flex2SQL v17 64-bit Unicode Edition.   This release includes only our MS SQL Server and Oracle drivers and includes...

    Read More