Menu
Simba Technologies
Simba Technologies

SimbaEngine X SDK 10.1.3
Developing Drivers for Data Stores Without SQL

SimbaEngine X SDK Documentation > Multithreading > Asynchronous ODBC Support

Asynchronous ODBC Support

The SimbaEngine X SDK enables your custom ODBC driver to support asynchronous ODBC. ODBC 3.8 supports asynchronous execution of ODBC connection functions, while ODBC 3.52 only supports asynchronous execution of statement functions. For more information about asynchronous ODBC support, see http://msdn.microsoft.com/en-us/library/ms713563%28v=vs.85%29.aspx

SimbaEngine 9.3 and later releases supports the polling method for this asynchronous functionality. However, this support varies by platform as listed below.

Note:

Executing functions asynchronously using the polling method involves calling the same function is repeatedly until the function no longer returns SQL_STILL_EXECUTING. When repeatedly calling the function in such a loop, it’s recommended that the same parameters be passed each time and that their values remain unchanged. This will prevent any unexpected errors from occurring.

Windows 7 +

  • SQLBROWSECONNECT
  • SQLCOLATTRIBUTE
  • SQLCOLUMNPRIVILEGES
  • SQLCOLUMNS
  • SQLCONNECT
  • SQLDESCRIBECOL
  • SQLDESCRIBEPARAM
  • SQLDISCONNECT
  • SQLDRIVERCONNECT
  • SQLENDTRAN
  • SQLEXECDIRECT
  • SQLEXECUTE
  • SQLFETCHSCROLL
  • SQLFETCH
  • SQLFOREIGNKEYS
  • SQLGETDATA
  • SQLGETTYPEINFO
  • SQLMORERESULTS
  • SQLNUMPARAMS
  • SQLNUMRESULTCOLS
  • SQLPARAMDATA
  • SQLPREPARE
  • SQLPRIMARYKEYS
  • SQLPROCEDURECOLUMNS
  • SQLPROCEDURES
  • SQLPUTDATA
  • SQLSETPOS
  • SQLSPECIALCOLUMNS
  • SQLSTATISTICS
  • SQLTABLEPRIVILEGES
  • SQLTABLES

Non-Windows including iODBC, UnixODBC, SimbaDM

  • SQLCOLUMNPRIVILEGES
  • SQLCOLUMNS
  • SQLEXECDIRECT
  • SQLEXECUTE
  • SQLFETCHSCROLL
  • SQLFETCH
  • SQLFOREIGNKEYS
  • SQLGETTYPEINFO
  • SQLPRIMARYKEYS
  • SQLPROCEDURECOLUMNS
  • SQLPROCEDURES
  • SQLSPECIALCOLUMNS
  • SQLSTATISTICS
  • SQLTABLEPRIVILEGES
  • SQLTABLES

Note:

  • Asynchronous functionality at the connection level is not supported on non-Windows platforms.