E-Volution IT

Recently I’ve been getting Error #429 when trying to run certain VBS scripts that attempt to make an ADODB.connection to a database on a Windows XP SP2 machine. The exact error I was getting was this:

Error #429 - Microsoft VBscript Runtime error
ActiveX component can’t create object: ‘ADODB.Connection’

I tried many things to fix this. What worked was the one of (or a combination of) the following, and perhaps it will fix this issue for you too.

TIP 1

1. Open a DOS command prompt. START –> RUN –> Type in “cmd” (without the “”)
2. Type in:  regsvr32 C:\Program Files\Common Files\System\ado\msado15.dll
   OR
   If that file is not found then try:
   regsvr32 C:\Program Files\Common Files\System\msado15.dll
3. If the above file is not found then go hunt for it manually in that Common Files directory and its sub directories.
4. Restart your computer once it is successfully registered.

TIP 2

Another thing to try:

1. Use regedt32 (from START –> Run –>) to find HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\Zones\0
2. Once there find the value 1201. If it is set to “1″ then change it to “0″

Check whether the registry edit is or is not what fixes this for you. If it does not then I recommend changing it back to 1. This 1201 setting is for allowing windows to “Initialize and script ActiveX controls not marked as safe” in the Local Computer Security Zone. If it is set to 1 it is meant to prompt you. If you set it to 3 then this is disabled completely. Setting it to 0 opens it right up which should not be an issue on a clean computer with a good virus scanner and the like.

TIP 3

Some people also found that “regsvr32 scrrun.dll” (at the DOS prompt) helped.

TIP 4

You may also want to try installing the latest Windows Scripting components from Microsoft:

Windows Script 5.6 for Windows XP and Windows 2000
Windows Script 5.6 for Windows 98/Me/NT 4.0