Error in Opening database - Tables ( SQL 2000)

Re-register the following DLLs by using Regsvr32.exe, and then restart the computer:

C:\Program files\Common Files\System\ADO\Msado15.dll
C:\Program files\Common Files\System\Ole Db\Oledb32.dll
C:\Program files\Common Files\System\Ole Db\Sqloledb.dll
C:\WINNT\System32\Atl.dll

Use Regsvr32.exe to register the preceding DLLs.

For example, at the command prompt type (or) copy & paste and Enter OK

C:\>regsvr32 C:\Program Files\Common Files\System\ADO\Msado15.dll
C:\>regsvr32 C:\Program Files\Common Files\System\Ole Db\Oledb32.dll
C:\>regsvr32 C:\Program files\Common Files\System\Ole Db\Sqloledb.dll
C:\>regsvr32 C:\WINNT\System32\Atl.dll

Read More

Icons, task bar disappears and Windows Explorer does not start

The problem is related to disappearing of desktop icons and task bar on windows startup. In some cases even when the user tries to open windows explorer by new task-option in task-manager the explorer flashes for a second but doesn’t start properly.

Let’s see how can we solve this problem.

Fix:

There are different types of methods which you can follow to repair your windows to show desktop icons properly.

Normally this problem of disappearing of desktop icons caused by the virus called called F-Nimda which creates a file named bxomebc.exe which aborts the windows explorer from starting. But this problem could be due to the corrupted registry also.

 Let’s discuss the possible solutions one by one.

 Firstly before following any of the methods given below download the F-Nimda virus removal tool.

 Method 1:

1. Start Windows XP, after starting press Ctrl+Shift+Esc to launch task manager.

2. Click File menu and select “New Tasks (run…)”

3. Now type CMD and click OK, this will open command prompt.

4. Type following command on command prompt:

Reg add “HKLM\SYSTEM\CurrentControlSet\Services\RpcSs” /v ObjectName /t REG_SZ /d LocalSystem and press enter.

Note: You can also try downloading this registry entry in order to re-enable the showing of your desktop icons. Download from here, double click and press OK button to merge it in registry.

 Method 2:

Start Windows XP, after starting press Ctrl+Shift+Esc to launch task manager.

2. Click File menu and select “New Tasks (run…)”

3. Now type CMD and click OK,this will open command prompt.

4. Type cd %SystemRoot% and press enter.

5. Now rename the file Shdocvw.dll file by typing ren shdocvw.dll shdocvw.old and press enter.

6. Restart windows.

 Method 3:

1.Download this shell fix registry settings from here , merge it into the registry by double clicking the downloaded file and press OK.

2. Download process explorer from here and run it.

3. Locate a process called bxomebc.exe in process explorer, end this process and delete the file from its location (You will get to know the file path by taking mouse over the process).

4. Restart your computer.

We hope at least one of fixes provided above will help you fix the trouble.

source : http://www.troublefixers.com/

Read More

Tips for Strong Password

        A secret series of characters that enables a user to access a file, computer, or program is Password. On multi-user systems, each user must enter his or her password before the computer will respond to commands. The password helps ensure that unauthorized users do not access the computer. In addition, data files and programs may require a password.

Ideally, the password should be something that nobody could guess. In practice, most people choose a password that is easy to remember, such as their name or their initials. This is one reason it is relatively easy to break into most computer systems. Here are 10 tips for creating strong password.

1. Use a strong password. A strong password contains a combination of six or more uppercase and lowercase letters, plus punctuation and numbers. Using all four types ofcharacters works the best. For example instead of using welcome use W3Lc0mE^9.

2. Passwords should be eight or more characters in length. The longer the password, the harder it is to crack.

3. Never use the same password twice. If, for example, your eBay account were hacked and your password obtained, the hacker would have instant access to your PayPal account if you use the same password.

4. Do not use common information in your password, such as birthdates, your phone number, or other information directly related to you.

5. Passwords comprised of characters rather than proper words are more secure.

6. Refrain from writing passwords down and do not login to accounts via a public computer (e.g., at the library or Internet cafe) and save the password details in the browser.

7. Never click an e-mail link and log into a secure site from an e-mail. Even if the e-mail looks legitimate, always type the URL into a browser yourself, then log in to your account. This will help you avoid phishing attacks.

8. Do not allow applications to store your passwords online, and remember to clear your browser cache, history and clear passwords frequently.

9. Remember to change your passwords frequently. The more important the account, the more frequently the password should be changed.

10. Never communicate a password to anyone, especially via e-mail or instant messenger. Passwords should always be kept private.

Courtesy: http://doputtur.blogspot.com/

Read More

Disable Network Search by XP

By default, Windows XP monitors shared resources on the network to make it easier to connect to a shared resource. This feature, in Windows XP, is implemented by periodically scanning the computers on the network. During the scan, Windows XP identifies any newly-shared resources, such as a printer that has just gone online as a shared printer, or a folder that has just been shared.

