As others have mentioned, the AR System server is the only thing that interacts with the database. All other aspects of the system interact with the AR System server for data.
The AR System server connects with the database using the DB native libraries that are linked into the AR System. So, if you are using Oracle, we link directly with a set of Oracle libraries to interact with the database. If using MS SQL Server, we link with a set of MS SQL Server libraries. We do not use the ODBC or JDBC connections at this time (although we are looking at whether using JDBC connections in the future have the necessary functionality and scalability) because we have found that going direct with native libraries gives us the most control and functionality and performance. I hope this helps address your question, Doug Mueller -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sweety Sent: Wednesday, January 08, 2014 2:11 PM To: [email protected] Subject: Re: Relationship between ARServer/Mid Tier and Database What are those database libraries ? or What are database libraries ? Do they vary from vendor to vendor ? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
