 | |
Missing Connection Objects in DTS Toolbar
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Missing Connection Objects in DTS Toolbar -
01-10-2005
, 04:01 PM
|
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 (AT) online (DOT) 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
Quote:
|
Privacy Statement |
#2
| |||
| |||
|
|
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 (AT) ci (DOT) 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 is v-mingqc (AT) online (DOT) 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 |
#3
| |||
| |||
|
|
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 (AT) discussions (DOT) microsoft.com> wrote in message news:4E696B3B-BE03-4F1C-AE97-6E9B62956F86 (AT) microsoft (DOT) 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 (AT) ci (DOT) 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 is v-mingqc (AT) online (DOT) 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 |
#4
| |||
| |||
|
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.