INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Data Connectivity

Data Connectivity - Intro by DreXor
Posted: 27 Jun 03 (Edited 15 Dec 04)

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

Back to Microsoft: ASP (Active Server Pages) FAQ Index
Back to Microsoft: ASP (Active Server Pages) Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close