What is ODBCDirect?
With DAO 3.5 comes a new client/server connection mode via the ODBCDirect Workspace object. ODBCDirect provides high-speed, server-side access directly to an ODBC-compliant database without loading the Microsoft Jet database engine into memory. It does this by providing a thin programming layer over ODBC drivers. This allows you to handle remote data sources using the familiar DAO object model. All this is accomplished because RDO 2.0 ships with Office 97 and Microsoft Access. Microsoft Access exposes RDO’s functionality through ODBCDirect.
Related Questions
- I am using Excel and want to fill list boxes with information stored in SQL Server. How can I do this using ODBCDirect?
- I used to use DAO to connect to my SQL Server. How do I establish a connection to SQL Server using ODBCDirect?
- How do I refer to ODBCDirect in my application so that I don load the Jet Engine?
