devxlogo

ODBC Versus SQL

ODBC Versus SQL

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.

devx-admin

Share the Post: