Okay … So on Windows 7 sometimes after installing WAMP you have an issue starting the WAMP Server. This is caused by port 80 using used by IIS. So to change the Apache port for WAMP complete the following:
How to change WAMP server port number windows 7
Go to c:\wamp\bin\apache\Apache (your version)\conf
Open httpd.conf file
Search for Listen 80
Change the line “Listen 80” to “Listen 8080” (or Listen You can use any no)
Save the file and close it
Then open http://localhost:8080/ , next to the localhost place the port no you changed in the httpd.conf file
This solution is really helpful to use both IIS and WAMP server.
Okay, so I love having recovery tools on a bootable USB drive.
One of my life savers is Hiren Boot Tools (Download the ISO here). Then I had a great idea. What I’ll do is buy a HUGE 64GB USB flash thumb drive and make different partitions. I.e. one for Hiren, one for Windows 7 Installer, one for BackTrack (for you know what – wireless sniffing), one for Ubuntu etc. However I came into a bit of an issue. On Windows only the first partition is identified, however on MacOsX or Linux (Unix) all the partitions are found. However, I’m currently working on more Windows machines. So after some research I came across Yumi Multi Boot Loader.
I highly recommend the app … it runs multiple loaders on a single partition and does it very neatly.
Creating a YUMI Multiboot MultiSystem Bootable USB Flash Drive
YUMI works much like Universal USB Installer, except it can be used to install more than one distribution to run Live from your USB. Distributions can also be uninstalled using the same tool!
Start up SQL Anywhere Services from command prompt on NT
There are cases when customer would like to start up a SQL Anywhere Services at a specific time or after a database backup. The following is a way to start up a SQL Anywhere Services from outside Sybase Central or NT Services (as in Control Panel, Servi
Open the 32-bit registry editor (C:\WINNT\system32\regedt32.exe).
On the taskbar, click on “Start” then select “Run”. Type in regedt32 or regedit.
Double click on HKEY_LOCAL_MACHINE -> SYSTEM -> CurrentControlSet -> Services
For ASA versions 6.x.x/7.x.x/8.x.x, scroll down until you see ASANY. For SQL Anywhere version 5.x.x, scroll down until you see SQLANY. Any services created in SQL Anywhere Service Manager (or from Sybase Central) should be listed here.
The name of each individual service would appear as
ASANYx_y or SQLANYx_y
where ‘x’ represents the Service Type:
a – Sample Application
c – Client
e – Standalone Engine
l – Agent for Replication Server
o – Open Server Gateway
r – SQL Remote Message Agent
s – Network Server
and ‘y’ represents the Service Name as seen in the ‘Name’ column in Sybase SQL Anywhere Service Manager.
Find out which key is for the service you want to start from the DOS prompt. Write down the name of the key. Note that the key is
Case sensitive for version 5.x.x but is not case sensitive for version 6.x.x/7.x.x/8.x.x.
In DOS, the command to start up any registered NT Services (which include SQL Anywhere/Adaptive Server Anywhere Services) is ‘net start’.
Therefore, the syntax to start up a SQL Anywhere Service from a command prompt (DOS prompt) would be:
net start <key for the service from registry editor>
Similarly, the NT command to stop any registered NT Services is ‘net stop’
Therefore, the syntax to stop a SQL Anywhere/Adaptive Server Anywhere Service from a command prompt (DOS prompt) would be:
net stop <key for the service from registry editor>
Working in Saudi, we need to adapt to using the Saudi keyboard and numerals. When installing MS Office 2010 by default (after installing the Arabic Keyboard in Windows) – Arabic text is displayed correctly, however Arabic numerals are typed in the base language i.e. English. To fix …
In Word 2010:
– Go to File > Options > Advanced.
– Scroll down to the Show document content section – you will find the Numeral option. Set it to Context.
Ever have a list of data and want to quickly check for duplicates. Now I know it’s possible in SQL or even Excel but if you looking for a really easy online way without tweaking check out http://www.somacon.com/p568.php – Paste your data in the form click on Display / Update Counts and view the results …