ODBC (Open Data Base Connectivity) is an interface to access databases via SQL queries. ODBC can be used as an access tool to various databases such as MS-Access, dBase, DB2, Excel, and Text. Through these Call Level Interface (CLI) specifications of the SQL Access Group, the OBDC allows a neutral w
[ read more ]
A relational database stores data in separate tables instead of placing all data in one large table. It then allows Data Base Administrators (DBAs) to define relationships between these tables. These relationships enable DBAs to combine data from several tables for querying and reporting. T
[ read more ]
A BLOB (Binary Large OBject) is a large chunk of data which is stored in a database. A BLOB differs from regular database data in that it is not forced into a certain structure. A normal database field might be structured to be 14 characters long and only accept lowercase letters. A BLOB field is n
[ read more ]
A DSN (Data Source Name) is an identifier that is used to store information relating to a database connection. DSNs can store a database’s name and server location, the directory that is used to store offline content, the database driver, and the user’s ID and password. DSNs can be used for a wi
[ read more ]