Hey List!
I was wondering, when you create a datasource you can make it use either the oterro or r:base driver. Ive always been told to use oterro but always wondered, what is the difference between the 2?
Alan,
R:BASE ODBC Driver bundled with R:BASE 6.5++ for Windows and R:BASE 7.0 for Windows are intended for R:BASE 6.5++ and 7.0 databases with a limited functionality and does not include the core SQL functions as implemented in Oterro 2.6.
On the other hand, Oterro 2.6 is a full 32-bit relational ODBC database engine ideal for use in a file server environment when using application development tools, such as, R:Tango, Visual Basic, Delphi, ADO, RDO, Cold Fusion, ASP, PHP, IBM WebSphere and many other products.
Oterro 2.6 is able to operate in a complex multi-user environment at high capacity and high speed.
FYI, the following is a short list of core SQL functions supported in Oterro 2.6:
. SQLAllocConnect . SQLAllocEnv . SQLAllocStmt . SQLBindCol . SQLBindParameter . SQLBrowseConnect . SQLCancel . SQLColAttributes . SQLColumnPrivileges . SQLColumns . SQLConnect . SQLDataSources . SQLDescribeCol . SQLDescribeParam . SQLDisconnect . SQLDriverConnect . SQLDrivers . SQLError . SQLExecDirect . SQLExecute . SQLExtendedFetch . SQLFetch . SQLForeignKeys . SQLFreeConnect . SQLFreeEnv . SQLFreeStmt . SQLGetConnectOption . SQLGetCursorName . SQLGetData . SQLGetFunctions . SQLGetInfo . SQLGetStmtOption . SQLGetTypeInfo . SQLMoreResults . SQLNativeSql . SQLNumParams . SQLNumResultCols . SQLParamData . SQLParamOptions . SQLPrepare . SQLPrimaryKeys . SQLProcedureColumns . SQLProcedures . SQLPutData . SQLRowCount . SQLSetConnectOption . SQLSetCursorName . SQLSetPos . SQLSetScrollOptions . SQLSetStmtOption . SQLSpecialColumns . SQLStatistics . SQLTablePrivileges . SQLTables . SQLTransact
Upcoming Oterro 3.0 will offer extended SQL functions as well as the supported functions for ODBC 3.0, not to mention the multi-threading for very complex front-end applications!
Hope that helps!
Very Best R:egards,
Razzak.
