Yes, I was not very clear as to the scenario. A) Foreign Database = Non-Rbase and is writing/retrieving data into Rbase Database "X" via Oterro
B) Second Database = Rbase Database writing/retrieving data into Rbase Database "x" , could use native v9.5 ODBC driver or could use Oterro driver. (A) must use Oterro driver in the DSN(A) pointing to Rbase Database "X' (B) could use Oterro or v9.5 driver in the DSN(B) pointing to Rbase Database "X". For instance, this work station has Worldship connecting via Oterro to Database "X' . This same workstation has an app running in Database "X" that connects to a second Rbase database and currently uses the native v9.5 driver in that DSN connection. However, it could use the Oterro driver for that Rbase connection as well, if it made sense to do so. My system is working fine, this is more of a theoretical question as to best practice / performance. Another way to state the question is : "Does two DSN's using the same ODBC driver save resources over two DSN's using two different drivers?" Does/can the ODBC manager share any resources for a loaded ODBC driver if it is used in multiple DSN's? Probably not, but I was curious. Again, no problem here, more of a curious question. Thanks, Bob Addition .... If Foreign Database is going to access the data from R:BASE database, you will need the Oterro driver for Foreign Database to access R:BASE data. ---------- 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! --
