Re: missing DTS connections

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

.

Relevant Pages

  • Re: msadox.dll error -2147024770
    ... I have checked MDAC 2.8 installation and it suppose to update ... What is the version of msadox15.dll file on your PC after MDAC ... Did Component Checker show any errors or not ...
    (microsoft.public.vb.database.ado)
  • Re: missing DTS connections
    ... I ran the component checker and it reports that MDAC is OK! ... >>All of us have missing connections in the DTS designer. ... >>installation all the connections were available however after applying ...
    (microsoft.public.sqlserver.connect)
  • Re: MDAC Issue
    ... Checker" should be useful for troubleshooting the problem. ... you can't install the MDAC downloaded from MSDN. ... Microsoft Data Access Components Installation ...
    (microsoft.public.data.odbc)
  • Re: SBS Exchange 2003: too many "Current Sessions" opened
    ... SBS 2008 does include the option during installation, to install fresh or to perform a migration installation, which allows you to introduce it into an existing SBS 2003 organizations. ... Windows Small Business Server 2008 Unleashed ... Since exchange defaults to accepting ... IF, after a week, you are still seeing some connections, try *DISABLING* ...
    (microsoft.public.windows.server.sbs)
  • Re: Packaging Wizard error -2147221163 more info
    ... REMOVE it before reinstalling? ... it deals with a corrupted MDAC installation on the computer. ... > corruption has been reported by several people who use IBM Client Access. ...
    (microsoft.public.access.devtoolkits)
Loading