Hello, I installed MS Office 2003 and SQL Server 2000. However, when I went
to create a DTS pkg, I found that the following connection objects are
missing:
Excel,
Access,
Dbase5,
HTML,
Paradox

Can someone please tell me what is going on? I am wondering if it has
something to with MDAC, Office 2003, or any of the new security patches.

This problem occurred after I re-imaged my system.

Thanks in advance,
Jason

You may well have a problem with MDAC and/or the DTS dlls.

Reregister the DTS dlls first and see if that helps.

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Jason" <jason2004 (AT) online (DOT) nospam> wrote

Hi Jason,

First of all, I would like to show my gratitude to MVP Allan's greatest
answer!

I cannot agree more that some DLLs and Registries must be missing in your
machine. However, please understand that it might have to take a long time
for us to collect sufficient information narrowing down this issue
regarding this strange issue. Please try the link in MVP Allan's reply and
let me know whether we all hit the right track.

Based on my scope, first of all, have you upgraded to Jet 4.0 Service Pack
8? If not, I would like to strongly recommend you install this service
pack. You could find the download in the following knowledge base articles:

Information about Jet 4.0 Service Pack 8
http://support.microsoft.com/kb/829558

Secondly, run the T-SQL below in Query Analyzer and let me know the result
---
USE MASTER
GO
xp_enum_oledb_providers
GO
---
I would like to confirm Microsoft.Jet.OLEDB.4.0 and other providers are
registered.

Thirdly, if everything was backuped, I would like to recommend you delete
your profile in the machine and then login again to see whether this will
resolve your issue.

Hope this helps and 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!

Hi Michael,

Thanks for the detailed reply. I've tried all of your suggestions, but my
connection objects are still missing.

Specifically, I installed Jet 4.0 Svc Pack 8, re-registered all 4 dlls, and
I ran the script you proviced. Here are provider names:

SQLOLEDB
DTSPackageDSO
SQLReplication.OLEDB
MSDMine
OraOLEDB.Oracle
ADsDSOObject
MSOLAP
MSOLAP
MSDAIPP.DSO
MSSearch.CollatorDSO.1
MSDASQL
Microsoft.Jet.OLEDB.4.0
MSDAOSP
MSDAORA
MSIDXS

As you can see, MS Jet is listed.

I am not able to delete my profile, however, I did log into my system under
a different domain account and the problem still exists. Any further
suggestions? I've never seen this problem before.

Background:
My system was re-imaged with a clean install of Windows XP SP1, I then
installed Office 2003 SP3, and SQL Server 2000 and Analysis Services. When I
went to create a DTS pkg, my connection objects were missing.

Please help. Thanks.

Jason




"Michael Cheng [MSFT]" wrote:

Thanks Allan! I appreciate your advice. I did follow yours and Michael's
instructions, however, my connection objects are still not being displayed.
Any other ideas?

Thanks,
Jason


"Allan Mitchell" 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 (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!

"Michael Cheng [MSFT]" wrote:

Hello,

Many of us in our group have the exact same problem! I have followed the
advice so far and still have the problem. Some machines in the ogranization
do not have the problem, including if use Enterprise manager on the server I
am trying to create a DTS package on.

Has Jason's issue been resolved? I need this fixed, pleasssssseee....

Thanks,
Brian O'Connell, DBA
City of Charlotte
boconnell (AT) ci (DOT) charlotte.nc.us

"Michael Cheng [MSFT]" wrote:

Hi Michael,

I followed steps 1-4 of your mail below, but my Jet connection objects are
still not being recognized in the DTS program. As such, I sent you an email
with my setup logs and a picture of the missing connection objections. A
co-worker of mine is having the same issue when he installed SQL Server 2000
Developer Edition.

Please advise on how to resolve the issue. Thanks.

jason

"Michael Cheng [MSFT]" wrote:

Hi Jason,

Welcome Back!

Please follow the steps below and let me know whether it works

1. Download latest Jet and install it, which should be Jet 4.0 Service Pack
8, select a correct download for your operating system from the Knowledge
Base article below

Information about Jet 4.0 Service Pack 8
http://support.microsoft.com/kb/829558

2. Delete your profile and then recreate it by login, which will refreshed
the keys under HKEY_CURRENT_USER.
(NOTE that it is highly appreciated if you have BACKUP all important files
in your profile before you delete it)

Hope it helps this time.



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!