[an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive]
What is ODBC?
According to Microsoft:
Open Database Connectivity (ODBC)
technology provides a common interface for accessing heterogeneous SQL
databases. ODBC is based on Structured Query Language (SQL) as a
standard for accessing data. This interface provides maximum
interoperability: a single application can access different SQL Database
Management Systems (DBMS) through a common set of code. This enables a
developer to build and distribute a client/server application without
targeting a specific DBMS. Database drivers are then added to link the
application to the user's choice of DBMS.
Benefits:
1. ODBC
Applications are not tied to a proprietary vendor API.
2. ODBC 3.0
aligns with, and is a superset of, the X/Open and ISO Call Level
Interface (CLI) standards.
3. Increased performance.
More information can be found at http://www.microsoft.com/data/odbc/
What do you mean "MySQL is ODBC Compliant"?
MySQL is ODBC Compliant, which means once you setup a DSN (data source name) on your local PC that points to an online mySQL database, you can actually add/delete and update records from your local PC.
Note: In order to connect to and manipulate an online mySQL database, you must be connected to the Internet.
Why, Who and How can this be used?
Setting up ODBC on your PC to access your online mySQL database.
Requirements: Windows 95, 98, or NT 4.0