ODBscript

ODBscript is a Web page "scripting" language that is easy to learn and quick to use every time, even if you are not a programmer. Using standard SQL (a database language, which is also easy to learn), you can retrieve values from databases and display them in your Web pages, and you can update your databases from Web browser forms, all with an absolute minimum amount of "coding."

ODBscript is using a "CGI" or "ISAPI" application witch is executed by your Windows-based Web server to process "script" files that you can write using your favorite HTML editor. These scripts produce standard HTML Web pages (because any HTML tags and text in the script are simply sent to the browser), but by including ODBscript processing statements, your Web pages can also do things such as interact with your databases and operate on user input from a Web page form.

A CGI program can be executed by a Web URL that references a program file rather than an HTML file. (ISAPIs are "server extensions" supported by MS-IIS and other Windows Web servers. They are similar to CGIs but more efficient because they are DLLs that do not need to be loaded for each request, and the ODBscript ISAPI also uses ODBC "connection pooling" to save overhead by reusing database connections.) To get data from a Web user, for example, a CGI or ISAPI program can be executed as the "action" for an HTML input form. The program can process this data and create a Web page to send back to the users browser. CGI and ISAPI programs can also be executed with standard "anchor" text and graphic links, possibly with input variables directly in the URL. CGI and ISAPI programs make Web page content dynamic rather than static, so they allow Web-based services beyond simple document presentation.

ODBscript processing is completely controlled by the script files that you create. In these script files, you can have HTML formatted text, JavaScript, and stylesheets -- anything that a standard HTML file can have -- but you can also have ANSI SQL statements to SELECT, INSERT, UPDATE, or DELETE data in any ODBC-accessible database. (Most databases that run on Windows platforms have ODBC interfaces. You can use Microsofts MS-Access or SQL Server, several third-party databases such as Oracle, or even the freeware MySQL.) Database query results can be inserted into the HTML text and output to the browser, formatted any way that you like, or the users input can easily be saved in the database. In addition to this ODBC SQL interface, ODBscript provides many other useful data processing functions, without the complexity of CGI programming, to make your site fully interactive.