Hi,
Any pointers on identifying the Error 429 (can't create ActiveX Object) in
my tiny VB app that simply uses a DTS object to remotely upload Access2000
data to a SQLServer2000 database. In house (developement machines) there is
no problem running the utility. When installed on target box, it seems the
Access2000 preparation for the export works just fine--it's when the box
tries to connect with the remote SQLServer that the error is thrown.
Thanks in advance for anything you can do to help me identify this problem.
Michael Murphy
954-452-1047

Is it the DTS Package object that it cannot create ?

You will need to register the DTS dlls on each client

Redistributing DTS with your program
http://www.sqldts.com/default.aspx?6,105,225,0,1

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Michael D. Murphy" <mdmurphy (AT) scs-techresources (DOT) com> wrote

In article <eSrZcU#WDHA.2568 (AT) tk2msftngp13 (DOT) phx.gbl>, Allan Mitchell
<allan (AT) no-spam (DOT) sqldts.com> writes
identify exactly where the error occurred. Information such as the line
is really useful when trying to track down and error when you cannot
debug interactively. Add some line numbers and use Erl to return it to
your error handler. There are plenty of VB add-ins out that that can be
used to manage line numbering.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com