VFX: Working with SQL Server as backend

Create local foxpro database complete with its tables.
Create SQL version of the database with exact table names (must be in UPPERCASE?).
In VFX Cursor Adapter Wizard, select ODBC > Generate SQL Connection String.

Identify version and/or service pack level

How to identify your SQL Server version and edition
http://support.microsoft.com/kb/321185

Related
--------
Workaround for SQL 2000 Desktop edition database size limitation:
MSDE has a 2GB data file size limitation - but it only checks the file size when trying to GROW the data file.
You can restore a database created on Std Edition or Enterprise Edition that is ALREADY bigger than 2GB, and MSDE is OK with that. As long as you don’t run out of space in the data file (and MSDE doesn’t have to enlarge the file) you’ll be OK.
source: MSDE Database Limits

SQL 2000 Editions comparison:
Choosing the correct SQL Server 2000 edition

SQL 2000 edition that is free?
The downloadable version of 2000 is MSDE... Personal Edition is not free downloadable
source: Download SQL server 2000

MSDE 2000 Release A functionality is the same as MSDE 2000 SP3a
source: ReadmeMSDE2000A.htm downloaded from Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A

MSDE 2000 Release A: How to Use SAPWD switch to Suuply the SA pass

Is it legal to install Client Tools Only to manage MSDE?
I just called Microsoft and they said it was ok
source: MSDE and Client Tools from SQLServer Eval

UBUNTU: Switch to external display for laptop with ATI video card

How to: switch to external display for ATI on Ubuntu
http://blog.harmjans.com/2009/02/28/how-to-switch-to-external-display-for-ati-on-ubuntu/

Using external display (Projector, CRT, etc)

How to use linux laptop in presentations
www.astro.umd.edu/~teuben/linux/laptop-display.html

VMWARE: Some keyboard keys aren't working inside guest OS

Add this line to /etc/vmware/config:

nokeycodeMap = true

NTFS partition not recognized with full size after extend/resize

Check if the partition is already mounted...re-mount if necessary

VMWARE: NAT, Bridged, HostOnly

Bridged = your guest looks like just another PC on your network - visible to other machines.

NAT = your guest is hidden from other PCs on your network, but can get out to the network (and others can reach specific services on your guest via port mapping). This is just like a NAT router - whether hardware or software.

Host-Only = a private network between your host and guest. Your guest has no connection to the rest of the network, and no other PCs can reach your guest.

Source:
Where are the docs on what nat, bridge, host-only mean?
http://communities.vmware.com/thread/60459

VISTA: Cannot Extend volume from Disk Management

Use Diskpart:

How to work with partitions in Windows Vista / XP when Disk Management doesn’t work
www.vistarewired.com/2007/04/07/how-to-work-with-partitions-in-windows-vista-xp-when-disk-management-doesnt-work

E220: Setting GPRS XL

Profile Name: gprs xl
Auth. No.: *99#
Username: xlgprs
Password: proxl
DNS: Dynamic
APN: www.xlgprs.net
IP: Automatic
Auth. Protocol: PAP
WINS: Dynamic

showmyip.com: 202.152.243.39

BT4: Install VMware Server

How to install VMware Server on kernel version 2.6.38
http://radu.cotescu.com/vmware-server-kernel-2-6-38/
---
VMware Server
https://help.ubuntu.com/community/VMware/Server
---
How to install VMware Server 2.0 on Linux
http://phorolinux.com/how-to-install-vmware-server-20-on-linux.html/2
LINK IS DEAD!
---
Similar article with some useful info:
How To Install VMware Server 2 On Ubuntu 8.10
- step 'to install some necessary packages' failed but it's okay
- if failed on building vmmon module, refer to this info:
VMware-server 2.0.x Installation HOWTO for Karmic Koala (x86_64)
http://blog.mymediasystem.net/uncategorized/vmware-server-2-0-1-installation-howto-for-karmic-koala-x86_64/

After the successful installation, you can delete the VMware Server download file and the installation directory:

cd /home/falko/Desktop
rm -f VMware-server*
rm -fr vmware-server-distrib/
---

BT4: Launch Network Manager

/etc/init.d/wicd start

An icon will appears on lower right corner

BT5: Determine equivalent Ubuntu version

lsb_release -a
or
uname -a

Determine Kernel version:
KDE: System \ KInfoCenter

Error: Kernel panic: No init found

Boot using LiveCD

chroot to harddisk install, for example:
- mkdir /mnt/backtrack
- mount /dev/sda5 /mnt/backtrack
- mkdir /mnt/backtrack/boot
- mount /dev/sda6 /mnt/backtrack/boot
- chroot /mnt/backtrack /bin/bash

Examine /etc/lilo.conf

Adjust "root=" entry if necessary

