MS SQL SERVER - The log file for database is full...

BACKUP LOG WITH TRUNCATE_ONLY
GO

MySQL Table Read Error

REPAIR TABLE <tablename>

Memory Leak Detection in C++

Few useful tools are -

01) dmalloc
02) ccmalloc
03) NJAMD
04) YAMD
05) Valgrind
06) mpatrol
07) Insure++

More info is available at http://www.linuxjournal.com/article/6556
Other Linux Development Tools - http://www.hotfeet.ch/~gemi/LDT/tools_deb.html

Install Guides for PHP, APACHE and Oracle

Windows
http://www.oracle.com/technology/tech/php/htdocs/inst_php_apache_windows.html
Linux
http://www.oracle.com/technology/tech/php/htdocs/inst_php_apache_linux.html

Oracle Database 10g Express Edition
10.2
http://www.oracle.com/technology/products/database/xe/

Apache HTTP Server
2.0.58
http://httpd.apache.org/download.cgi

PHP Hypertext Processor
5.1.3
http://www.php.net/downloads.php

Underground Guide for PHP n Oracle
http://www.oracle.com/technology/tech/php/pdf/underground-php-oracle-manual.pdf

Other PHP - Oracle Install Guides
http://www.oracle.com/technology/tech/php/index.html

CSS Tips

01) display:table - Makes Div to expand according to the data interms of height and width. Works well in IE, Firefox and Netscape.

Reset Identity Colum in MS SQL SERVER

DBCC CHECKIDENT('TABLENAME',RESEED,0);

Doxygen Tips

Here are few Doxygen tips -

01) EXTRACT_ALL - Set this to YES to pull the comments from non-class files.
02) PREDEFINED - Define the PreProcessor like D3_OBJECT_LINKS so that Doxygen can parse the content under them.

PHP 5.1.2 on Windows with ICE Enabled

Install Guide for PHP 5.1.2 with ICE on Windows 2003
=======================================
Install Process mentioned below is tested under environment.
Windows 2003
IIS 6.0
PHP 5.1.2

In order to install PHP 5.1.2 on Windows Server 2003 & configured the PHP on IIS.Here are the steps -

01. Download the source code, installer & binary of PHP 5.1.2 for windows. These are available at http://www.php.net/.
02. Run the installer in order to fetch all the dlls, which are unavailable in the binary, it will ask for the path use C:/PHP.
03. Use the binaries, extract the zipped folder & copy all the stuff to C:/PHP, you can check C:/PHP/ext will conatin all the dlls.
04. Move php5ts.dll to c:\windows\php5ts.dll.

Installation of PHP 5.1.2 on Windows Server 2003 is over. PHP5 is now installed on your computer, but you still need to configure it to work with IIS, which we will do in the next step.Now, configured the PHP on IIS -

01. Under Internet Information Services (IIS) Manager, right-click on "Web Service Extensions" in the menu on the left.
02. Then select "Add a new Web service extension..." from the list.
03. Put extension name as "PHP".
04. Browse the file, by clicking at ADD, use C:\PHP\php5isapi.dll for php extension( Used php5isapi.dll for php extension, to avoid CGI error ).
05. Make sure you check the "Set extension status to Allowed" checkbox.
06. In "Internet Information Services (IIS) Manager", left-click on "Web Sites" in the menu on the left and select "Properties". Next, select the "Documents" tab and click on "Add".To ensure that index.php documents open as a default they should be added as a "Content Page".
07. Copy php.ini-recommended from c:\PHP to C:\windows\phpini.

We have to upgrade the PHP for XSL and XSLT by entering the following into

c:\windows\php.ini - extension=php_xsl.dll & set extension_dir= "C:/PHP/ext".
After, this we will do the following for Ice extension for PHP:-

01. Install ICE Ice-3.0.0. This can be downloaded from http://www.zeroc.com/download.html.
02. Build the "IcePhp 3.0.1". (Use the source code for PHP5, for including the library paths) Dependency: Requires Ice for C++ and PHP 5.0.5 or 5.1.2. Here we are using PHP 5.1.2.IcePHP is available at http://www.zeroc.com/download.html.
03. Copy the php_ice.dll to the folder "C:/PHP/ext" from "IcePHP-3.0.1\bin\release".
04. Also copy all the dependencies of IcePhp Use Dependency Viewer Tool to identify this.
- icecpp.exe
- bzip2.dll
- msvcp71.dll
- msvcr71.dll
- ice30.dll
- iceutil30.dll
- slice30.dll
to c:/windows/system32.
05. After, this add the following lines in php.ini -extension=php_ice.dllice.slice = "-IC:/Development/APAL6/D3 C:/Development/APAL6/D3/D3I.ice -IC:/Development/APAL6/APAL3 C:/Development/APAL6/APAL3/APAL3I.ice"so that, the web pages can interact with the C++ APAL6 engine through ICE.
06. Also, make sure that, the PHP pages are using 07. Start the Service & enjoy the web pages on IIS!!.

Wiki - Three simple rules to edit pages

Here are three simple rules when people should know who edit pages on our Wiki server (not the basecamp server):

WordsWithCapitalLetters: All words with embedded capital letters are automatically treated as links to other documents. In this case, wiki would initially show the word wordsWithCapitalLetters like so (WordsWithCapitalLetters)? and allow you to click the hyperlinked question mark to edit/create the page. Once created, wiki would show the word like WordsWithCapitalLetters. The rule goes: if the first lowercase letter is preceeded by an uppercase letter and the word has more uppercase letters following the first lowercase letter the word will be hyperlinked.

((words between double braces)): All words enclosed with double braces are automatically treated as links to other documents. In this case, wiki would initially show the expression ((words between double braces)) like so (words between double braces)? and allow you to click the hyperlinked question mark to edit/create the page. Once created, wiki would show the word like words between double braces

D''''''ontLinkThis, A''''''ndThis, APAL3Test, allOrNothing, APAL3T''''''estCase, APAL3isCool: The six single quotes rule can be used to stop wiki from hyperlinking expressions which should not be hyperlinked. In these examples, wiki would strip the six single quotes simply display: DontLinkThis, AndThis, APAL3Test, allOrNothing, APAL3TestCases, APAL3isCool. The rule goes: if the first lowercase letter is preceeded by an uppercase letter and the word has more uppercase letters following the first lowercase letter the word will be hyperlinked unless you insert six single quotes immediately preceeding the first lowercase letter.

J2ME

Hi,

Got a chance to learn the J2ME from Experts. I hope it happens on Saturday (05/20/2006).
Looking forward to this.

Cheers

Projects I work on

APAL5 - SCM Domain - C++ Plateform Independent Daemon works on Windows, Linux n HP-UX.
AutoVLB - SCM Domain - C++ Windows Service.
Little bit on
APAL4 - SCM Domain - C++ Window Service.
APAL6(Future) - SCM Domain - C++ Plateform Independent Daemon works on Windows, Linux n HP-UX.

Details are available at www.warehouseoptimization.com