"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@nospam.co.uk> 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
>