How to Connect to Database using a Connection String
The power of Active Server Pages comes through when we tie databases to our web sites. To connect to a…
Month: November 2022
MS Access Connection Strings
ODBC Connection Strings Standard Security: <%’declare the variable that will hold the connection stringDim ConnectionString ‘define connection string, specify database driver…
Oracle Connection Strings
ODBC connection strings <%’declare the variable that will hold the connection stringDim ConnectionString ‘define connection string, specify database driver and location…
MS SQL Server Connection Strings
ODBC Connection Strings Standard Security: <%’declare the variable that will hold the connection stringDim ConnectionString ‘define connection string, specify database driver…
MySQL Connection Strings
ODBC connection strings Local MySQL database using MySQL ODBC 3.51 Driver: <%’declare the variable that will hold the connection stringDim…
Bike – drop in phpMyAdmin replacement
Pretty often you need to run a couple of queries against your MySQL database on the client’s web server. Usually…
How to be a better PHP developer
Many web developers consider PHP a second-class language. The truth is, as DHH puts it: “You can build the best…
SQL: LIKE condition
Like is another keyword that is used in the Where clause. It is used to match string pattern values. The…
SQL: DISTINCT clause
Select lets you use the Distinct keyword to eliminate duplicate rows from the query results. Distinct is very useful in queries where…
SQL: SELECT statement
In a relational database, data is stored in tables. The Select statement allows you to retrieve records from one or…