Friday, November 28, 2014
Tip of the Day: Which ODBC Driver to Use?
Product.: R:BASE eXtreme 9.5 (32/64) and Oterro 9.5 (32/64)
Build...: 9.5.4.31125 or higher www.rcornucopia.com www.rupdates.com
Section.: R:BASE and Oterro ODBC Drivers
Keywords: ODBC
Options.: www.oterro.com
Each licensed version of R:BASE eXtreme 9.5 (32/64) typical installation
also includes the native R:BASE ODBC driver to be used with the licensed
version of R:BASE eXtreme 9.5 (32/64) ONLY and not with any other apps
such as R:Compiled or Runtime applications, etc.
To use the ODBC driver for your R:Compiled or Runtime 9.5 applications,
you should purchase a separate license of Oterro 9.5 (32/64) accordingly.
Using RBG95 ODBC Driver with your R:Compiled or Runtime applications
would be a clear violation of your purchased R:BASE eXtreme 9.5 (32/64)
license.
Having explained that ...
Here are the differences (other than number of connections) between
Oterro 9.5 (32/64) and the RBG95 (32/64) ODBC driver:
The RBG95 ODBC driver does not support updates, deletes, or inserts
done with a positioned cursor, while Oterro does.
The R:BASE eXtreme 9.5 (RBG95) ODBC driver only supports the following
commands through SQLExec:
CLEAR:
DECLARE:
DELETE:
INSERT:
SELECT:
SET:
UPDATE:
The Oterro 9.5 driver supports the above commands plus the following:
ALTER:
APPEND:
ATTACH:
AUTOCHK:
AUTONUM:
CALL:
COMMENT:
CREATE:
DETACH:
DROP:
GET:
GRANT:
IF:
INPUT:
LAUNCH:
LOAD:
OUTPUT:
PACK:
PROJECT:
PUT:
RENAME:
REVOKE:
REVOKE:
RULES:
SATTACH:
SCONNECT:
SDETACH:
SDISCONNECT:
UNLOAD:
WHILE:
Based upon your needs, now you many use the appropriate ODBC driver
as you see fit.
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
31 years of continuous innovation!
16 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
