> Gotta ask a dumb question. Would installing MDAC 2.8 help other db's > like R:Base or does this just affect MS SQL?
Definitely make sure you have MDAC 2.8. You should always keep the ODBC Driver Manager and odbc database driver up to date. (Anyone using OS X send an email to Apple to let them know that you are using ODBC and would appreciate them updating the iodbc driver manager in Tiger and that it should also provide updates on a regular basis to it. http://www.apple.com/feedback/server.html) Keeping it simple and short - ODBC has several layers and the way a request makes it from the Witango Server to a database and back again is like this. ---------------------- | Witango Server | | Connects to ODBC | | Driver Manager | ---------------------- /\ || \/ ---------------------- | ODBC Driver Mgr | ---------------------- /\ || \/ ---------------------- | ODBC DB Driver <=> | | Native DB Protocol | ---------------------- /\ || \/ ---------------------- | Database Management| | System | ---------------------- /\ || \/ ---------------------- | Database | ---------------------- The Witango server sends its requests to the odbc driver manager that in turn makes calls to the odbc database driver. MDAC/iodbc/unixodbc provides the odbc driver manager layer that the odbc database driver sits on. The Witango server does not access the odbc database driver directly, it is always accessed indirectly via the odbc driver manager whose environment it is loaded into. The odbc database driver has an ODBC interface that the driver manager communicates with and implements the native database protocol to communicate with the database. The other thing to know is that the odbc database driver is usually written by the database vendor and not the by the driver manager vendor so you may need to visit both vendors to get the latest driver manager and odbc database driver. Phil ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
