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.
You might also like to view...
The cut and copy commands make use of temporary storage called the ________
A) Tablet B) Clipboard C) Pasteboard D) Cut/Copy board
To complete a LEFT OUTER JOIN, what keyword is optional?
a. LEFT b. OUTER c. JOIN d. All of these keywords are required. e. All of these keywords are optional.