Code directly to ODBC APIs

Many PC applications make ODBC calls that allow the user to seamlessly access data on different platforms. Before you begin developing your own application with ODBC APIs, you should understand how an ODBC application connects to and exchanges information with a database server.

• Call stored procedures
  Use stored procedures to improve the performance and function of an ODBC application.
• Block insert and block fetch C example
  Block inserts and block fetches can be used to enhance the performance of an ODBC application.
• Example: Block inserts using Visual Basic
  This example is a Visual Basic block insert that is significantly faster than a "parameterized" insert.
• Visual Basic: The compromise between Jet and ODBC APIs
  While the database objects are easy to code, they sometimes can adversely affect performance. Coding to the APIs and to stored procedures can be a frustrating endeavor. Fortunately, if you are using Visual Basic Enterprise Edition in the Windows^® 95 environment, there are additional options. These options are a good compromise between the usability of database objects and the high performance of APIs: Remote Data Objects (RDO) and Remote Data Control (RDC).