Archives of the TeradataForum
Message Posted: Fri, 08 Dec 2000 @ 19:56:53 GMT
| Subj: | | Re: SQLrowcount Function |
| |
| From: | | John HR Schuster |
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.
| 
