General discussion

Locked

SQL Server 7.0 Errors

By eric.fondriest ·
I recently uninstalled my SQL Server 7.0 120 day evaluation and installed the full production version. I have noticed a couple of problems.

1. Within Enterprise Manager, under SQL Server Group, the icon next to my SQL Server has the green arrow with a squiggly red vertical line to the right of it.

2. When I right-click on Data Transformation Services and select All Tasks, Import Data, I receive the following dialog box:
DTS Wizard Error: CoCreateInstance
Class not registered.
When I click on OK, I am taken to the first dialog box of the DTS Wizard.

Any help on these issues would be greatly appreciated.

Thanks.

This conversation is currently closed to new comments.

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

All Comments

Collapse -

SQL Server 7.0 Errors

by Veetel In reply to SQL Server 7.0 Errors

When you uninstalled, did you delete the mssql7 folder after it finished. If not, try that. When you install the full version, it will re-create the mssql7 folder and you should get a clean install.

Collapse -

SQL Server 7.0 Errors

by eric.fondriest In reply to SQL Server 7.0 Errors

The question was auto-closed by TechRepublic

Collapse -

SQL Server 7.0 Errors

by Father Jack In reply to SQL Server 7.0 Errors

Only 50% of an answer i'm afraid. The red squggly line as you describe it is meant to be there, dont panic.

Collapse -

SQL Server 7.0 Errors

by eric.fondriest In reply to SQL Server 7.0 Errors

The question was auto-closed by TechRepublic

Collapse -

SQL Server 7.0 Errors

by aetrevitt In reply to SQL Server 7.0 Errors

1. The green arrow means your SQL Server is running; the squiggly red vertical line to the right means you are already connected to your SQL Server.

2. The error "DTS WIZARD ERROR: CoCreateInstance - Class not Registered" most likely means your DTS .dll has been overwritten. Try re-registering DTSPkg.dll first, as a quick fix. If this doesn't work, then try the following:

(Re-)Apply SP1 or SP2
(Re-)Install Internet Explorer 5
Re-Register DTSPkg.dll [Regsvr32 \mssql7\binn\dtspkg.dll]

Anna Trevitt
ADS Ltd

Collapse -

SQL Server 7.0 Errors

by eric.fondriest In reply to SQL Server 7.0 Errors

The question was auto-closed by TechRepublic

Collapse -

SQL Server 7.0 Errors

by eric.fondriest In reply to SQL Server 7.0 Errors

This question was auto closed due to inactivity

Back to Networks Forum
7 total posts (Page 1 of 1)  

Hardware Forums