ODBC

---

The Mimer SQL Mobile ODBC driver differs from the Mimer SQL Engine ODBC driver in the following way:

• In the cases when both an ASCII and Unicode function exists, only the Unicode function is available on Pocket PC
• Only ODBC 3 mode applications are supported, ODBC version 2 is not supported
• The Mobile ODBC driver can connect to Mimer SQL version 9.1 or newer servers
• The Catalog functions are not supported.

ODBC Files in the Distribution

In the distribution there are three files that belong to the Mobile ODBC driver. On Pocket PC these files are:

• MINODBCW.DLL - the mobile ODBC driver
• MINODBCW.LIB - an import library used for linking
• MINODBC.H - the header file

On Symbian these files are:

• MINODBC.DLL - the mobile ODBC driver
• MINODBC.LIB - an import library used for linking
• MINODBC.H - the header file

Linking Applications

Since the operating systems do not have an ODBC Driver Manager, it is not possible for applications to link against ODBC32.LIB. Pocket PC applications must be linked with the MINODBCW.LIB import library to resolve references to functions in MINODBCW.DLL. Symbian applications must be linked with the MINODBC.LIB import library to resolve references to functions in MINODBC.DLL.

The MINODBC.H file included is a merge of SQL.H, SQLEXT.H, SQLTYPES.H and SQLUCODE.H. Application developers should only include this file and not the other files. It is not required, but it is more convenient to use, because MINODBC.H reflects the functionality available in the Mobile ODBC driver.

On Symbian, the MINODBC.LIB file included in the distribution must be copied to the "library location" in the Symbian SDK. With the default installation for the Series 60 SDK version 2.1, the minodbc.lib file should be copied to: c:\Symbian\7.0s\Series60_v21_CW\Epoc32\release\thumb\urel

Supported ODBC Functions

The following ODBC functions are supported in Mimer SQL Mobile

SQLAllocHandle	SQLExecute	SQLGetStmtAttr[W]
SQLBindCol	SQLFetch	SQLMoreResults
SQLBindParameter	SQLFetchScroll	SQLNumParams
SQLCancel	SQLFreeHandle	SQLNumResultCols
SQLCloseCursor	SQLFreeStmt	SQLParamData
SQLColAttribute[W]	SQLGetConnectAttr[W]	SQLPrepare[W]
SQLColAttributes[W]	SQLGetCursorName[W]	SQLPutData
SQLConnect[W]	SQLGetData	SQLRowCount
SQLDescribeCol[W]	SQLGetDescField[W]	SQLSetConnectAttr[W]
SQLDescribeParam	SQLGetDiagField[W]	SQLSetCursorName[W]
SQLDisconnect	SQLGetDiagRec[W]	SQLSetEnvAttr
SQLDriverConnect[W]	SQLGetEnvAttr	SQLSetPos
SQLEndTran	SQLGetFunctions	SQLSetStmtAttr[W]
SQLExecDirect[W]	SQLGetInfo[W]

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se