Re: Missing Connection Objects in DTS Toolbar

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 01/11/05 

Date: Tue, 11 Jan 2005 06:26:29 -0000

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

  • Re: SQL 2000 - Connection Error with DTS Packages
    ... After I changed all SQL Server 'Database Connection' steps in each of my ... did the "Schedule Package" option when you right click a DTS package name ... What I had been using to run the DTS package in the job step was: ...
    (microsoft.public.sqlserver.dts)
  • Re: Dealing with Web Mining on Apache Log
    ... I thought that you could do the loading with DTS and SQL server ... The other two are more sequence analysis ...
    (microsoft.public.sqlserver.datamining)
  • Re: Identity OR Firewall???
    ... Do you have the DTS dlls on your Web box? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> Allan Mitchell MCSE,MCDBA, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL server 2005 & DTS from SQL 2000
    ... As the DTS packages that i need to transfer into the server will also need ... We installed the Legacy Components with our SQL Server 2005 installs. ...
    (microsoft.public.sqlserver.dts)
  • Enterprise Manager Server Registration General Network Error
    ... I'm having problems Registering servers in Enterrpise Manager. ... register SQL server, types server name, uses NT Authentication. ... returned is "General Network Error, ... SQL Server in question is newly build SQL 2000 SP3a with NO load on it ...
    (microsoft.public.sqlserver.connect)