Question:
What are the disadvantages of ODBC versus SQL?
Answer:
ODBC is a generic implementation, whereas native SQL is always optimized for the database server being used. Thus, if you need to access a number of disparate database servers, ODBC offers a good solution. If you are accessing a single database server product (or products that are connectable viaa native SQL implementation, usually known as a gateway), the native SQL implementation always will be the most optimized.