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

Oracle Pro*C to ODBC Conversion

Migrate smoothly Oracle Pro*C to ODBC with Ispirer Migration and Modernization Toolkit 2017!

We develop our migration tool Ispirer MnMTK 2017 using customer-oriented approach in order to satisfy client’s business needs.

Ispirer MnMTK database API migration tool automatically detects EXEC SQL statements and host variables, converts them to ODBC API and pastes additional code.


Conversion features

Ispirer MnMTK performs the following actions:

  • Adds include files for ODBC API functions and structures:
    • #include
    • #include
  • Converts Oracle Pro*C database connection - EXEC SQL CONNECT TO to ODBC connection in the following way:
    • allocating environment handle
    • allocating connection handle
  • Establishes a connection using functions:
    • SQLConnect()
    • SQLDriverConnect()
    • SQLBrowseConnect()
  • Converts Oracle Pro*C statements operating with data to corresponding ODBC API functions:
    • SQLPrepare()
    • SQLExecute()
    • SQLBindParameter()
    • SQLFetch(), etc.
  • Converts DDL and DML statements to query string.

Oracle Pro*C example (file: simple.pc):

  1. EXEC SQL include sqlca;
  2.  
  3. int main()
  4. {
  5. EXEC SQL DECLARE cur_name CURSOR FOR
  6. SELECT NVL(COL_NAME,' ')
  7. FROM TBL_NAME;
  8.  
  9. EXEC SQL OPEN cur_name;
  10. return 0;
  11. }

After the conversion simple.pc file is converted to simple.cpp (using SQL Server Data Base):

  1. #include <sql.h>
  2. #include <sqlext.h>
  3. SQLHENV env;
  4.  
  5. int main()
  6. {
  7. SQLHSTMT cur_name;
  8. sqlca.sqlcode = SQLAllocStmt(connection,&cur_name);
  9. sqlca.sqlcode = SQLPrepare(cur_name,
  10. "SELECT ISNULL(COL_NAME,' ') "\
  11. " FROM TBL_NAME",SQL_NTS);
  12. sqlca.sqlcode = SQLExecute(cur_name);
  13. return 0;
  14. }

Ispirer MnMTK generates sqlca struct to replicate the application logic:

  1. struct
  2. {
  3. SQLRETURN sqlcode;
  4. SQLCHAR sqlerrm[SQL_MAX_MESSAGE_LENGTH+1];
  5. SQLCHAR sqlstate[SQL_SQLSTATE_SIZE+1];
  6. SQLSMALLINT length;
  7. } sqlca;


Please complete the questionnaire to initiate collaboration discussions for your project or get some rough estimation:

Live Presentation

Ispirer Migration Solution

Oracle Pro*C to ODBC

Request

Request a Quote

Ispirer Migration Solution

Oracle Pro*C to ODBC

Service Toolkit

For further information please Contact us.

 
Testimonials
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.

...

Feedback

Now the developers know your tool works fine…
Thanks for your assistance and we take into account Ispirer for this migration or any other we have to do in the future.

Read more
Industry Events