Wireless Zero Configuration is a Windows service on Windows XP and Windows Server 2003 that is used to configure and manage wireless network connections on a wireless adapter. The service name for Wireless Zero Configuration is WZCSVC. On Windows XP, the display name for the WZCSVC service is Wireless Zero Configuration. On Windows Server 2003, the display name for the WZCSVC service is Wireless Configuration.

The Wireless Zero Configuration service is normally started at boot time. The programming interface for the Wireless Zero Configuration service can be used only if the Wireless Zero Configuration service has been started. If the Wireless Zero Configuration service is not started, then the Wireless Zero Configuration functions will return an error.

To enable the Wireless Zero Configuration service so it starts up automatically, go to the Start button. Select the Settings option and then select Control Panel. If you are using the Windows XP view, select thePerformance and Maintenance category and then select Administrative Tools. If you are using the Classic View, then select Administrative Tools. Click the Services icon in the left pane. Click the Wireless Zero Configuration icon in the right pane and change the Startup Type dropbox to Automatic. This setting will set the service to start automatically at boot time. Then click the Start button to start the Wireless Zero Wireless Zero Configuration service and click the OK button.

The Wireless Zero Configuration can also be started and stopped from a command prompt. To start the Wireless Zero Configuration, run the following command:

net start wzcsvc

To stop the Wireless Zero Configuration, run the following command:

net stop wzcsvc

Note: Once you enable the WZC Service and reboot, it might not stay enabled. The following could be the reason. The following is from a Microsoft MVP:

Sunday, March 10, 2013

A SQL JOIN combines data from two or more tables based on matching keys indicated in the SELECT statement. Thematchingkeys are what creates the relationship between tables and uniquely identify the rows in a table.

INNER JOIN: This is the most common type of join and is considered the default join type. The inner join, sometimes referred to as an EQIJOIN, only brings back data that is a match between both tables being joined. In the example below:

SELECT statement states that we want all (*) columns from both tables.

FROM indicates the first table wanted.

INNER JOIN keyword specifies the other table we want to join to, the Orders table.

ON keyword is used in conjunction with the INNER JOIN keyword to indicate how the two tables are to be joined, in this example, the CustomerID of the Customers and Orders table. Customers.CustomerID and Orders.CustomerID is the format because the CustomerID name column is the same in both tables.

Example:

SELECT *

FROM Customers

INNER JOIN Orders

On Customers.CustomerID = Orders. CustomerID

note: If you fail to indicate the relationship between the two tables, you will end up with a Cartesian product. A Cartesian product causes each row from the first table to be multiplied by the total number or rows from the second table.

Thursday, February 21, 2013

It is possible for SQL queries to contain other queries, called subqueries. The values of one query are passed to another query.

Subqueries can be utilized in SELECT statements, as well as the INSERT, UPDATE, and DELETE statements.

Subqueries allow you to connect queries together, so that you can query more than one table at a time.

Subqueries can either be nested within another query or it can be connected to another query using a keyword. When the subquery is nested in a SELECT statement, the innermostquery is processed first. When a subquery is connected to another query using a keyword, the last subquery is processed first.

note: MySQL versions that are prior to version 4.1 do not support subqueries. MySQL uses JOINS to accomplish the same thing as subqueries.