BT4: Install to HDD (Dual-boot with existing Vista)

BT4 Beta & Windows 7 Ultimate Dual Boot Tutorial
http://forums.remote-exploit.org/showthread.php?t=20140

Self note:
To save Primary partition quota, put Swap in an Extended partition

Related:
How to dual-boot Kali Linux 1.0.9 and Windows 7/8 on a PC with UEFI firmware
Note to self:
An indicator that you have UEFI system is when you open Windows' Disk Management, you see a small partition with its Status says "EFI System..."

Millenium (ME): Cannot modify CONFIG.SYS

Even if additional file handles are needed by an MS-DOS-based program, the FILES setting does not function. Instead of the FILES setting, the PerVMFiles setting is used. This setting increases the number of available file handles in each MS-DOS virtual machine (VM) and is implemented by adding the following line to the [386Enh] section of the System.ini file:
PerVMFiles=number
In Windows Me, each MS-DOS VM is given the default FILES value of 30 file handles. The maximum number of file handles a VM can have is 255. Because the total number of file handles cannot exceed 255, the maximum PerVMFiles setting is 225. This value, plus the 30 made available by default, equals the maximum total of 255. You must restart Windows Me for this change to take effect.

Source:
How to Increase Available File Handles for MS-DOS-Based Programs in Windows Millennium Edition
http://support.microsoft.com/kb/269030

Warehouse Entries: Determine if a Pick entry already has a matching Shipment row

Use "Whse. Document Line No." column

Repair corrupted DBF

Xitech FoxFix V5.1
Name: CLUSTER Company: PRiME Product ID: XIFF-50-E64B3524-6288-X Activation Key: 1CF36288
Name: CLUSTER Company: BLiZZARD Product ID: XIFF-50-19B4A948-D699-X Activation Key: 0952A4AF

FoxFix
www.4shared.com/get/J53olYjH/FoxFix.html;jsessionid=B0846CBC1446769DD8F1DC824AD70840.dc332

UDFFix Rec Count
http://fox.wikis.com/wc.dll?Wiki~UDFFixRecCount

Not ATable
http://fox.wikis.com/wc.dll?Wiki~NotATable

Experience:
Trying above solutions with table containing unicode characters >> NO SUCCESS

Simple solution:
Using hex editor, edit record-count info on file header to original value minus one.
To determine current record-count in the example above, type hex-value '1FE' on calculator then convert it to decimal.

Another solution (requires Windows 9x):
using Filefix (if you experience "illegal..." error, start Windows without GUI --> msdos.sys --> BootGUI=0)

OUTLOOK: Error "...address list could not be displayed..."

Fix for The address list could not be displayed error in Outlook
www.windowsreference.com/ms-office/fix-for-the-address-list-could-
not-be-displayed-error-in-outlook/

Additional note for this section:
Click to select the Show this folder as an e-mail Address Book check box (if it is not already selected), and then click OK.

If it is ALREADY selected but the error persists, unselect it, click Apply, select it then click OK.

VFP9: Install SP2 Final over its Beta

You CAN'T!

Neither SP2 CTP nor SP2 BETA have uninstallers. So, have in mind that you'll need to reinstall VFP9 when you want to update or go back to SP1 for any reason.
Source: http://weblogs.foxite.com/vfpimaging/archive/2007/08/11/4520.aspx

GPRS setting for various provider in Indonesia (Indonesian)

Setting GPRS dan MMS Telkomsel, Indosat, XL, dan 3
www.selular.co.id/konsultasi/4id94.html

Artikel/Cara Setting GPRS/3G
www.pc24.co.id/catalogue/category129_1.htm

Softwares for mobile phones

www.getjar.com

Report: Hide certain data item from request form

To hide the Item's filter screen you must make sure that the Item's ReqFilterFields is "UnDefined" and DataItemTableView MUST be set to an appropriate key.

Source: www.mibuso.com/forum/viewtopic.php?f=23&t=21275&start=0

Protecting Flash and Hard disk from being infected (Indonesian)

Tips Mencegah Flash Disk & Hard Disk tertular virus
http://hermansy.wordpress.com/2009/03/29/tips-mencegah-
flash-disk-hard-disk-tertular-virus/

Reseting Passwords on Windows XP and Vista Using BackTrack 4

