Re: Missing Connection Objects in DTS Toolbar

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

From: Brian O'Connell (BrianOConnell_at_discussions.microsoft.com)
Date: 01/11/05 

Date: Tue, 11 Jan 2005 06:59:06 -0800

Thanks for the try. I started with the dll you mentioned to no avail, then
moved on to all the others both ado and mdac common area folders. Still
nothing.

This is very frustrating because I also support many apps that I have to
load and if I re-image, all the rebuilding and then it will just happen again
when I hit the bad app. Our department even gets charged a good sum for
re-images and on top of that I have a boss that does not believe in
re-imaging!

Thanks anyway,
Brian

"Allan Mitchell" wrote:

> Unfortunately I would have done as per Michael.
>
> Have you tried also registering the DTS dlls manually? This does sound more
> MDAC relted though.
>
> I have also had problem with things like this and believe it or not
> registering the single dll MSADO15.dll fixed it.
>
>
>
> --
>
>
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
>
> "Brian O'Connell" <BrianOConnell@discussions.microsoft.com> wrote in message
> news:4E696B3B-BE03-4F1C-AE97-6E9B62956F86@microsoft.com...
> > Hello,
> >
> > I have a issue with missing and non-operational Connection objects on the
> > DTS Toolbar. I am using SQL Server 2000 in a Windows 2000 environment.
> >
> > The following connection objects are missing:
> > Excel,
> > Access,
> > Dbase5,
> > HTML,
> > Paradox
> >
> > and Microsoft Data Link and Other ODBC Sources will not work.
> >
> > Please, can anyone help? I seem to have lost the objects after installing
> > certain software (not 100% nailed down), but uninstalls of applications
> > and
> > re-installs of MDAC/SQL Server utilities, and Jet do not help.
> >
> > Anyone know how can I get these drivers wiped clean so a re-install will
> > fix
> > the corruption?
> >
> > Michael Cheng [MSFT] was helping someon with the same problem (see below),
> > but nothing has worked so far...
> >
> > Thanks much,
> >
> > Brian O'Connell, DBA
> > City of Charlotte
> > boconnell@ci.charlotte.nc.us
> >
> > "Michael Cheng [MSFT]" wrote:
> >
> >> Hi Jason,
> >>
> >> Thanks for your reply!
> >>
> >> I think we'd better perform the following steps to narrow down this
> >> issue:
> >>
> >> 1. Backup the file c:\windows\sqlstp.log and c:\windows\sqlsp.log first
> >>
> >> 2. Re-Install SQL Server Client Tools
> >> We are able to reinstall SQL Server Client Tools only from SQL Server
> >> Setup
> >> Disk
> >>
> >> 3. Assuming it is the Server A that you are not able to see connection
> >> objects. Use Server B, which could see all connection objects as expected
> >> when it's SQL Server Enterprise Manager connects to (local). Register
> >> Server A in Server B's Enterprise Manager, then open DTS package in
> >> Server
> >> A to see whether you could see all connection objects in the Server A's
> >> Enterprise Manager.
> >>
> >> 4. Follow the Knowledge base article below to re-install SQL-DMO
> >>
> >> INF: Enabling SQL DMO Clients Without Installing the Client Side
> >> Utilities
> >> http://support.microsoft.com/kb/248241
> >>
> >> 5. If all these steps fails, please send me the files you backuped in
> >> step
> >> 1. I would like to confirm that all DLL are registered correctly. My
> >> email
> >> is v-mingqc@online.microsoft.com (please remove "online" as it's only for
> >> SPAM)
> >>
> >> Thank you for your patience and corporation. If you have any questions or
> >> concerns, don't hesitate to let me know. We are always here to be of
> >> assistance!
> >>
> >>
> >> Sincerely yours,
> >>
> >> Michael Cheng
> >>
> >> Online Partner Support Specialist
> >> Partner Support Group
> >> Microsoft Global Technical Support Center
> >> ---------------------------------------------------------------
> >> Get Secure! - http://www.microsoft.com/security
> >>
> >> This posting is provided "as is" with no warranties and confers no
> >> rights.
> >> Please reply to newsgroups only, many thanks!
> >>
> >>
> >
> >
> >
> >
> >
> >
> > Manage Your Profile |Rules of Conduct
> > ©2005 Microsoft Corporation. All rights reserved. Terms of Use |Trademarks
> > |Privacy Statement
> >
>
>
>

Relevant Pages

  • Error loading unmanaged dll from managed code
    ... I have a C# class library that has to draw upon an unmanaged, C++, ... this library is to be used, the C++ dll is built and placed in C:\temp ... Everything is great until the test driver program makes a call to ... prior to the re-image.) ...
    (microsoft.public.dotnet.languages.csharp)
  • Callback dll and <TMP>{Product code} or <TEMP>{Product code}
    ... In the following Microsoft post: ... We are told the following with regard to file location for a Callback dll: ... If you are using Microsoft SQL Server 2000 Desktop Engine SP3a, ...
    (microsoft.public.sqlserver.msde)