(1). Explain how ODBC, OLE DB and ADO are related (at least 400 words) (2) Why i

Question

(1). Explain how ODBC, OLE DB and ADO are related (at least 400 words)

(2)  Why is OLE DB important

(4). Describe the differences between JSP and ASP

(5) Describe the differences between XML and XSLT (at least 250 words)

(6). Describe in general how to connect a database system to a Web server so that remote users can use their browser to access the database. What are technologies used for this connection? Be as specific as possible. (at least 400 words)

(7)  describe the needs and roles of data warehouse and its development  (at least 300 words)

(8) Describe the needs and roles of data mining. What are basic approaches for data mining? (at least 300 words)

Explanation / Answer

1) Open Database Connectivity (ODBC), is an international standard for manipulating relational data using SQL query syntax across disparate datasources.

OLE DB is Microsoft's strategic low-level interface to data across the organization. OLE DB is an open specification designed to build on the success of ODBC by providing an open standard for accessing all kinds of data. OLE DB imposes no specific limitation on either the query syntax, or the structure of the data exposed as long as it can be retrieved in tabular form.

ADO is Microsoft's strategic, language-neutral, high-level interface to data exposed by OLE DB. ADO provides consistent, high-performance access to data, whether you are creating a front-end database client or middle-tier business object using an application, tool, language, or even an Internet browser.

they all are DBMS manipulating tools of microsoft

2)OLE DB imposes no specific limitation on either the query syntax, or the structure of the data exposed as long as it can be retrieved in tabular form. An OLE DB Data Provider is analogous to an ODBC Driver, exposing a DataSource to an OLE DB Consumer, such as ADO. An increasing variety of OLE DB Data Providers are being released by both Microsoft and third party vendors. The first OLE DB Data Provider, the Microsoft OLE DB Provider for ODBC Drivers, enables you to expose any ODBC DataSource to an OLE DB consumer.

5)In the not-too-distant past most web pages used HTML and CSS style sheets. Now that there are more types of data and information available on the web, they've added XML to the mix (xhtml). There is a java-based protocol using XML called XSL which is a language for style sheets. XSLT stands for XML Transformations, it is for transforming XML documents.

6)

Open the Web.config file in the root directory of your ASP.NET application. If you do not have a Web.config file, create one.

In the Configuration element, add a ConnectionStrings element, if one does not already exist.

Create an add element as a child of the ConnectionStrings element, defining the following attributes:

ex :

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.