DTS - Invalid Interface String

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
This might help
Redistributing DTS with your program
http://www.sqldts.com/default.aspx?6,105,225,0,1
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Mario Cappa" <mario[dot]cappa@.arcott.it> wrote in message
news:uQs5MDA7EHA.3236@.TK2MSFTNGP15.phx.gbl...
> 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
>

DTC Service Account

For those that use it, what service account do you run your DTC on? Is it
the same as your MSSQLServer service account?
It is a mtter of preference
You jjust weant to make sure the account has necessary priveleges
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"Jeff Ericson" wrote:

> For those that use it, what service account do you run your DTC on? Is it
> the same as your MSSQLServer service account?

DTC Service Account

For those that use it, what service account do you run your DTC on? Is it
the same as your MSSQLServer service account?It is a mtter of preference
You jjust weant to make sure the account has necessary priveleges
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"Jeff Ericson" wrote:

> For those that use it, what service account do you run your DTC on? Is it
> the same as your MSSQLServer service account?

DTC Service Account

For those that use it, what service account do you run your DTC on? Is it
the same as your MSSQLServer service account?It is a mtter of preference
You jjust weant to make sure the account has necessary priveleges
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"Jeff Ericson" wrote:
> For those that use it, what service account do you run your DTC on? Is it
> the same as your MSSQLServer service account?