Category Archives: Tips & tricks

Informix Tips & tricks

Error: Unable to load DLL (iclit09b.dll)

Problem:

An unhandled exception of type ‘System.DllNotFoundException’ occurred in ibm.data.informix.dll

Additional information: Unable to load DLL (iclit09b.dll).
The type initializer for \”IBM.Data.Informix.IfxConnection\” threw an exception.

The system Operating is Windows 2003 Server with Share point and
the server informix is INFORMIX-SQL Version 7.30.HC4

Solution:

If you are trying to use IBM.Data.Informix (Client 2.81 TC3, 2.9, 3.5, etc.) from IIS, and you still have this problem, I have a solution. I found that IIS 5.1 has a bug!!. IIS cannot read the entire PATH environment variable if it’s too long (my PATH has 1364 characters). So if your informix dir is near the end of your PATH and your PATH is too long, IIS will never read your informix dir (“C:\Program Files\IBM\Informix\Client-SDK\bin”).

Just put your informix dir at the beginning of your PATH variable, and very important execute an “iisreset” and the issue will gone away. I don’t know if this bug remains in IIS 6.0 or later. But you can try this.

If I’m correct this will help to solve other problems when you’re trying to access unamanaged dlls from IIS:
“Unable to load DLL ‘foo.dll’: The specified module could not be found.”

Source link

ASP.Net Tips & tricks

vbc : warning BC40010

error message:
I get this message when building my Assembly :

————————————————————————————–

Updating references…
Performing main compilation…
vbc : warning BC40010: Possible problem detected while building assembly ‘asdasd’: Referenced assembly ‘asdasd’ is a localized satellite assembly
Building satellite assemblies…

—- Done —

Rebuild All: 2 succeeded, 0 failed, 0 skipped

————————————————————————————–

The assembly you are building is localized differently than the assembly that are referencing.

This probably means that somewhere in the source code for “asdasd” you have an AssemblyCultureAttribute that is present. Code assemblies should never have this attribute — if you remove it, the problem should go away.

source: http://forums.asp.net/p/338021/355306.aspx#355306

Microsoft SQL Server Tips & tricks Transact-SQL

SQL to Select a random row from a database table

Select a random row with MySQL:

SELECT column FROM table
ORDER BY RAND()
LIMIT 1

Select a random row with PostgreSQL:

SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1

Select a random row with Microsoft SQL Server:

SELECT TOP 1 column FROM table
ORDER BY NEWID()

Select a random row with IBM DB2

SELECT column, RAND() as IDX 
FROM table 
ORDER BY IDX FETCH FIRST 1 ROWS ONLY

Select a random record with Oracle:

SELECT column FROM
( SELECT column FROM table
ORDER BY dbms_random.value )
WHERE rownum = 1

source link: http://www.petefreitag.com/item/466.cfm
Tips & tricks

Acordo ortográfico e Microsoft Word 2010

O novo acordo, que vai entrar em vigor até 2014, para activar a opção no Word 2010 Português basta navegar até ao Menu Ficheiro, seguido de Opções e item Verificação. Depois seleccionar a opção Modos de Português de Portugal : Pós-Acordo

word2010ao


para converter textos automáticamente para o novo acordo ortográfico pode utilizar o programa Lince

http://www.portaldalinguaportuguesa.org/index.php?action=lince

ArcGIS Tips & tricks

ArcGis 10.0 License Manager error

When trying to set / change license manager on the remote machine, ArcGISAdmin gives an error saying my server “is an invalid hostname. Please enter a valid hostname.”

Normally this error is due to firewall restrictions ArcGIS Server.

Tips & tricks Utils

Error installing SQL Server 2008 Native Client (HRESULT:0x800736FD)

Problem solved changing the registry key.

Ckeck if the “Windows Modules Installer” service is started. If not, and you receive an error “1450 Insufficient System resources” error, when trying to start it, then it is the origin of the problem.
To solve it:

1) Open regedit and replace the following value:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control

Key: RegistrySizeLimit

Type: REG_DWORD

Value: 0xFFFFFF (4294967295)

2) Reboot

3) Open a command prompt as administrator and run SFC /SCANNOW to check the integrity of system modules.

4) Install pending windows updates (surelly there are many of them)

Tips & tricks

Erro ao instalar Software de Hp Photosmart M525

Erro:

Falta de DLL slbcsp.dll e sccbase.dll

Resolução:

read more »

Outlook Tips & tricks

How to clear Outlook Contact history (auto display after TO:)

Short answer: Delete your NK2 file.

Slightly longer answer: In the C:\Documents and Settings\<user

name>\Application Data\Microsoft\Outlook directory there should be a file

with an NK2 extension. Deleting it should clear the auto-suggestion cache.

Tips & tricks

Date format in mail merge

If you Alt and F9 you will see the MergeFormat Field on your Word document.

If you type \@”dd/MM/yyyy” at the end of the field the date is displayed in that format.

To get the date format you want, you can add a formatting picture switch. In Word:
. select the mergefield;
. press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD MyDate} where ‘MyDate’ is your mergefield’s name;
. delete anything appearing after the mergefield’s name and add ‘\@ “d MMMM yyyy”‘ to the field, as in {MERGEFIELD MyDate \@ “d MMMM yyyy”}. With this switch your date will come out as ‘2 August 2008’. Other possible date formatting switches include:
. \@ “dddd, d MMMM yyyy”;
. \@ “ddd, d MMMM yyyy”;
. \@ “d MMM yyyy”;
. \@ “dd/MMM/yyyy”;
. \@ “d-MM-yy”;
Note: you can swap the d, M, y expressions around, but you must use uppercase ‘M’s for months.
. position the cursor anywhere in this field and press F9 to update it;
. run your mailmerge.

Tips & tricks Windows 7

GodMode no windows 7


Enable ‘GodMode’ in Windows 7More bloopers are a click away

So it turns out there are a list of folder “Codes” that you can add to the end of a folder name to create all sorts of special folders. Check out the list of codes here:

{00C6D95F-329C-409a-81D7-C46C66EA7F33}
{0142e4d0-fb7a-11dc-ba4a-000ffe7ab428}
{025A5937-A6BE-4686-A844-36FE4BEC8B6D}
{05d7b0f4-2121-4eff-bf6b-ed3f69b894d9}
{1206F5F1-0569-412C-8FEC-3204630DFB70}
{15eae92e-f17a-4431-9f28-805e482dafd4}
{17cd9488-1228-4b2f-88ce-4298e93e0966}
{1D2680C9-0E2A-469d-B787-065558BC7D43}
{1FA9085F-25A2-489B-85D4-86326EEDCD87}
{208D2C60-3AEA-1069-A2D7-08002B30309D}
{20D04FE0-3AEA-1069-A2D8-08002B30309D}
{2227A280-3AEA-1069-A2DE-08002B30309D}
{241D7C96-F8BF-4F85-B01F-E2B043341A4B}
{4026492F-2F69-46B8-B9BF-5654FC07E423}
{62D8ED13-C9D0-4CE8-A914-47DD628FB1B0}
{78F3955E-3B90-4184-BD14-5397C15F1EFC}

And, as a reminder, to create the God mode folder itself, use this string:

{ED7BA470-8E54-465E-825C-99712043E01C}

All you need to do is create a new folder with any name, then a period, then one of the text strings above. For example, the first one could be a folder named “AskTheAdmin.{00C6D95F-329C-409a-81D7-C46C66EA7F33}” (use everything inside quotes–but not the quotes themselves).

This should make customizing your Windows 7 machine a lot easier!