Re: Cannot open the SQL Server Books Online file SQL80.col

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Gail Erickson [MS] (gaile_at_online.microsoft.com)
Date: 04/20/04


Date: Tue, 20 Apr 2004 11:27:52 -0700

Out-of-date versions of the hhctrl.ocx file is probably the cause. You
should delete all copies of hhctrl.ocx on the disk that are not in the
\system32 folder. Make sure you have the latest version of the hhctrl.ocx
file (you can get this from Windows Update).

Some users have had success by re-registering the hhctrl.ocx file using
these instructions. From a command prompt window, type
regsvr32 /u hhctrl.ocx -- to unregister
regsvr32 hhctrl.ocx -- to re-register

Also, it sounds like you don't have the most recent version of Books Online.
You should download the January 2004 version from
www.microsoft.com/downloads. Enter SQL Server as the product and Books
Online as the keywords.

Regards,
Gail Erickson
SQL Server Doc Team
This posting is provided "AS IS" with no warranties, and confers no rights.

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:m5ka80hulvik2a9g0ga68029q3tcd1t3md@4ax.com...
>A couple of things you can check -
> On the machine with the problem, check the following
> versions of these files and compare them with versions where
> BOL is working:
> hhctrl.ocx
> hh.exe
> Out of date versions of these can cause problems.
>
> Also, right click on the books online shortcut, select
> properties and check the target. Verify that the paths for
> hh.exe and SQL80.col point to the correct locations and have
> the correct paths. The target should look something like the
> following - depending on the locations for your files:
> C:\WINDOWS\hh.exe "C:\Program Files\Microsoft SQL
> Server\80\Tools\Books\SQL80.col"
>
> -Sue
>
> On Tue, 20 Apr 2004 07:16:03 -0700, jrusso
> <jacob@imaging101.com> wrote:
>
>>Can someone please help? I am going out of my wits with this issue!
>>
>>I have Un-Installed SQL-Server, Deleted ALL References, Re-installed,
>>Re-applied Sp3a, Downloaded and applied the Help Update for this year. I
>>have found and tried verious HH.EXE and HHCTRL.OCX files as mentioned in
>>some other posts and other websites. Nothing seems to help.
>>
>>I have the following configuration:
>> Dell Inspiron 8200
>> Win XP Pro
>> SQL Server 2000 PERSONAL Edition
>> Visual Studio 6
>> Visual Studio .NET
>>
>>I have the latest with the latest Service Packs and updates for
>>everything. I still get the error:
>>
>> Cannot open the file: C:\Program Files\Microsoft SQL
>> Server\80\Tools\Books\SQL80.col
>>
>>I believe there might be a problem with the PERSONAL Edition installation.
>>The SQL80.COL file did NOT exists after the FULL install even thought all
>>the other chm's and chi's. I copied it from another computer I have
>>that works fine but with Small Business Server. Still no good. I know
>>it has something to do with HTML Help but no clue as to what.
>>
>>Thanks,
>>Jacob
>



Relevant Pages

  • Re: Cannot open the SQL Server Books Online file SQL80.col
    ... it sounds like you don't have the most recent version of Books Online. ... Enter SQL Server as the product and Books ... >> Visual Studio .NET ... >>I believe there might be a problem with the PERSONAL Edition installation. ...
    (microsoft.public.sqlserver.msde)
  • Re: Cannot open the SQL Server Books Online file SQL80.col
    ... it sounds like you don't have the most recent version of Books Online. ... Enter SQL Server as the product and Books ... >> Visual Studio .NET ... >>I believe there might be a problem with the PERSONAL Edition installation. ...
    (microsoft.public.sqlserver.server)
  • Re: Cannot open the SQL Server Books Online file SQL80.col
    ... it sounds like you don't have the most recent version of Books Online. ... Enter SQL Server as the product and Books ... >> Visual Studio .NET ... >>I believe there might be a problem with the PERSONAL Edition installation. ...
    (microsoft.public.sqlserver.programming)
  • Re: Query training -- Complex queries
    ... > Update PositionsEOM ... Here you don't have a derived table, but a correlated subquery. ... UPDATE in Books Online. ... is not written for SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Linked Server: How to check if server exists?
    ... The root problem is described in the Books Online topic Batches. ... Rick Byham, SQL Server Books Online ... linked server don't run on those development machines not having that linked ...
    (microsoft.public.sqlserver.connect)