1. Open the BackTrack Folder from the Menu.
2. Open Privilege Escalation
3. Open PasswordAttacks
4. Click on “chntpw”
5. Type in “chntpw -i /mnt/hda1/Windows/system32/config/SAM”
1. You may have to change the “hda1″ to something else such as hdb1, sda2, sdb3. Try a few different combination until you can get it, or ask me for help.
6. Press “1″
7. I want to remove my password, and my username is simply “phr0z3n”. So here, I will type in “phr0z3n”.
8. Press “1″ to clear the password. If all is well, it should say “Password cleared!”
9. Again, lets type in our name, mine is still “phr0z3n”.
10. Press “4″.
1. The reason behind why we do this? Sometimes the account will get locked after we change the password, so we want to make sure we unlock it before we save the changes and boot back up to Windows.
11. Type “!”
12. Type “q”
13. You will be asked, “Write hive files? (y/n) [n] : “ We want to press “y” for yes.

Source: http://cyberterrorists.net/forum/viewtopic.php?f=19&t=12407

Installing and using UNetbootin

Create a Bootable USB Drive or Memory Card
http://tombuntu.com/index.php/2008/08/27/create-a-bootable-usb-drive-or-memory-card/

Burn ISO to usb

ISO image to USB flash
www.tomshardware.com/forum/243423-32-image-flash

Password Recovery

http://www.petri.co.il/excel-password-recovery.htm
http://www.petri.co.il/word-password-recovery.htm

Crack Sheet Protection Password
www.theofficeexperts.com/VBASamples/Excel02.htm

Remove the (unknown) password from a document protected for forms
www.gmayor.com/Remove_Password.htm#Alternative

DSL Router/Modem: Check SNR/Attenuation

Corega: Status > Device Info

Comtrend/Broadcom: Device Info > Statistics > ADSL

General rule:
SNR: 25 or higher (higher is better)
Attenuation: 10 or lower (lower is better)
Good info: Kenali Kualitas Jaringan Speedy Anda

Force Windows to update registry backup

How to back up, edit, and restore the registry in Windows 2000
http://support.microsoft.com/kb/322755
--------------------------------------------------------------
...
Note that if you use the option to back up the registry when you create an ERD, Backup also creates updated copies of the registry files in the %SystemRoot%\Repair\Regback folder. If you cannot start Windows 2000 after you edit the registry, you can manually replace the registry files in the %SystemRoot%\System32\Config folder with the copies in the %SystemRoot%\Repair\Regback folder by using Recovery Console.


How to Update the Repair Folder in Windows XP Using NTBackup
www.winhelponline.com/blog/update-repair-folder-xp-using-ntbackup/
------------------------------------------------------------------
...
7. When the Backup Status changes to Backing up files from your computer…, click the Cancel button to stop the System State Backup operation. By that time, the Repair folder would have been updated.

2000 Pro: Missing/corrupted...system32\config\system...

Windows 2000 Registry Repair Utility
http://bink.nu/news/windows-2000-registry-repair-utility.aspx

Self experience:
If you're lucky enough, you can find registry backup in winnt\repair folder.
When you do, put the harddisk of the troubled computer to another computer (OR use boot/live CD) and restore registry from that folder using copy procedure.
But perhaps you want to make sure that the registry backup file's date is not too far from the current one.

Disassemble Toshiba Satellite Pro 4200

www.bixnet.com/toshiba2.html

www.eserviceinfo.com/downloadsm/5211/Toshiba_4200%20/%204300.html

General google keyword:
manual|guide|how disassemble|replace|repair satellite 4200|4260

Controls in pages of pageframe are not refreshed until they receive the focus

PRB: Controls in a Page Frame Are Not Refreshed
http://support.microsoft.com/kb/132179

Understanding code that behaves strangefully

Put this before line(s) of code in question:

SET COVERAGE TO [ADDI]

and this after:

SET COVERAGE TO

BackTrack

How to make Backtrack 4 persistent installation on USB disk drive
www.itsolutionskb.com/2009/04/how-to-make-backtrack-4-persistent-
installation-on-usb-disk-drive/

Networking: Add static route

ip route add 192.168.2.0/24 via 192.168.1.254

Source:
How do you add a route to Linux (www.experts-exchange.com/Networking/Linux_Networking/Q_21195972.html)

Google keyword: add static route backtrack|linux|slax

Modem Extra Settings for various provider in Indonesia

SETTING Dial UP INTERNET di Laptop/PC
http://dani-sofian.blogspot.com/2009/04/setting-dial-up-internet-di-laptoppc.html

Windows Update: Limit WindowsUpdate.log size

UPDATE on Mar 9, 2015:

The logfile is supposed to be maintained by the WUAgent. It's a rotating log file and should auto-rotate approximately every 30 days or at 2MB size [so NO automatic truncation needed?]
(from How to empty or reduce the size of the Windows Update Log?)


No solution found yet!

Workaround:
Create file named, for example, startup.cmd containing these commands:
net stop wuauserv
del %windir%\WindowsUpdate.log
net start wuauserv

Assign that file as Machine (computer) startup script using gpedit.msc (local) or Group Policy Management (domain)