HTTP Fundamentals, Part 1: URL, Encoding, Request and Response

HTTP fundamentals a web developer needs to know: HTTP address is called a URL (Uniform Resource Locator). Everything on the Internet is a resource.   Example: http://mydevsite:1234/mydevpage?first=Rodan&last=Sotto#comment   URL consists of the following parts:   <scheme>://<host>:<port>/<path>?<query>#<fragment>   Scheme describes how to access a particular resource. In our example above, it’s HTTP. It can be HTTPS, …

Continue reading HTTP Fundamentals, Part 1: URL, Encoding, Request and Response

Advertisements

CSS Fundamentals

In my last blog here, I talked about ways to put CSS in an HTML, the preferred method using external style sheets, and how styles are overwritten when using more than one method.  I also talked about the syntax for declaring a CSS property. Here I am going to go through some of the basic …

Continue reading CSS Fundamentals

SQL Server: How to Linked Server an Access Database

Below is the script to create a linked server to an Access database: EXEC master.dbo.sp_addlinkedserver @server = N'MyLinkedServerAccessDB', @srvproduct = N'Access', @provider = N'Microsoft.Jet.OLEDB.4.0', @datasrc = N'C:\MyAccessDB.mdb'   Plus you also need to create the linked server login.  What’s important to note here is that the password for the admin account in the Access database …

Continue reading SQL Server: How to Linked Server an Access Database