What is a data source, and how is it used?

What will be an ideal response?


As an IT technician, you might be called on to help set up a local computer on a corporate network to connect to a remote database stored on a company database server. For example, suppose Microsoft Access is installed on the local computer and you want to configure it to connect to a Microsoft SQL Server database on the server. Open Database Connectivity (ODBC) is the technology used to create the data source, which provides access to the database and includes the drivers required to interface between Access and the data. Drivers for Microsoft SQL Server must be installed on the local computer (Windows has SQL drivers installed by default). Then you can use the ODBC Data Sources tool in the Administrative Tools group of Control Panel to configure the data source.

Computer Science & Information Technology

You might also like to view...

List three of the many drawbacks of cloud computing for organizations.

What will be an ideal response?

Computer Science & Information Technology

A collection of Web-based services, including instant messaging and photo sharing is called:

A) Microsoft Services B) Microsoft Messenger C) Windows Live D) Message List

Computer Science & Information Technology

Good design methodology needs to be adaptive while applied to different parameters

Indicate whether the statement is true or false

Computer Science & Information Technology

Most Web servers are configured to support one connection type(s).

Answer the following statement true (T) or false (F)

Computer Science & Information Technology