Very Computer

by **Teressa Laver** » Mon, 24 Apr 2000 04:00:00

I have been struggling with this problem for three days now, can anyone
assist. Problems only began after I had loaded Office 2000 Developer. I
have uninstalled and re-installed SQL7 twice and have loaded both SP1 and
SP2. I cannot create any Tasks in DTS, nor can I open/run existing Tasks or
packages. I have a feeling it has something to do with COM. I am trying
to avoid stripping of NT and formating the Drive , the error messages I
recieve are as follows:-

DTS : New Package - DTS Designer Error
Could Not Create Component Categories Manager
Click OK
No icons on Tasks

DTS : Highlight Repository - Error Message
An error occurred while trying to access the database information.
The msdb database could not be opened.

Any assistance greatly appreciated

Teressa Lavery

--
Teressa Lavery

by **C. E. Buttle** » Mon, 24 Apr 2000 04:00:00

Check to see that MSDE is not running. This is actually a version of SQL
Server that fits between Access and SQL Server. If it is running, then you
can't run SQL Server 7.0 for the same reason you can't run 6.5 and 7.0 on
the same machine at the same time.

> I have been struggling with this problem for three days now, can anyone
> assist. Problems only began after I had loaded Office 2000 Developer. I
> have uninstalled and re-installed SQL7 twice and have loaded both SP1 and
> SP2. I cannot create any Tasks in DTS, nor can I open/run existing Tasks
or
> packages. I have a feeling it has something to do with COM. I am trying
> to avoid stripping of NT and formating the Drive , the error messages I
> recieve are as follows:-

> DTS : New Package - DTS Designer Error
> Could Not Create Component Categories Manager
> Click OK
> No icons on Tasks

> DTS : Highlight Repository - Error Message
> An error occurred while trying to access the database information.
> The msdb database could not be opened.

> Any assistance greatly appreciated

> Teressa Lavery

> --
> Teressa Lavery

by **Teressa Laver** » Mon, 24 Apr 2000 04:00:00

Thanks for responding but ...
Looked under Services - MSDE not present. Have also uninstalled Office 2000
Developer Tools, Uninstalled SQL and OLAP, re-installed SQL, re-applied
SP2 - still the same error messages . . .

Teressa

by **Darren Gree** » Tue, 25 Apr 2000 04:00:00

>I have been struggling with this problem for three days now, can anyone
>assist. Problems only began after I had loaded Office 2000 Developer. I
>have uninstalled and re-installed SQL7 twice and have loaded both SP1 and
>SP2. I cannot create any Tasks in DTS, nor can I open/run existing Tasks or
>packages. I have a feeling it has something to do with COM. I am trying
>to avoid stripping of NT and formating the Drive , the error messages I
>recieve are as follows:-

>DTS : New Package - DTS Designer Error
>Could Not Create Component Categories Manager
>Click OK
>No icons on Tasks

>DTS : Highlight Repository - Error Message
>An error occurred while trying to access the database information.
>The msdb database could not be opened.

>Any assistance greatly appreciated

>Teressa Lavery

>--
>Teressa Lavery

Q. Why do I get the error "Could not create component categories
manager" or "Could not create an instance of the DTS package"?

A. This can happen after you have installed additional software
onto your SQL Server machine and certain DLLs have been overwritten with
a different version.

The main culprit is Comcat.dll (winnt\system32). DTS requires version
4.71, however certain software such as Visual Studio Service Pack 3 will
install version 5.

Replace the version 5 copy Comcat.dll with v4.71 from your SQL Server
CD-ROM.

--
Darren Green
SQL/DTS - http://www.swynk.com/friends/green/

by **Teressa Laver** » Tue, 25 Apr 2000 04:00:00

Thanks Darren, but I have already taken this step - now if I click on any
Data Item or the single Task item in DTS Designer, I get an Application
Error and SQL closes. My next step - reluctantly - will be to strip of NT
and Apps and re-install. A bit drastic I know but . . .

--
Teressa Lavery
MCSE MCT MCDBA

by **Darren Gree** » Tue, 25 Apr 2000 04:00:00

>Thanks Darren, but I have already taken this step - now if I click on any
>Data Item or the single Task item in DTS Designer, I get an Application
>Error and SQL closes. My next step - reluctantly - will be to strip of NT
>and Apps and re-install. A bit drastic I know but . . .

>--
>Teressa Lavery
>MCSE MCT MCDBA

You've got big problems, as if you didn't know!
My last guess would be to re-install IE5, then re-register the DTS DLLs

Regsvr32 \mssql7\binn\axscphst.dll
Regsvr32 \mssql7\binn\dtsffile.dll
Regsvr32 \mssql7\binn\dtspkg.dll
Regsvr32 \mssql7\binn\dtspump.dll
Regsvr32 \mssql7\binn\dtsui.dll
Regsvr32 \winnt\system32\sqlwoa.dll
Regsvr32 \winnt\system32sqlwid.dll

Hope it helps.
--
Darren Green
SQL/DTS - http://www.swynk.com/friends/green/

Very Computer

DTS Designer - Wont Load Tasks-Metadata

DTS Designer - Wont Load Tasks-Metadata

DTS Designer - Wont Load Tasks-Metadata

DTS Designer - Wont Load Tasks-Metadata

DTS Designer - Wont Load Tasks-Metadata

DTS Designer - Wont Load Tasks-Metadata

DTS Designer - Wont Load Tasks-Metadata