Background documentationSAP MaxDB ODBC Driver Reference Locate this document in the navigation structure

 

ODBC API Compatibility

The SAP MaxDB ODBC driver fulfills the ODBC 3.51 interface specification. More information: http://msdn.microsoft.com

Note Note

When developing your own applications, make sure that you differentiate between the versions ODBC 2.x and ODBC 3.x. Use the SQLSetEnvAttr function to define the SQL_ATTR_ODBC_VERSION attribute before you request a Connection handle with SQLAllocHandle.

End of the note.

The SAP MaxDB ODBC driver supports the complete ODBC SQL syntax. In addition to this, the ODBC driver extends the standard ODBC SQL syntax in the following areas:

  • Database procedures can be processed as SQL statements.

    Note that the ODBC syntax for procedures does not allow any return values for functions.

    More information: SQL Reference Manual, Name of a Database Procedure (dbproc_name)

  • It supports the following types of cursors that can be positioned: static, dynamic, and key set-driven. Using the SQLSetPos function, an application can execute positioning INSERT, UPDATE, and DELETE statements.

    More information: SQL Reference Manual, DECLARE CURSOR Statement (declare_cursor_statement)

More information:

Unicode Support
SAP MaxDB ODBC Driver

Operating System

ODBC Driver (ASCII)

ODBC Driver (Unicode)

Microsoft Windows

sdbodbc.dll

sdbodbcw.dll

Unix and Linux

libsdbodbc.a|so

libsdbodbcw.a|so

More information: Unicode Support

Data Types

The SAP MaxDB ODBC driver lets you convert all data types supported by ODBC.

More information: Supported Data Types