Re: missing DTS connections
- From: "Talonsys" <talon@xxxxxxxxxxxx>
- Date: Thu, 7 Apr 2005 02:19:02 -0700
Sue
I ran the component checker and it reports that MDAC is OK!
"Sue Hoegemeier" wrote:
> You can check your MDAC installation using component
> checker. You can download the tool from:
> http://msdn.microsoft.com/data/downloads/tools/default.aspx
> You can find more information on the tool in the following
> article:
> Component Checker: Diagnose problems and reconfigure MDAC
> installations
> http://support.microsoft.com/?id=307255
>
> -Sue
>
> On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
> <talon@xxxxxxxxxxxx> wrote:
>
> >I am running SQL server 2000 service pack 3 on a windows XP professional
> >service pack 2 machine. There are four developers using the same
> >configuration.
> >
> >All of us have missing connections in the DTS designer. All that is
> >available are the following:
> >Microsoft OLEDB provider for sql server
> >Text File(source)
> >Text File (Destination)
> >Microsoft datalink
> >
> >We have no connections to Excel, Access Oracle etc.
> >
> >When I checked the Microsoft Datalink properties dialogue there are also
> >missing OLEDB providers so the issue appears to be with the OLEDB drivers.
> >I tried re installing MDAC however XP generated an error stating that MDAC
> >is up to date.
> >I suspect that the issue is due to a windows update that was automatically
> >applied as I built a new machine and installed only XP ,Sql server ,office
> >2003 and Visual studio enterprise architect 2003. After the initial
> >installation all the connections were available however after applying
> >automatic updates the machine lost all the connections.
> >
> >This fault is causing us no end of problems and we desperately need a
> >solution.
> >Thank you in advance
> >
> >LLoyd Faber
>
>
.
- References:
- missing DTS connections
- From: Talonsys
- Re: missing DTS connections
- From: Sue Hoegemeier
- missing DTS connections
- Prev by Date: Re: "Server does not exist or access is denied"
- Next by Date: Netstat TIME_WAIT on SQL Server Connections
- Previous by thread: Re: missing DTS connections
- Next by thread: server group error
- Index(es):
Relevant Pages
|
