This is an overview of what data connectivity is and how it works. The First segment of a possibly long chain of data connectivity faqs, each will cover step by step and alternate methods to each phase.
Data Connectivity: getting to your information ( in a nutshell )
Data is stored in a diverse universe of storage:
Microsoft's TransAct Sequel ( MS SQL ) is one of the most popular Microsoft's Access Databases (MSA SQL) cause of it's user interface and portability Oracle FoxPro MySQL Text Excel and on and on...
Normally the supplier of each data storage environment will supply along with it methods of accessing it. From a graphic user interface ( GUI ) and / or Data Access Components ( DAC ). Microsoft supplies a cornucopia of DAC drivers in a bundled pack known as the MDAC ( Microsoft Data Access Components ) available @ http://www.microsoft.com/mdac
The DAC's are used in conjucntion with 'environments', be it the gui that comes with the data storage method, web serving, or programming environments. Hence allowing access to the data by means of translating for the requesting environment.
In these articles the 3 main Data Sources I'll cover deal with MS SQL, MSA SQL, and Text Driven databases.
Please Note: 1.) These articles will be written using ASP based on VB 2.) I tend to type in all lower case and please excuse grammatical errors and punctuation as well