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

Sybase CT-LIB to ODBC Conversion

We have been spending years to make our automated database migration software Ispirer MnMTK be more functional and more attractive to the client. Today not only do we propose the database conversion tool Ispirer MnMTK for stored procedure migration, function migration, trigger migration, view migration, schema migration and data migration. We help understand our clients the value of automated database and application migration solutions that enable business growth.

Today Ispirer MnMTK can convert Sybase CT-LIB C/C++ API to ODBC API.

Conversion features

  • Convert API variable type:
    1. CS_CONNECTION *connection;
    2. CS_COMMAND *cmd;


    convert to:
    1. SQLHANDLE connection;
    2. SQLHSTMT cmd;


  • Convert API method:
    1. ct_connect(connection, (CS_CHAR *) NULL, 0);
    2. ct_cmd_alloc(connection, &cmd);
    3. ct_command(cmd, CS_LANG_CMD,
    4. "select au_lname from costumers \
    5. where state = 'CA'", CS_NULLTERM, CS_UNUSED);
    6. ct_send(cmd);


    convert to:
    1. SQLConnect(connection,serv,SQL_NTS,user_name,SQL_NTS,pass,SQL_NTS);
    2. SQLAllocStmt(connection,&cmd);
    3. SQLExecDirect(cmd,"select au_lname from costumers \
    4. where state = 'CA'",SQL_NTS);


  • Convert binding host variable:
    1. ct_bind(cmd, 1, &columns, name, &datalength[0], &indicator[0]);


    convert to:
    1. SQLBindCol(cmd,1,columns.iDataType,name,(SQLINTEGER)
    2. columns.maxlength+1,&datalength[0]);


  • Ispirer MnMTK also allows you to convert dynamic SQL in the chosen direction at the same time you convert API.

Ispirer MnMTK

Ispirer MnMTK API conversion tool can easily migrate Sybase CT-LIB and embedded SQL project to ODBC. 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.

You are welcome to 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 tool is a great utility for migration to SAP HANA from MSSQL.

Read more
Industry Events