If this is not needed for you, this feature can be disabled and XP will work faster.

Method 1:

Disable the automatic search for network printers and folders by changing folder options:To disable the automatic search for network printers and folders, follow these steps:
1.Double Click My Computer ,Click Tools menu ,Select Folder Options
2.Click the View tab.
3.In the Advanced Settings list, click to clear the Automatically Search for Network Folders and Printers check box.
4.Click OK.

Method 2:Disable the automatic search for network printers and folders by changing the registry key:To change the registry key to disable automatic search for network printers and folders , follow these steps:
1.Click Start, type regedit in the Start Search box, and then press ENTER.
2.Locate the following registry subkey:
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced
3.Right-click System, point to New, and then click DWORD Value.
4.Type NoNetCrawling, and then press ENTER.
5.Double-click NoNetCrawling.
6.In the Value data box, type 1, and then click OK.
7.Close Registry Editor.

Source: Mocrosoft Support &   http://doputtur.blogspot.com/

Read More

How To Change the Default Backup Path in SQL Server

When installing SQL Server you also set up the default backup folder, but how can this folder be changed later?
In SQL Server 2005 and before there is no built-in mechanism.
In SQL Server 2005 or before, this information is saved in the registry. So you need to change the registry. It will be saved in
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQLServer
In the above registry, the BackupDirectory string value is the place where the default backup directory is stored.

After changing this, you do not need to restart the SQL Server.
In SQL Server 2008 and onwards, there is an option to change this.
In SQL Server Management Studio, right click the server and select Facets,

Under the Server Facet, you can change BackupDirectory.

Read More

How to Manually Uninstall SQL Server 2005

Sometimes, you may find that, though you can't see any SQL Server 2005 instance in the programs list and when you try to install SQL Server 2005, you get a messages saying that there is already a SQL Server instance or some components such as SQL Server Management Studio installed. The reason for this is the existence of corrupted SQL Server instance and you need to remove the SQL Server instance manually.

To do this run the following command from the command prompt:


"%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe /Remove"

Uninstall the SQL Server components one at a time until all the SQL Server components are uninstalled.

Note: Add or Remove Programs also runs the ARPWrapper.exe program by using the /Remove option. However, the reference to the ARPWrapper.exe program may have been deleted. Make sure that all the services (if they exists) relevant to this SQL Server instance is stopped.

Read More

XP Services-Not Needed for All

In XP OS, many services are not at all needed for everyone.These services, if enabled will consume the memory thereby making the process slow. However, you can disable these services and make the system work faster.

Some of the not needed services to all are listed below.

Alerter
ClipbookComputer Browser
Distributed Link Tracking ClientFast User Switching
Help and Support - (If you use Windows Help and Support leave this enabled)
Human Interface Access Devices
Indexing Service
IPSEC ServicesMessengerNetmeeting Remote Desktop Sharing (disabled for extra security)
Portable Media Serial Number
Remote Desktop Help Session Manager (disabled for extra security)
Remote Procedure Call LocatorRemote Registry (disabled for extra security)
Remote Registry Service
Secondary Logon
Routing & Remote Access (disabled for extra security)
Server
SSDP Discovery Service - (Unplug n' Pray will disable this)
Telnet
TCP/IP NetBIOS HelperUpload Manager
Universal Plug and Play Device Host
Windows Time
Wireless Zero Configuration (Do not disable if you use a wireless network) Workstation

To disable these services:

Go to Start and then Run and type "services.msc"
Double click on the service you want to change
Change the startup type in the Properties window to 'Disable"

Click Apply-OK, Close.

Tool for safe and fast XP

Safe XP

Version 1.5.7.14 - July 14, 2005

You can also use Safe XP tool for customising the services.

Safe XP allows users to quickly tweak various security and privacy related settings in XP. The options include Media Player settings, Services settings (error reporting, time synch, remote registry etc.), as well as and option to remove items from the Start menu, network security settings and more.

Safe XP improves your system performance and makes Windows to run faster, more secure and reliable!

in the above Screen shot-Recommended settings used.

The main features of this tool are:

• It allows you to take control of your PC.
• Make Windows to run faster and more secure.
• Protect your privacy and strength Internet protection.
• Disable Spyware-like activities of Windows XP (also 2000&ME&98) Operating System, Media Player, Internet Explorer and Outlook.
• Disable unnecessary Windows services like System updates, error reporting and much more...
• Prevent Internet attacks, any RPC/DCOM related vulnerabilities and fix exploits like DSO.
• Disable script-based attacks on Windows Media Player, Internet Explorer and Outlook.
• Block Windows Messenger (spam) vulnerabilities.
• Restrict the actions of potentially dangerous "HTA" (Hypertext Application) capabilities in any version of Windows.
• It does not need any DLL or another file(s). It is just a single "EXE" file: SafeXP.exe
• No installation necessary.

To download the tool visit the home page below.

 www.theorica.net/ 

Source : 

ttp://doputtur.blogspot.com/

Read More