Missing Connection Objects

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jason (jason2004_at_online.nospam)
Date: 12/02/04

  • Next message: Viet: "Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()" 
    Date: Thu, 2 Dec 2004 09:23:06 -0800

    Hello, I installed MS Office 2003 and SQL Server 2000. However, when I went
    to create a DTS pkg, I found that the following connection objects are
    missing:
    Excel,
    Access,
    Dbase5,
    HTML,
    Paradox

    Can someone please tell me what is going on? I am wondering if it has
    something to with MDAC, Office 2003, or any of the new security patches.

    This problem occurred after I re-imaged my system.

    Thanks in advance,
    Jason

  • Next message: Viet: "Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()"

    Relevant Pages

    • Missing Connection Objects
      ... I installed MS Office 2003 and SQL Server 2000. ... to create a DTS pkg, I found that the following connection objects are ... something to with MDAC, Office 2003, or any of the new security patches. ...
      (microsoft.public.sqlserver.setup)
    • Missing Connection Objects
      ... I installed MS Office 2003 and SQL Server 2000. ... to create a DTS pkg, I found that the following connection objects are ... something to with MDAC, Office 2003, or any of the new security patches. ...
      (microsoft.public.sqlserver.dts)
    • Does Bulk Insert require different permission to a SQL Sever database?
      ... I am trying to transfer data from Excel to a table in SQL Server. ... created two connection objects. ... Set objConnTest = New ADODB.Connection ... The other connection object which connects successfully to the Excel ...
      (microsoft.public.vb.database.ado)
    • Re: Does Bulk Insert require different permission to a SQL Sever database?
      ... I am trying to transfer data from Excel to a table in SQL Server. ... created two connection objects. ... The other connection object which connects successfully to the Excel ...
      (microsoft.public.vb.database.ado)
    • DTS Excel Connection Object is not recognized
      ... I installed MS Office 2003 and SQL Server 2000. ... to create a DTS pkg that uses the Excel connection object, ... Excel connection in the DTS program? ...
      (microsoft.public.sqlserver.setup)