At 11:24 AM 11/26/2014, [email protected] wrote:
I have a question pertaining to a "best practice" theory in regards
to ODBC drivers.
Computer "A" is connected to a database that uses (2) DSN's to write
and retrieve data from other databases.. One is an Oterro DSN that
attaches to a foreign database. The other DSN attaches to a second
RBASE database.
Thus the question :
A) Is it better to use Oterro for both connections? I.E. one ODBC
driver, thus possibly less loading into memory? Oterro -> Foreign
Database Oterro -> Rbase Database
B) Use Oterro for the foreign database and use the 9.5 ODBC driver
for the Rbase connection? I.E. is the native Rbase ODBC driver
better suited for Rbase to Rbase connections?
Oterro -> Foreign Database Rbase Driver -> Rbase Database
Bob,
A question and a suggestion:
Is the Foreign Database you are referring to also an R:BASE database?
If not, you will have to use the ODBC driver for that database and
not the Oterro ODBC driver as it will only recognize R:BASE databases.
Depending on your server, user access, application usage, and load
balance, having multiple System DSNs defined for various components
of your application using the same database is the way we design all
our very complex web applications, currently in production, using
R:BASE eXtreme 9.5 (64), Oterro 9.5 (64), Apache, and Node.js running
on MS Windows 2012 server.
In a multi-database application environment, you will have to define
a unique system DSN for each database accordingly.
Depending on your Oterro 9.5 license, using the Oterro 9.5 ODBC driver
gives you the "full" functionality/compatibility as compared to native
R:BASE ODBC driver.
For more details: http://www.oterro.com
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!
--
