Setup wireless windows Vista Laptop

I have a Dell Latitude D630 and I bought a new internal hard drive and installed windows Vista. However I could not get the computer to detect the wireless driver much less a internet connection. Here how I solved this issue.

I download software from this site ftp://ftp.dell.com/Pages/Drivers/latitude-d630.html

Install the Dell Notebook System Software and the Intel Mobile Chipset first. These MUST be installed first or the rest of the drivers will fail to install. The rest of the order is not as crucial.

Broadcom 57XX Gigabit Integrated Controller


Dell Wireless 1390 WLAN MiniCard


Dell Wireless 360 Module with Bluetooth 2.0 + EDR


Intel (R) Wireless WiFi Link 4965AGN

Dell QuickSet

but I only installed (in this order):
R143625.exe
R153997.exe
R151327.exe
Dell_Wireless-360-Module-wit_A01_R155395.exe
DELL_MULTI-DEVICE_A37_R295615.exe

computer: Dell Latitude D630
wireless driver: broadcom BCM94321MC
operating system: Windows Vista 32-bit

screenshots:

resources:
http://en.community.dell.com/support-forums/network-internet-wireless/f/3324/t/19357178.aspx

tags:
enable
Wifi issues

Setting up driver for Breakout Board for FT232RL USB to Serial

Read the explanation
http://www.ftdichip.com/FTDrivers.htm

I picked VCP Driver
http://www.ftdichip.com/Drivers/VCP.htm

Download the Windows* driver .zip
http://www.ftdichip.com/Drivers/CDM/CDM%202.08.24%20WHQL%20Certified.zip

extracted the zip to my desktop

Went to my device manager
Location: Control Panel\System

Found the device under “Other devices”

Right clicked on “USB Serial Port”

Selected “Update Driver Software”

Selected “Browse my computer for driver software”

Browsed to the extracted folder on my desktop
C:\Users\Desktop\CDM 2.08.24 WHQL Certified

Clicked next

Then wala, your done, its installed

tags:
step by step, installing drivers, arduino, breadboard, bearbones

Create saved query in MySQL, nesting

Microsoft Access has a nice feature which lets you create queries and also link them together. This can also be done with other platforms like MySQL however the difference is individual queries cannot be saved and later linked, it must be all done in one script. Its basically multiple “SELECT * FROM” in one query.

Examples
Microsoft Access:
SELECT *
FROM table
INNER JOIN saved_query
ON table.field = saved_query.field;

MySQL:
SELECT *
FROM table as T
INNER JOIN
(SELECT * FROM another_table) as P
ON T.field = P.field

The difference between the two examples is MySQL needs to nest any additional query and also name each (eg: as T).

It’s a lot easier for me to write a query in Access. What I did was take the Access SQL code and replace (copy and paste) the saved queries with the full code.  See the complex example below.

Access code:
SELECT year.Year, [how many dividends were paid a year].*, [Price average per year].ticker, [Price average per year].AvgOfhigh, [how many dividends were paid a year].[sumofdividend]/[Price average per year].[AvgOfhigh]*100 AS yield
FROM ([year]
LEFT JOIN [how many dividends were paid a year]
ON year.Year = [how many dividends were paid a year].year)
LEFT JOIN [Price average per year]
ON year.Year = [Price average per year].year
WHERE ((([Price average per year].ticker)=[how many dividends were paid a year].[ticker]))
ORDER BY [Price average per year].ticker;

MySQL code:
SELECT t.Year, p.*, k.ticker, k.AvgOfhigh, p.`sumofdividend`/k.`AvgOfhigh`*100 AS yield
FROM (year as t
LEFT JOIN (SELECT dividend.ticker, Count(dividend.ticker) AS CountOfticker, Left(dividend.Date,4) AS year, Sum(dividend.dividend) AS SumOfdividend
FROM dividend
GROUP BY dividend.ticker, Left(dividend.Date,4)
ORDER BY dividend.ticker ) as p
ON t.Year = p.year)
LEFT JOIN (SELECT price.ticker, Left(price.Date,4) AS year, Avg(price.high) AS AvgOfhigh
FROM price
GROUP BY price.ticker, Left(price.Date,4)) as K
ON t.Year = k.year
WHERE (((k.ticker)=p.ticker))
ORDER BY k.ticker

the most common error I encounter during the conversion was that semicolon(;) and MySQL doesn’t use brackets([])

Tags:
inner join another query,  create saved query in mysql, link queries, relationship multiple queries, connect query to one another, save query as table
nesting

Connect Access 2010 to MySQL

If you want to be able to use the tools found in Microsoft Access 2010 with your MySQL data here is how to do it.

1. You need download and install Connector/ODBC
2. Once installed open Access and click on OBDC Database under External Data, and select “Link to the data source by creating a linked table”.

3. Under “Machine Data Source” click “New”

4. Click Next

5. Select MySQL OBDC 3.51 Driver and click Next

6. Click Finish

7. Input your database data

 

For additional information go to http://www.washington.edu/itconnect/web/publishing/mysql-access-3.5.html

>SSH in Windows

>One might ask “why do you need ssh?” And if you don’t know what ssh is, learn it? It’s very useful, you’ll thank me someday.

The problem I was having is that ssh is shipped with Unix operating systems such as Linux and iOS but not on Windows. What if I need to securely access my files on my Windows computer, what will I do? No worries you can have ssh on on Windows but it takes extra work. You’ll need to install cygwin a Unix-like environment and command-line interface for Windows. Click Me for detailed instructions on how to set it up.

>Hide a file in Windows

>There various ways to make a file hidden in windows but the example below will make it really hidden, it’s like magic.

open CMD

To select file:
C:\Users\Fel\Dektop>attrib [filename] +h +s

The file will disappear. You cannot find it in the GUI or the CMD when dir command is used. It also will not show if you have the “show hidden files” selected in the folder options. (make sure you hide it first to make it work)

Now for the prestige (bring it back)

C:\Users\Fel\Dektop>attrib [filename] -h -s