Excel and other connections disappeared from DTS designer

#1

My DTS designer has only these connections:

-SQL Server
-Text file
-Microsoft data link
-Other connection

and Excel, Access, HTML and other are missing.

I am suspecting this is a result of SP3, but SP3a seem didn't fix the
problem.

Is it a known issue?

Thanks,

-Stan

#2

There are more than one PC affected by this and the only common reason is
SP3 although I am not sure....

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

I would try a reinstall of MDAC first

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Stan" <nospam (AT) yahoo (DOT) com> wrote in message
news:OZ627rSTDHA.1552 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
My DTS designer has only these connections:

-SQL Server
-Text file
-Microsoft data link
-Other connection

and Excel, Access, HTML and other are missing.

I am suspecting this is a result of SP3, but SP3a seem didn't fix the
problem.

Is it a known issue?

Thanks,

-Stan

#3

Hi Stan,

Have you reinstalled latest MDAC as suggested by Allan?
http://msdn.microsoft.com/library/de....asp?contentid
=28001860

Could you perform the following steps to check if it is successful? If
there is error message, please let me know.
1. Create a .udl file and then double-click it.
2. Click Provider tab. What providers did you see?

Bill Cheng
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------

Quote:

From: "Stan" <nospam (AT) yahoo (DOT) com
References: <OZ627rSTDHA.1552 (AT) TK2MSFTNGP12 (DOT) phx.gbl
#uOU9vSTDHA.600 (AT) TK2MSFTNGP12 (DOT) phx.gbl
Subject: Re: Excel and other connections disappeared from DTS designer
Date: Fri, 18 Jul 2003 10:31:42 -0400
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <#S8yjkTTDHA.3192 (AT) tk2msftngp13 (DOT) phx.gbl
Newsgroups: microsoft.public.sqlserver.dts
NNTP-Posting-Host: 12.148.36.131
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.dts:36264
X-Tomcat-NG: microsoft.public.sqlserver.dts

There are more than one PC affected by this and the only common reason is
SP3 although I am not sure....

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message
news:#uOU9vSTDHA.600 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
I would try a reinstall of MDAC first

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Stan" <nospam (AT) yahoo (DOT) com> wrote in message
news:OZ627rSTDHA.1552 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
My DTS designer has only these connections:

-SQL Server
-Text file
-Microsoft data link
-Other connection

and Excel, Access, HTML and other are missing.

I am suspecting this is a result of SP3, but SP3a seem didn't fix the
problem.

Is it a known issue?

Thanks,

-Stan

#4

Quote:

Could you perform the following steps to check if it is successful? If
there is error message, please let me know.
1. Create a .udl file and then double-click it.
2. Click Provider tab. What providers did you see?

When I create an empty udl file and click on it, I have this message:

Properties you entered cannot be saved because the Data Link file is
inaccessible.
Ensure that the hard drive or network share is still available.

Is it MDAC issue? I have never seen this before...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Excel and other connections disappeared from DTS designer

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Excel and other connections disappeared from DTS designer - 07-18-2003 , 07:50 AM

Re: Excel and other connections disappeared from DTS designer - 07-18-2003 , 09:31 AM

Re: Excel and other connections disappeared from DTS designer - 07-23-2003 , 12:58 AM

Re: Excel and other connections disappeared from DTS designer - 07-23-2003 , 06:46 AM