Microsoft?s Open Database Connectivity (ODBC) protocol is a widely used and accepted API for database interaction. ODBC uses Structured Query Language (SQL) as its database access language. Most Windows-based products that use databases support ODBC. Through ODBC, applications such as Cold Fusion, FrontPage, or Active Server Pages can interact with several database systems at once. ODBC is often associated with a DSN, or a Data Source Name. That is because the DSN is the appointed name for your database in the script calling it. A DSN is like an alias to your database, and your scripts will use the alias to access your database. |