General discussion

Locked

Can't access SQL Books Online at desktop

By kaypaul ·
My dekstop is on Windows XP professional hooked up to my office LAN. Whenever, I try to start Books Online from the Start, Programs, Microsoft SQL Server, Books Online it can't run the program.

The error message it displays is" Cannot open the file: C:\Program Files\Microsoft SQL Server\80\Tools\Books\SQL80.col".

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by ReWrite In reply to Can't access SQL Books On ...

That is the default location for the online books when sql server is installed on a pc. Did you verify that the file is actually located at that location? Also, the proper command for the shortcut to open the online books is:

C:\WINDOWS\hh.exe "C:\Program Files\Microsoft SQL Server\80\Tools\Books\SQL80.col"

Verify that this command is correct in your shortcut. Also verify that hh.exe is in your systemroot directory (either c:\windows or c:\winnt depending on your installation).

Cheers.

RW

Collapse -

by kaypaul In reply to

I have checked and the proper command for the shortcut is correct. The "hh.exe" is found in c:\windows subdirectory.

What if, I reinstall SQL or just copy some related files for this program?

Collapse -

by ReWrite In reply to Can't access SQL Books On ...

The hh.exe file is there but is the sal80.col file located in the C:\Program Files\Microsoft SQL Server\80\Tools\Books\ directory? If it is, what are the permissions on the file? Also, is the full path to the file in the shortcut surrounded in double quotes as shown in the first example?

Cheers.

RW

Collapse -

by kaypaul In reply to

The hh.exe and sql80.col are there. The full path is correct using double quote. The permissions are for a system
admin profile.

Collapse -

by ReWrite In reply to Can't access SQL Books On ...

The default install should give at a minimum read/write access for Admins, System, Power Users and Everyone for the hh.exe and the entire directory for the help files. If you are logging in as anything other than an Admin your problem lies in the permissions. If you are logging in as an Admin then you might want to reinstall the help files and try them again.

Cheers.

RW

Collapse -

by kaypaul In reply to

Poster rated this answer.

Collapse -

by bhaskarreddy In reply to Can't access SQL Books On ...

This is the one of the common scenario. It should be fine when the file location is confirmed in documents and settings folder. The name of the file is: hhcolreg.dat

Take care.

Collapse -

by kaypaul In reply to

Unable to find "hhcolreg.dat" in my laptop. I am running in a LAN environment.

What is my next step, please?

Back to Windows Forum
8 total posts (Page 1 of 1)  

Related Forums