Database Connectivity

greenspun.com : LUSENET : TNS Website : One Thread

The most useful websites are the ones that connect to a database. In the current environment (IIS/SQL), ADO is the best method and SQL 7 or 2000 is preferred, but if these are not available or the traffic is not too high (up to 10 or15 concurrent users), Access (Jet 4.0) is the next choice, since it works with the same ADO and SQL code, and when SQL 7 or 2000 is available, the web can be connected to the SQL database by changing the DSN setting, and minimal or no changes to the ADO VBScript.

-- Anonymous, February 02, 2001

Moderation questions? read the FAQ