Data Connectivity - Intro

Welcome to the Data Connectivity FAQ.

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


Next Section : http://www.tek-tips.com/faqs.cfm?fid=3801