missing DTS connections

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
You can check your MDAC installation using component
checker. You can download the tool from:
http://msdn.microsoft.com/data/downl...s/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
|||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/downl...s/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:
>
>