Archive for November, 2009

3rd Party APP: Can’t locate Calendar/CalciumStart.pm

November 30, 2009

Brown Bear software error: Software error: Can’t locate Calendar/CalciumStart.pm in @INC (@INC contains: CalciumDir40/upgrades CalciumDir40/redist … Solution: A message like this means that Calcium can’t find its installation directory. The location of the Calcium source code files and data directory are specified in the main Calcium script; some installations will require the full path to [...]

Posted in Linux Maintenance, Windows | Comments Off

Linux: Enable VI syntax highlighting

November 28, 2009

Make sure you have vim-enhanced installed Run yum install vim-enhanced or within vi :syntax on

Posted in Linux Maintenance | Comments Off

SQL 2008 : Delete all tables in a db

November 27, 2009

Reference EXEC sp_MSforeachtable @command1 = “DELETE FROM ?” EXEC sp_MSforeachtable @command1 = “TRUNCATE TABLE ?” —— You won’t be able to run TRUNCATE against all tables if you have foreign keys references Here is one way to circumvent that – First disable referential integrity EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’ GO EXEC sp_MSForEachTable [...]

Posted in SQL | Comments Off

Windows: IExpress – Create exe files from batch scripts

November 27, 2009

Technote Summary : IExpress is a technology designed to simplify creation of a setup program. Using the step-by-step IExpress Wizard, you can create self-extracting files that automatically run the setup program contained inside. The setup program can be an .inf file or an executable program. IExpress technology automatically removes the setup files after installation, saving [...]

Posted in Windows | Comments Off

Linux: using auth keys to connect via ssh

November 23, 2009

Generate key on local machine ssh-keygen -t rsa It will ask you for a password but you can leave it blank. Note you could also pick -t dsa if you prefer. Ensure that the remote server has a .ssh directory Make sure the server your connecting to has a .ssh directory in your home directory. [...]

Posted in Linux Maintenance | Comments Off