• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Using ODBCDirect

ODBCDirect is a technology that enables you to access ODBC data without loading the Microsoft Jet Database Engine. It provides dramatic increases in performance by eliminating the bottlenecks that the Jet Engine imposes. Queries are sent directly to ODBC instead of being parsed and translated by Jet. ODBCDirect was covered in detail in Chapter 20. The main drawback of ODBCDirect is that you cannot use it with bound forms and reports. Instead, it returns a set of records that you must process programmatically. Despite this limitation, the performance ODBCDirect offers you may not only be worth the trouble, but necessary in order for you to achieve satisfactory performance with an application that uses client/server data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint