Archives of the TeradataForum

Message Posted: Fri, 08 Dec 2000 @ 19:56:53 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Active X Data Objects (ADO) are a set of objects and routines that simplify database access for web pages using ODBC as the driver to Teradata. Using Visual InterDev you create a connection object which is the ODBC connection to the Teradata database, then you can create queries against that database connection. Now the good part, you drag a visual control (Input box, text box, grid) from the ADO panel to web page, point that control to the query and fill in a few properties including which columns in the query to use and the web page is data enabled.

There is some prep under IIS that you will have to do to get it all to work the first time including some server side scripts on the IIS server.

Using ADO also means you have decided to let Uncle Bill win (Internet explorer only) Netscape and other browser will not work with ADO objects.

I have gotten it to work in a 2 tier environment with little difficulties, I have not done any test in a 3 tier environment. I usually put business rules and the like on the web server side anyway.

	<Prev	Next>		<<First	<Prev	Next>	Last>>