THIS SITE USES COOKIES: By continuing to browse this site, you give your consent for cookies to be used.
For more details, please read our Privacy Policy and Cookies Policy.

Automated and Customizable
Database and Application
Migration and Modernization

Migrating ESQL/C to ODBC API in C/C++ Applications

What is ESQL/C?

Embedded SQL (ESQL/C) is a SQL-92 standard application programming interface (API) for SQL database access. Microsoft SQL Server 2000 provides an Embedded SQL precompiler for C/C++ applications. The SQL Server precompiler translates Embedded SQL statements as calls to the appropriate DB-Library API functions.

Why to Migrate?

  • Unavailability of technical documentation for ESQL API.
  • Microsoft announced cancellation of ESQL/C in the coming SQL Server releases
  • Microsoft encourages removing dependencies on ESQL/C in existing C/C++ applications and use OLE DB or ODBC access data in SQL Server


Conversion features

SQLWays automates the following conversion features:

  • Adds the include files for ODBC API functions and structures:
    • #include <windows.h>
    • #include <sqlext.h> (automatically includes "sql.h" and "sqltypes.h")
  • Converts ESQL/C database connection - EXEC SQL CONNECT TO to ODBC connectionlike:
    • Allocates environment handle
    • Allocate connection handle
    • Establishes a connection using functions:
      • SQLConnect()
      • SQLDriverConnect()
      • SQLBrowseConnect()
  • Converts ESQL/C Error Handling - SQLCODE variable and SQLCA structure to ODBC Error Handling- SQLGetDiagRec() function
  • Converts ESQL/C EXEC SQL statements for operation with data to corresponding ODBC API functions:
    • SQLPrepare()
    • SQLExecute()
    • SQLBindParameter()
    • SQLFetch()
    • Etc.

How to convert?

Please take a look at the related article:

Embedded SQL and Database Access API Migration

If you use SQLWays Studio, you need to specify the following settings:

Source: C++
Source Database: Microsoft SQL Server
Source Database API: ESQLC


Target: C++
Target Database: Microsoft SQL Server
Target Database API: ODBC

SQLWays automates the entire migration of Embedded SQL (ESQL/C) to ODBC API. This allows you to dramatically decrease conversion risks and significantly reduce in-house efforts. Reasonable pricing strategy makes SQLWays even more powerful instrument for such migration type.

If you are interested in these services, please contact us for more information.

November 25, 2013Ciber, Sweden
Oracle to Microsoft SQL Server Migration
(including PowerBuilder migration)

"Ciber develops system for parking permits to the major cities in Sweden.
In 2012, when the second largest city in...


August 21, 2014TouchStone Systems, Inc., United States
Sybase ASA to Microsoft SQL Server Migration
(including embedded SQL migration in PowerBuilder)

"To whom it may concern,

Being a leading provider in reverse logistics solutions, we continue to...


Case Studies
August 24, 2014PostgreSQL to Oracle Migration, United States (including embedded SQL migration in Java)

The client was a U.S.-based, non-profit organization working within the education sector, striving to ensure equal rights of students in low-income groups across the United States. This was...


September 11, 2014Informix to SQL Server Migration, United States (including embedded SQL migration in PowerBuilder, Visual Basic to C#, ASP to ASP.NET)

A U.S.-based renowned lessor of trailers requested the services of Ispirer to perform a major migration.



The team has run few code conversion. It’s a very powerful and friendly tool.

Read more
Industry Events