31 October 2013
How to determine whether a computer is running a 32-bit version or 64-bit version of the Windows operating system
http://support.microsoft.com/kb/827218
29 October 2013
Database is Read-Only
Problem: After attaching a database to MS SQL Server, the database is displayed as 'Read-Only'.
Description: I created a folder on volume E:\, and put the database I downloaded from SysAid in the folder. After I attached the database to MS SQL Server, the database was displayed as 'Read-Only'.
Solution: Grant 'Everyone' 'Full Control' access to the folder, then attach it.
Description: I created a folder on volume E:\, and put the database I downloaded from SysAid in the folder. After I attached the database to MS SQL Server, the database was displayed as 'Read-Only'.
Solution: Grant 'Everyone' 'Full Control' access to the folder, then attach it.
28 October 2013
How to open an .mdf file? (How to attach a database to MS SQL Server?)
http://www.youtube.com/watch?v=rhIr9Qf-oHw
24 October 2013
Can NOT send emails to a person from Office Outlook, but can from Outlook Web App
Exchange server email accounts
Can NOT send emails to a person from Office Outlook, but can from Outlook Web App
Cause: Outlook saves a cache (offline) address book. It seems to take one or two days to update the cache. After the update, we can send emails to the person from Outlook.
Solution: We can not wait one or two days before sending emails to the person. Click Tools | Account Settings | Change. Clear the check mark in front of 'Use Cached Exchange Mode'. Re-start Outlook.
Can NOT send emails to a person from Office Outlook, but can from Outlook Web App
Cause: Outlook saves a cache (offline) address book. It seems to take one or two days to update the cache. After the update, we can send emails to the person from Outlook.
Solution: We can not wait one or two days before sending emails to the person. Click Tools | Account Settings | Change. Clear the check mark in front of 'Use Cached Exchange Mode'. Re-start Outlook.
21 October 2013
Woodside Copier Driver Installation
Woodside copier driver installation
* Download the driver from Sharp website - MXM260_Win32_SPLC_En_1305a.exe
Note: MXM260_Win32_PCLPS_En_1305a.exe would not work.
* Run it.
* Select 'Connected via network'.
* Select 'LPT1'.
* Add port - 192.168.6.196
* Select 'Custom'. In 'Settings', change 'Raw' into 'LPR' (as long as it is a copier, then change 'Raw' into 'LPR', otherwise you will often meet 'Offline' problem.
* LPR settings - type in 'lp' in Queue Name.
* Done.
* Download the driver from Sharp website - MXM260_Win32_SPLC_En_1305a.exe
Note: MXM260_Win32_PCLPS_En_1305a.exe would not work.
* Run it.
* Select 'Connected via network'.
* Select 'LPT1'.
* Add port - 192.168.6.196
* Select 'Custom'. In 'Settings', change 'Raw' into 'LPR' (as long as it is a copier, then change 'Raw' into 'LPR', otherwise you will often meet 'Offline' problem.
* LPR settings - type in 'lp' in Queue Name.
* Done.
14 October 2013
Reset Forgotten MySql root Password Under Windows
http://www.jovicailic.org/2012/04/reset-forgotten-mysql-root-password-under-windows/
If you forgot root password for your MySQL database server running under Microsoft Windows, there is still a way to access your database and even reset your password using the command prompt.
Follow next steps:
1. Stop your MySQL server completely. This can be done from Wamp(if you use it), or start “services.msc” using Run window, and stop the service there.
2. Open your MS-DOS command prompt using “cmd” inside the Run window. Then go to your MySQL bin folder, such as C:\MySQL\bin. Path is different if you use Wamp.
3. Execute the following command in the command prompt:
5. Go to your MySQL bin folder again.
6. Enter “mysql” and press enter.
7. You should now have the MySQL command prompt working. Type “use mysql;” so that we switch to the “mysql” database.
8. Execute the following command to update the password:
After you are finished close the first command prompt, and type “exit;” in the second command prompt.
You can now start the MySQL service. That’s it.
If you forgot root password for your MySQL database server running under Microsoft Windows, there is still a way to access your database and even reset your password using the command prompt.
Follow next steps:
1. Stop your MySQL server completely. This can be done from Wamp(if you use it), or start “services.msc” using Run window, and stop the service there.
2. Open your MS-DOS command prompt using “cmd” inside the Run window. Then go to your MySQL bin folder, such as C:\MySQL\bin. Path is different if you use Wamp.
3. Execute the following command in the command prompt:
mysqld.exe -u root --skip-grant-tables4. Leave the current MS-DOS command prompt as it is, and open a new MS-DOS command prompt window.
5. Go to your MySQL bin folder again.
6. Enter “mysql” and press enter.
7. You should now have the MySQL command prompt working. Type “use mysql;” so that we switch to the “mysql” database.
8. Execute the following command to update the password:
(UPDATE user SET Password = PASSWORD('your_new_passowrd')
WHERE User = 'root';)
UPDATE user SET authentication_string = PASSWORD('your_new_passowrd')
WHERE User = 'root';However, you can now run almost any SQL command that you wish.
After you are finished close the first command prompt, and type “exit;” in the second command prompt.
You can now start the MySQL service. That’s it.
Subscribe to:
Posts (Atom)