Windows Forum

Ask something
Discussion Locked

Can't access SQL Books Online at desktop

0 helpful
8 replies

by paulkayengheng

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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".

8 replies

by rewrite

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

by paulkayengheng

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?

by rewrite

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

by paulkayengheng

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

by rewrite

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

by bhaskarreddy

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.

by paulkayengheng

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

What is my next step, please?

This discussion is closed to new replies.