Results 1 to 2 of 2

Thread: Dts

  1. 03-11-2003, 04:23 PM #1
    mcrowley
    mcrowley is offline Registered User
    Join Date
    Jan 2003
    Posts
    6

    Dts

    I have a VB application that calls a DTS job that is saved as local Package. Everything runs fine when the application is installed on a users PC but only if SQL enterprise manager is installed on the users PC as well. If EM is not installed on the user PC I get the following error when I try to run the app:

    error encountered trying to extract data. the error was number 429: ActiveX component can't create object.

    I want to be able to run the application on the users PC without having to install enterprise manager. Any ideas would be greatly appreciated.
    Reply With Quote Reply With Quote
  2. 03-12-2003, 03:15 AM #2
    andi_g69
    andi_g69 is offline Registered User
    Join Date
    Nov 2002
    Location
    DE
    Posts
    246
    Probably OLE DB components are missing on the client. SQL Client tools (e.g. EM) installation brings MDAC which provides the OLE DB components and ODBC drivers, etc.

    I think there is no way, you will have to apply the proper MDAC version.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules