Connect to a Database from Classic ASP with ADO
Last updated: August 26, 2026. Classic ASP connects to databases through ADO. Keep the connection string in protected server configuration,…
Month: November 2022
Microsoft Access Connection Strings for Classic ASP
Last updated: August 26, 2026. Classic ASP can open an Access database through ADO using the ACE OLE DB provider.…
Oracle Connection Strings for Classic ASP
Last updated: August 26, 2026. Classic ASP can connect to Oracle through ADO using an Oracle OLE DB provider or…
SQL Server Connection Strings for Classic ASP
Last updated: August 25, 2026. Classic ASP applications normally connect to SQL Server through ADO. Use a supported SQL Server…
MySQL Connection Strings for Classic ASP
Last updated: August 26, 2026. ADO can connect to MySQL through Connector/ODBC using a system DSN or a DSN-less connection…
Bike: Lightweight MySQL Administration Tool
Last updated: August 27, 2026. A database administration tool has direct access to sensitive data and schema operations. Use only…
Practical Habits for Better PHP Development
Last updated: August 27, 2026. Reliable PHP development combines clear types, automated feedback, secure defaults, and reproducible dependencies. Practice Benefit…
SQL LIKE and NOT LIKE Conditions
Last updated: August 26, 2026. The SQL LIKE condition matches text using wildcard patterns. A percent sign matches zero or…
SQL DISTINCT
Last updated: August 27, 2026. SELECT DISTINCT removes duplicate result rows after the selected expressions have been evaluated. Syntax Example…
SQL SELECT Statement: Retrieve and Filter Data
Last updated: August 27, 2026. The SQL SELECT statement retrieves columns and rows from one or more tables. A clear…