Thanks for the help again Razzak! (:
----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Sunday, October 26, 2003 7:29 PM Subject: [RBASE-L] - Re: R:Tango 5 - Razzak's Reply > At 06:45 PM 10/26/2003 -0800, Alan Wolfe wrote: > > >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. >
