DTS - Invalid Interface String

From: Mario Cappa (mario[dot)
Date: 12/27/04


Date: Mon, 27 Dec 2004 11:42:45 +0100

Hello,
i'm writing an application (using Delphi 7) in which i must use a DTS to
export data from a MSSQLServer database to a Paradox one. I made it up on a
machine where i can have it working properly, but when i try to use the same
application on another computer i get an "invalid interface string" error
right when the DTS is called
Working machine has SQLServer and Delphi 7 installed running on WinXP Pro
SP2, not working machine has only same OS installed. Note that that one is
the only error i get trying to access data that are on a remote server, i
can use properly every table but not using DTS.
Any suggestions on what i forgot?

Tia

Mario



Relevant Pages

  • Re: Progress information
    ... SQL DMO has nothing to do with DTS. ... I have never used Delphi but would not expect ... Try registering "Microsoft DTSPackage Object Library" ...
    (microsoft.public.sqlserver.dts)
  • handling dts events in delphi
    ... I'm writing an application with delphi 7 and I must use dts to copy objects ... and data from one server to another. ... Executing steps is working fine, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL server DTS
    ... > dynamically change a SQL2000 DTS from VB is this also possible in DELPHI? ... If VB can do it then so can Delphi. ... The strange part isn't so much that he had an accent. ...
    (borland.public.delphi.database.ado)
  • Re: SQL server DTS
    ... dynamically change a SQL2000 DTS from VB is this also possible in DELPHI? ... > Joćo Louro ...
    (borland.public.delphi.database.ado)